Basic Concepts - List of useful Oracle Apps Articles
Written by Anil Passi   
Saturday, 18 November 2006
A reader suggested that Apps Training Articles are quite scattered, hence suggested a single access point.

Please find a page that contains navigational links to articles on basic concepts. You will need to refer to other menu options too for training in specialised streams.

Return to Home Page ( http://oracle.anilpassi.com)

Confusion - Should I pursue the Path of  becoming a  Functional Consultant or Technical Consultant or Apps DBA?
Pre-requisites for learning Oracle Apps [as a Technical Consultant]



Basics Of Oracle Apps Training Material (Step by Step Learning of Oracle Apps)

What happens when you login to Oracle Apps
Why is it called apps
What is a profile option?
What is org_id. Why is it important.
Relationship between Applications and Modules
Where to find/deploy the code (Forms tier/Middle tier or DB Tier)
The testing cycle in Oracle Apps
Difference between forms and form functions and menu
What is a Concurrent Program
What is concurrent Manager
What is a Value set
What is a lookup in oracle apps
How does lookup differ from Value Sets
Descriptive Flexfield Basics in Oracle Apps
How to make context sensitive descriptive flexfields ( step by step)
Key Flexfields Basics
Setting up your PC for development environment
Your first custom form from scratch
Your first pl/sql concurrent program from scratch
Oracle FNDLOAD Script Examples
Restart or Bounce Apache in Oracle Apps 11i
Playing with CUSTOM.pll
Read Only Schema in Oracle APPS 11i
Create Oracle FND_USER with System Administrator ( Using Script ) 
A New Custom Form in Oracle Apps
Forms Customization Steps in Oracle Applications
Reports Customization Steps in Oracle Applications
Your first Migration program in Apps. Migrate Customers
FNDLOAD for Oracle Web ADI
API to Update FND_USER and Add Responsibility
Forms Personalization Example 1
Various Examples of Forms Personalizations [ Everything that you wanted to know about FP ]
Oracle Fusion Development Tools
Debugging In Oracle Applications
XML Publisher Concurrent Program Report
Audit Trail in Oracle Apps
Hierarchy Profile Options in Oracle Apps
Design and Development of Open Interfaces in Oracle Apps
Customization of Reports in Oracle Apps

How to find the Request Group for Concurrent program
Smart Descriptive Flexfields

Using XML Publisher with Pre-Printed Stationary  

Procure to Pay, Order to Cash, End to End Cycle Functional Documents

Release 12 related
Multi Org in Release 12
MO_GLOBAL- A deep look into R12 Multi Org Design



Oracle Workflows Training and Examples / Tutorials

Oracle Workflows Training Lesson 1
Oracle Workflows Training Lesson 2
Oracle Workflows Training Lesson 3
Oracle Account Generator Workflows Example
Workflows Notifications - Override Email address for all Notifications
Send binary attachments with Notifications in Workflows
Oracle Workflow Notifications Timeouts with Bank Holidays & Weekends
Basics of Oracle Workflows Engine
Oracle Workflows Access Protection Concepts


Interview Questions
Technical Interview Questions in Oracle Apps
iProcurement Interview Questions In oracle
Oracle HRMS Payroll Interview Questions


Oracle Framework 11.5.10 onwards { See OAF Menu for Full Listing }

XMLImporter in Oracle Applications Framework
iProcurement 11.5.10 ReBuild Charge Account
Java Concurrent Program with Example in Oracle APPS
Another usage of Java Concurrent Programs


iProcurement
iProcurement 11.5.10 ReBuild Charge Account
Oracle iProcurement Implementation Audio Visual Demo
iProcurement Interview Questions In oracle
iProcurement Implementation with Punchouts Step by Step approach
Load test Oracle iProcurement - XML Delivery
Scripts for iProcurement - XML Delivery load testing


Oracle Human Resources, Payroll & Migration
Forms Personalization in Oracle HRMS
Special Information Types -SIT in HRMS
Oracle Payroll Accounting Basics
Oracle HRMS API Employee People Migration
Migrate Special Information Types in HRMS
Oracle HRMS Payroll Interview Questions
HRMS Person Address Migration


Receivables
Future of TCA - Fusion & Release 12
Receipt API in Oracle Receivables
Undestanding TCA and how DQM works on top of TCA


Oracle Projects, Grants & Purchasing

Encumbrance Migration to Oracle Grants for Open Purchase Orders


Oracle General Ledger
GL Interface API to Import Journals
Splitting the instance into different Set Of Books

Fusion Related
http://oracle.anilpassi.com/oracle-fusion-development-tools.html


Miscellaneous Other articles

Which FND_USER is locking that table
Another usage of Java Concurrent Programs
Oracle Technical and Apps Functional Demo- Various Presentations
Switch off CUSTOM.pll programatically
Oracle Lease Management White Paper

Diagnostic Tools and Scripts in Oracle EBS 
Steps to implement Function Security in Oracle Order Management
Period End dealing in Oracle Order Management
Some commonly used scripts for Oracle EBS
Data Loader Concepts and Examples 
Pooled Accounts in Oracle Payables
Steps to invoke discoverer report from Oracle Applications
Basics of Accounting in Oracle ERP Part - I
Basics of Accounting in Oracle ERP Part - II
Flow of Accounting in Oracle eBusiness SUite - Primer
Forms Personalization - Best Practices
FNDLOAD - A dive into basics - A Presentation
CUSTOM.pll versus Forms Personalization - A Presentation
Debug Forms in Oracle eBusiness Suite
Email output of Concurrent Program Request


 

Return to Home Page ( http://oracle.anilpassi.com)

Comments (246)add
...
written by Mohan Dutt , November 18, 2006
Hi Anil:
You have a great blog!
I have started writing a blog on EBS OCP certification. Please let me know some tips how to improve it.
Thanks,
Mohan
...
written by Anil Passi , November 19, 2006
Hi Mohan

Excellent effort from you man. Keep it up.
I learnt a lot from users feedback and so will you in the due course. When I started this blog, I started writing papers on some complex solutions that I had implemented, without touching the basics. Then some readers demanded the basics, and obliged.

Hence my advice to you is, tell your readers in BOLD that their Feedback is important. Find out from your readers what are the hindrances that they face to get started. No one can guide you better than your own readers.

You are doing good work for a good cause, so keep it going !

Thanks
Anil
...
written by leenus , November 27, 2006
hi anil
U R blog is really cool.
can u tell me where can i find the basic concepts of OA frame work and wat r the thing an appsdba has to deal with OA frame work..
Thanx
Leenus
...
written by Anil Passi , November 27, 2006
OA Framework is java based. Hence firstly you need to get onto the right JDK version i.e. 1.3 or higher[applicable for 11.5.10]

Also ideally you should install JDBC Driver 9.2.0.6 for increased stablity of OA Framework[See Metalink Note 164317.1]

There is a very comprehensive & dedicated Metalink Note 275874.1 [Oracle Application Framework Configuration Notes Release 11i (11.5.10)]. This Metalink Note contains all the pre-reqs, interoperability patches & config steps.
...
written by leenus , November 27, 2006
hi anil
U R blog is really cool.
can u tell me where can i find the basic concepts of OA frame work and wat r the thing an appsdba has to deal with OA frame work..
Thanx
Leenus
...
written by Anil Passi , November 27, 2006
OA Framework is java based. Hence firstly you need to get onto the right JDK version i.e. 1.3 or higher[applicable for 11.5.10]

Also ideally you should install JDBC Driver 9.2.0.6 for increased stablity of OA Framework[See Metalink Note 164317.1]

There is a very comprehensive & dedicated Metalink Note 275874.1 [Oracle Application Framework Configuration Notes Release 11i (11.5.10)]. This Metalink Note contains all the pre-reqs, interoperability patches & config steps.
...
written by Yj , November 28, 2006
Hi Anil,

Can you please explain the hierarchy/precedence of profiles user-responsibility-application-site.But in addition to the above profile levels,11i have something called as organization and server.where these two will fit.

Thanks,
YJ
...
written by YJ , November 28, 2006
hi anil,

What is the difference between interface,conversion and migration?

Thanks,
YJ
...
written by Anil Passi , November 28, 2006
Hi YJ, I will definitely write up an article on interfaces tonight, which shall answer your remainder questions.
Profile article will be ready in next couple days.

Thanks,
Anil passi
...
written by Yj , November 28, 2006
Hi Anil,

Can you please explain the hierarchy/precedence of profiles user-responsibility-application-site.But in addition to the above profile levels,11i have something called as organization and server.where these two will fit.

Thanks,
YJ
...
written by YJ , November 28, 2006
hi anil,

What is the difference between interface,conversion and migration?

Thanks,
YJ
...
written by Anil Passi , November 28, 2006
Hi YJ, I will definitely write up an article on interfaces tonight, which shall answer your remainder questions.
Profile article will be ready in next couple days.

Thanks,
Anil passi
...
written by YJ , November 30, 2006
Anil,
Can u please provide the setup details for core HR and if possible the potential interview questions.
I request you for an overview of HR inteeligence.
...
written by Anil Passi , November 30, 2006
Hi YJ,

No worries, I Will provide a brief listing of HRMS implementation by this weekend.

Please check on Monday.

Thanks
Anil
...
written by Anil Passi , November 30, 2006
As requested, please find the two articles

Hierarchy Profile Options http://oracle.anilpassi.com/hi...tions.html

Also, another article that explains difference between migration/conversion & interface practices in Apps
http://oracle.anilpassi.com/open-interfaces-in-apps-ebs-best-practices.html

Next coming is building Interface using Java Concurrent Programs...

Thanks
Anil Passi
...
written by Sastry , November 30, 2006
Anil,
your site is very infromative. Can you touch upon writing fast formulas in application.

Thanks
Sastry
...
written by YJ , November 30, 2006
Anil,
Can u please provide the setup details for core HR and if possible the potential interview questions.
I request you for an overview of HR inteeligence.
...
written by Anil Passi , November 30, 2006
Hi YJ,

No worries, I Will provide a brief listing of HRMS implementation by this weekend.

Please check on Monday.

Thanks
Anil
...
written by Anil Passi , November 30, 2006
As requested, please find the two articles

Hierarchy Profile Options http://oracle.anilpassi.com/hi...tions.html

Also, another article that explains difference between migration/conversion & interface practices in Apps
http://oracle.anilpassi.com/open-interfaces-in-apps-ebs-best-practices.html

Next coming is building Interface using Java Concurrent Programs...

Thanks
Anil Passi
...
written by Sastry , November 30, 2006
Anil,
your site is very infromative. Can you touch upon writing fast formulas in application.

Thanks
Sastry
...
written by artur bakhtriger , December 01, 2006
Thank you so much. Great blog will visit over and over. Want to see you java concurent program.
Have a great day.
...
written by artur bakhtriger , December 01, 2006
Thank you so much. Great blog will visit over and over. Want to see you java concurent program.
Have a great day.
...
written by Anil Passi , December 04, 2006
Hi Ripal,

I am afraid, I do not have any setup docs on Enterprise asset managerEAM.

Thanks,
Anil
...
written by Anil Passi , December 04, 2006
Hi Amaresh,

I can tell you the version I worked upon...

Version 10.6 Year 1997
Forms 2.3 Character based front end.

Version 10.7 Year 1998
Forms 2.3 Character based front end.

Version 10.7 SC[Smart Client] Year 1998
Forms 4.5 D2K based front end.
Closely followed by NCA[forms libraries on server]


Version 11.03 Year 1999
11.0.1 or 11.0.3, Forms used jInitiator plugin


Version 11i Year 2000
11.0.x renamed keeping in mind the dotcom boom
...
written by Ripal , December 04, 2006
Hi Anil,
You are doing a great job.
My heartiest congratulations to you.
Do you have any EAM set up?
Regards
Ripal
...
written by amaresh , December 04, 2006
Hi Anil,

i want to know the Oracle E-Biz suite version devlopments from the first version to latest and do mention the year of release.pls let me know what are features added to each version when compare to previous version.else give me the link where i can get the details of the above.


Thanks,
Amaresh.
...
written by Anil Passi , December 04, 2006
Hi Ripal,

I am afraid, I do not have any setup docs on Enterprise asset managerEAM.

Thanks,
Anil
...
written by Anil Passi , December 04, 2006
Hi Amaresh,

I can tell you the version I worked upon...

Version 10.6 Year 1997
Forms 2.3 Character based front end.

Version 10.7 Year 1998
Forms 2.3 Character based front end.

Version 10.7 SC[Smart Client] Year 1998
Forms 4.5 D2K based front end.
Closely followed by NCA[forms libraries on server]


Version 11.03 Year 1999
11.0.1 or 11.0.3, Forms used jInitiator plugin


Version 11i Year 2000
11.0.x renamed keeping in mind the dotcom boom
...
written by Ripal , December 04, 2006
Hi Anil,
You are doing a great job.
My heartiest congratulations to you.
Do you have any EAM set up?
Regards
Ripal
...
written by amaresh , December 04, 2006
Hi Anil,

i want to know the Oracle E-Biz suite version devlopments from the first version to latest and do mention the year of release.pls let me know what are features added to each version when compare to previous version.else give me the link where i can get the details of the above.


Thanks,
Amaresh.
...
written by raju , December 07, 2006
Hi Anil, Please let me know how to default/replace the Item Master Rates from the latest PO Item rate.

Thanks

raju
...
written by raju , December 07, 2006
Hi Anil, Please let me know how to default/replace the Item Master Rates from the latest PO Item rate.

Thanks

raju
...
written by MP , December 08, 2006
Hi Anil,
Your blog is very informative. Thanks for all the useful articles.
I am going to ask you a very basic question. I wanted to know if there is a way to get the source code for self-service forms. There is a Wokflow related form Navigation from System Administrator Reponsibility -> Workflow>>Administrator Workflow >>Notifications form. I am trying to find the source code for this form.
Thanks, MP
...
written by MP , December 08, 2006
Hi Anil,
Your blog is very informative. Thanks for all the useful articles.
I am going to ask you a very basic question. I wanted to know if there is a way to get the source code for self-service forms. There is a Wokflow related form Navigation from System Administrator Reponsibility -> Workflow>>Administrator Workflow >>Notifications form. I am trying to find the source code for this form.
Thanks, MP
...
written by Anil Passi , December 09, 2006
System Administrator Reponsibility -> Workflow>>Administrator Workflow >>Notifications form


The form function name is WF_ADMIN_NOTIFICATIONS

however, to know the MDS document, you can click on Personalize to get the path

Scope Page: /oracle/apps/fnd/wf/worklist/webui/AdminNotificationsPG
Document Name /oracle/apps/fnd/wf/worklist/webui/AdminNotificationsPG





vi $FND_TOP/mds/wf/worklist/webui/AdminNotificationsPG.xml

Here you will see that
^M

Now, you need to go to Java Top to find your classes & XML in below locations

Your Application Module is in
$JAVA_TOP/oracle/apps/fnd/wf/worklist/server/NotificationsAM.xml

Your controller class is
$JAVA_TOP/oracle/apps/fnd/wf/worklist/webui/NotificationsPageCO.class

You should extend and not customize your OA Framework.
You should be able to FTP all these OAF files to jDev and work directly from jDev


Thanks
Anil Passi
...
written by Anil Passi , December 09, 2006
System Administrator Reponsibility -> Workflow>>Administrator Workflow >>Notifications form


The form function name is WF_ADMIN_NOTIFICATIONS

however, to know the MDS document, you can click on Personalize to get the path

Scope Page: /oracle/apps/fnd/wf/worklist/webui/AdminNotificationsPG
Document Name /oracle/apps/fnd/wf/worklist/webui/AdminNotificationsPG





vi $FND_TOP/mds/wf/worklist/webui/AdminNotificationsPG.xml

Here you will see that
^M

Now, you need to go to Java Top to find your classes & XML in below locations

Your Application Module is in
$JAVA_TOP/oracle/apps/fnd/wf/worklist/server/NotificationsAM.xml

Your controller class is
$JAVA_TOP/oracle/apps/fnd/wf/worklist/webui/NotificationsPageCO.class

You should extend and not customize your OA Framework.
You should be able to FTP all these OAF files to jDev and work directly from jDev


Thanks
Anil Passi
...
written by Santosh , December 12, 2006
Hi Anil,

Keep the good work going.......

I am a Functional person, please give me some functional knowledge in GL & AP as i want master them.

Please provide me some related sites as well.

Thanks n Regards,
Santosh
...
written by Santosh , December 12, 2006
Hi Anil,

Keep the good work going.......

I am a Functional person, please give me some functional knowledge in GL & AP as i want master them.

Please provide me some related sites as well.

Thanks n Regards,
Santosh
...
written by Anil Passi , December 12, 2006
Hi Santosh,

Currently I am writing up things for Oracle HRMS and Payroll.

Please let me know the information you are after, I will try writing something up to that effect.

Thanks
Anil Passi
...
written by Santosh , December 12, 2006
Hi Anil,

Keep the good work going.......

I am a Functional person, please give me some functional knowledge in GL & AP as i want master them.

Please provide me some related sites as well.

Thanks n Regards,
Santosh
...
written by Santosh , December 12, 2006
Hi Anil,

Keep the good work going.......

I am a Functional person, please give me some functional knowledge in GL & AP as i want master them.

Please provide me some related sites as well.

Thanks n Regards,
Santosh
...
written by Anil Passi , December 12, 2006
Hi Santosh,

Currently I am writing up things for Oracle HRMS and Payroll.

Please let me know the information you are after, I will try writing something up to that effect.

Thanks
Anil Passi
...
written by reddy , December 13, 2006
hi anil

please can u write interview question for oracle hrms functional role .please here u have covered more techinical stuff.please i am waiting for urs reply.
thanks
bye
...
written by Anil Passi , December 13, 2006
Hi Reddy,

I am writing on functional topics these days.
Thus far 5 articles have been written, that can be acessed from link http://oracle.anilpassi.com/hr-suite/19.html

Thanks,
Anil passi
...
written by Anuj , December 13, 2006
hi ,looking at the steps for oracle workflow i want to learn that .
Please let me know from where can I download workflow builder. Is that the same which is avilable on oracle website (OTN)and named as oracle workflow client?
send me email for the details
thank you
Anuj
...
written by Anil Passi , December 13, 2006
Hi Anuj

Both the 9i Client and 10g Client contain the Workflow builder by default.

I think these can be downloaded from otn.

Good luck,
Anil Passi
...
written by reddy , December 13, 2006
hi anil

please can u write interview question for oracle hrms functional role .please here u have covered more techinical stuff.please i am waiting for urs reply.
thanks
bye
...
written by Anil Passi , December 13, 2006
Hi Reddy,

I am writing on functional topics these days.
Thus far 5 articles have been written, that can be acessed from link http://oracle.anilpassi.com/hr-suite/19.html

Thanks,
Anil passi
...
written by Anuj , December 13, 2006
hi ,looking at the steps for oracle workflow i want to learn that .
Please let me know from where can I download workflow builder. Is that the same which is avilable on oracle website (OTN)and named as oracle workflow client?
send me email for the details
thank you
Anuj
...
written by Anil Passi , December 13, 2006
Hi Anuj

Both the 9i Client and 10g Client contain the Workflow builder by default.

I think these can be downloaded from otn.

Good luck,
Anil Passi
...
written by Jay , December 16, 2006
Dear Anil,
You are doing a great job great !!!!!!!
I am now going to make my career in ORACLE HRMS & your blog is a great!!!!!!This is a excellent effort from you ANIL.
PLZ HELP ME ON THIS :
What steps involve in creating BG?
what is full life cycle implementation?
How can we define payroll?
...
written by Jay , December 16, 2006
Dear Anil,
You are doing a great job great !!!!!!!
I am now going to make my career in ORACLE HRMS & your blog is a great!!!!!!This is a excellent effort from you ANIL.
PLZ HELP ME ON THIS :
What steps involve in creating BG?
what is full life cycle implementation?
How can we define payroll?
...
written by Anil Passi , December 18, 2006
.


Hi Ram,

I am glad that this website helped you learn a few things.

With reference to Java Concurrent Program, please follow the article by clicking on this link http://oracle.anilpassi.com/ja...racle.html

Thanks
Anil Passi


.
...
written by Ram Murthy , December 18, 2006
Hi anil,
I never knew that Oracle Apps Concepts would be understandable by me in such a short span of time till i came through this site.
Can you please explain the procedure to run a Java Concurrent Program in Oracle Apps.I mean to say what type of file should be given whether it is .java or .class and location of the file and how the file should be and so on. I urgently require this procedure as i should runa delivery manager program to send the report output to a mail.
Thanks a lot
Ram Murthy
...
written by Anil Passi , December 18, 2006
.


Hi Ram,

I am glad that this website helped you learn a few things.

With reference to Java Concurrent Program, please follow the article by clicking on this link http://oracle.anilpassi.com/ja...racle.html

Thanks
Anil Passi


.
...
written by Ram Murthy , December 18, 2006
Hi anil,
I never knew that Oracle Apps Concepts would be understandable by me in such a short span of time till i came through this site.
Can you please explain the procedure to run a Java Concurrent Program in Oracle Apps.I mean to say what type of file should be given whether it is .java or .class and location of the file and how the file should be and so on. I urgently require this procedure as i should runa delivery manager program to send the report output to a mail.
Thanks a lot
Ram Murthy
...
written by Kumar , December 20, 2006
Hi Anil
ur blog is good very clear.

can u post an example of how to create a new LOV and put it in the iexpense ExpenseDetails page. I need the steps fot it.

it will be very helpful

Thanks
...
written by Kumar , December 20, 2006
Hi Anil
ur blog is good very clear.

can u post an example of how to create a new LOV and put it in the iexpense ExpenseDetails page. I need the steps fot it.

it will be very helpful

Thanks
...
written by busireddy , December 28, 2006
hiAnil,
I am glad that this website helped you learn a few things.

Plz provide some screen shots and explation in Po and INN in Functional side
...
written by busireddy , December 28, 2006
hiAnil,
I am glad that this website helped you learn a few things.

Plz provide some screen shots and explation in Po and INN in Functional side
...
written by Anil Passi , December 31, 2006
.
.
.
.

Hi Sri,

Indeed there is no Key Flex on po_headers.
There is no reason that I am aware of I am afraid.

I think this is legacy, during very earlier versions of Oracle Financials, they might have decided to allow KeyFlexfield, to capture Organization Name, PO Type etc as a part of PO-Number itself. Thereafter, Oracle created Composite Unique index on Segment1[po-number],org_id & type_lookup_code. Hence they decided to backtrack from a KFF on PO-Number....

Above is not a statement of facts, but merely my understanding.

THanks,
Anil Passi
.
.
.
.
...
written by Anil Passi , December 31, 2006
.
.
.
.

Hi Sri,

Indeed there is no Key Flex on po_headers.
There is no reason that I am aware of I am afraid.

I think this is legacy, during very earlier versions of Oracle Financials, they might have decided to allow KeyFlexfield, to capture Organization Name, PO Type etc as a part of PO-Number itself. Thereafter, Oracle created Composite Unique index on Segment1[po-number],org_id & type_lookup_code. Hence they decided to backtrack from a KFF on PO-Number....

Above is not a statement of facts, but merely my understanding.

THanks,
Anil Passi
.
.
.
.
...
written by Anil Passi , January 02, 2007
.
.
.
.
Hi Santhos

Indeed you can, but not all reports will work out of the box when switched to XML Publisher.
I think format triggers do not get executed when concurrent manager runs a rdf file for XML output. Understandably oracle expects you to define your formatting inside XML Publisher itself.
.
.
.
Thanks,
Anil Passi
...
written by santhosh , January 02, 2007
Hi Anil,
Your blog is very informative. Thanks for all the useful articles.I am going to ask you a very basic question about XML Publisher.Is that possible to convert/change the existing reports to XML as it can provide multiple outputs?

Regards
Santhosh.
...
written by santhosh , January 02, 2007
Hi Anil,
Your blog is very informative. Thanks for all the useful articles.I am going to ask you a very basic question about XML Publisher.Is that possible to convert/change the existing reports to XML as it can provide multiple outputs?

Regards
Santhosh.
...
written by santhosh , January 02, 2007
Thanks Anil.

Regards
Santhosh
...
written by Anil Passi , January 02, 2007
.
.
.
.
Hi Santhos

Indeed you can, but not all reports will work out of the box when switched to XML Publisher.
I think format triggers do not get executed when concurrent manager runs a rdf file for XML output. Understandably oracle expects you to define your formatting inside XML Publisher itself.
.
.
.
Thanks,
Anil Passi
...
written by santhosh , January 02, 2007
Hi Anil,
Your blog is very informative. Thanks for all the useful articles.I am going to ask you a very basic question about XML Publisher.Is that possible to convert/change the existing reports to XML as it can provide multiple outputs?

Regards
Santhosh.
...
written by santhosh , January 02, 2007
Hi Anil,
Your blog is very informative. Thanks for all the useful articles.I am going to ask you a very basic question about XML Publisher.Is that possible to convert/change the existing reports to XML as it can provide multiple outputs?

Regards
Santhosh.
...
written by santhosh , January 02, 2007
Thanks Anil.

Regards
Santhosh
...
written by Anil Passi , January 04, 2007
Hi Santosh,
This is listed in interview questions.
Thanks
Anil Passi
...
written by Anil Passi , January 04, 2007
Hi Santosh,
This is listed in interview questions.
Thanks
Anil Passi
...
written by Santhosh , January 08, 2007
Hi Anil,

I have a doubt in Oracle Reports?
I am using Reports 6i.
I am working on Invoice Report. My requirment is if the output is within a page then there is no need to print the page number or else need to print it. How can we achieve this?

I tried using the Total Physical pages, but i could not refer in conditional format trigger. Could you please help me in achieving this?

Regards
Santhosh.
...
written by Santhosh , January 08, 2007
Hi Anil,

I have a doubt in Oracle Reports?
I am using Reports 6i.
I am working on Invoice Report. My requirment is if the output is within a page then there is no need to print the page number or else need to print it. How can we achieve this?

I tried using the Total Physical pages, but i could not refer in conditional format trigger. Could you please help me in achieving this?

Regards
Santhosh.
...
written by Anil Passi , January 09, 2007
.
.
.
Hi Santosh,

I vaguely remember that you will need to create a summary column for page number, reset at appropriate level, and then use format trigger to hid/display.

Its been six year since I did any professional work on developing reports. Hence my statement may not be accurate.

THanks
Anil Passi
...
written by Anil Passi , January 09, 2007
.
.
.
Hi Santosh,

I vaguely remember that you will need to create a summary column for page number, reset at appropriate level, and then use format trigger to hid/display.

Its been six year since I did any professional work on developing reports. Hence my statement may not be accurate.

THanks
Anil Passi
...
written by premkumar , January 10, 2007
HI Anil ,
I am working in Oracle HRMS , i am not clear with organization classifications and Key Concepts for Representing Enterprises , could you please help me out in this.
...
written by premkumar , January 10, 2007
HI Anil ,
I am working in Oracle HRMS , i am not clear with organization classifications and Key Concepts for Representing Enterprises , could you please help me out in this.
...
written by Deblina , January 11, 2007
Hi,

Is it possible to pass the bad file name and the discard file name to the SQL Loader type concurrent program in apps ? I am passing the data file name(and path) and bad file name (and path) as parameters ,but it is using its own bad file name and path.
...
written by Deblina , January 11, 2007
Hi,

Is it possible to pass the bad file name and the discard file name to the SQL Loader type concurrent program in apps ? I am passing the data file name(and path) and bad file name (and path) as parameters ,but it is using its own bad file name and path.
...
written by Sanjai , January 12, 2007
Anil,

Great work. Do you have a set of interview questions for oracle crm.

Thanks.
...
written by Sanjai , January 12, 2007
Anil,

Great work. Do you have a set of interview questions for oracle crm.

Thanks.
...
written by User , January 18, 2007
Hi Anil,

If possible, can you plese explain the basic fundamentals about apps tables and busines. For example, consider from customer placing an order, and finally ending with collecting the payements, receipts,invoice etc.,...Also, what kind of information is stored in what tables and what columns. What are the mostl frequently used tables and columns that are being used. If you can explain with a real time scenario, that would be very useful.

Thank You!
...
written by User , January 18, 2007
Hi Anil,

If possible, can you plese explain the basic fundamentals about apps tables and busines. For example, consider from customer placing an order, and finally ending with collecting the payements, receipts,invoice etc.,...Also, what kind of information is stored in what tables and what columns. What are the mostl frequently used tables and columns that are being used. If you can explain with a real time scenario, that would be very useful.

Thank You!
...
written by sajeed , January 19, 2007
Great blog...keep it up !

Was wondering if all the above information is on some PDF or word file?

sajeedmujawar@gmail.com

Regards, Sajeed
...
written by sajeed , January 19, 2007
Great blog...keep it up !

Was wondering if all the above information is on some PDF or word file?

sajeedmujawar@gmail.com

Regards, Sajeed
...
written by YJ , January 23, 2007
Anil,
I am an techie,and more inclined towards HR functional track.can you please let me know your opinion.I mean about the scope for HR functional consultant.

Thanks,
YJ
...
written by YJ , January 23, 2007
Anil,
I am an techie,and more inclined towards HR functional track.can you please let me know your opinion.I mean about the scope for HR functional consultant.

Thanks,
YJ
...
written by kartikey , January 25, 2007
Hi Anil,
I want to make a request that plz make a set of some real time question about pl sql(trigger,cursor,package,procedure),report 6i,and oracle apps tech which journelly a fresher dont know and which atleast give some positive impact in interview.
so this ismy humble request plz make a set of such questions plzzz
thanks
...
written by shell , January 26, 2007
Anil,
I really appreciate your efforts ,i am a beginner and your site is very useful for me ,i have a ques to you i am working with oracle xmlpublisher got first job in there ,i did my OCA but still scared with programming sql,pl/sql can u help me or give me right path how to do all that.becoz for coding wise here is no work..and want to more understand oracle apps and all pls help me to give your guidence.
Thanks for your help
Shell
...
written by Anil Passi , January 27, 2007
.
.
.
Hi Shell,

You need to become a good Oracle Apps consultant, regardless of TEchnical or Functional Consultant.

I suggest, you pick up a module of your choice, and try to run end to end process. For example from Payables invoice, to invoice payment batches, Accounting, transfer to GL, posting to GL, and seeing those entries in GL balances.

This is just an example. Next you can expand the scope of your steps, and start from purchasing requisition, to approval, to Purchase Order to its receipt and then transferring all to GL. Next you can create an invoice and match the same to Purchasing.

I am trying to say, first step, UNDERSTAND HOW THE ORACLE APPS SYSTEM WORKS.

Once you have done so, then you can take the next step by setting up a new GL Set of Book, new Multi Org Organizations, new responsibility, new setup for that Org and GL SOB. And then setup module specific entities. Once you have done your own setup, try running end to end process again on your config data.

All this is hard work, but so goes life.

Thanks,
Anil Passi
...
written by Anil Passi , January 27, 2007
.
.
.
Hi Shell,

You need to become a good Oracle Apps consultant, regardless of TEchnical or Functional Consultant.

I suggest, you pick up a module of your choice, and try to run end to end process. For example from Payables invoice, to invoice payment batches, Accounting, transfer to GL, posting to GL, and seeing those entries in GL balances.

This is just an example. Next you can expand the scope of your steps, and start from purchasing requisition, to approval, to Purchase Order to its receipt and then transferring all to GL. Next you can create an invoice and match the same to Purchasing.

I am trying to say, first step, UNDERSTAND HOW THE ORACLE APPS SYSTEM WORKS.

Once you have done so, then you can take the next step by setting up a new GL Set of Book, new Multi Org Organizations, new responsibility, new setup for that Org and GL SOB. And then setup module specific entities. Once you have done your own setup, try running end to end process again on your config data.

All this is hard work, but so goes life.

Thanks,
Anil Passi
...
written by Dwaipayan , January 28, 2007
Hi Anil,

First of all...Many Many thanks for sharing knowledge through this blog..Its really a wonderful one. Hope that we all utilize this and clarify all our doubts and queries from here.

Best Regards,
Dwai
...
written by shell , January 30, 2007
Anil,
Thanks a lot for ur reply.i will work hard as per your guidance and keep questioning you.
thanks
again
Shell
...
written by Al Dhalla , February 04, 2007
Hi Anil;
I was wondering if you can help me out with our Logon Securities predicament: We have set up some generic apps ids that are only known to a handful of users. Regular but unauthorized users are trying to sign-on using these generic ids by guessing the password and end up locking them when they exceed sign-on attempts. Is it possible to trace these unauthorized users? (via ip address or terminal id?) (We are on 11.5.smilies/cool.gif

Thanks, Al
...
written by madhu sudhan , February 06, 2007
Hi Anil,
I have read the article on org_id.It is good.
I would like you to explain some more on this
from the view of Business unit, Legal entity, operating unit,Business Group.That would help me a lot...

Thanks in advance,
Madhu
...
written by Anil Passi , February 06, 2007
.
.
Hi Madhu

Have a look at the comment section of link http://getappstraining.blogspo...-apps.html

The answer to your question has been discussed there.

Thanks,
Anil Passi
...
written by Anil Passi , February 14, 2007
Murugiah,

I am afraid I do not have QandA for SCM.

User,
Are you changing the value of any database field in Post-Query? If so, you need to use set the record back to Status_query [immediately after assigning values in post-query]. Use set_record_property for this purpose, and use :system.trigger_record for the current record being referenced in post-query

thanks
anil
Thanks
...
written by Murugiah , February 14, 2007
Great work Anil with your amazing experience and skill. I planned to take ocp-ebs - SCM track. Can I have some sample questions.
...
written by Akash , February 22, 2007
Hi Anil,
Like many others I am an Oracle developer trying to get in to apps, for that your site is great help. I am sort of trying to get back door entry into apps, as there is not really need for another apps developer in our team. So I am writing Business Objects reports against OLM.
So now question I have is - on a self service screen how to find what table is getting used. E.g. under learning administrator (OLM) if I am creating a new category how can I find out in which table data is going? Is there any thing similar to forms based screen like Record History for Self service page?

Regards,
Akash
...
written by murthy , February 23, 2007
hi anil,
your blog is really very helpful for people you need help for oracle applications.
with regards
murthy
...
written by Anil Passi , February 24, 2007
Thanks Murthy


Akash,
In answer to your question, you should set the Diagnostics profile to Yes, following which you will find a link named About This Page. When you click on this link, you will see the view object name on which the screen is based. Open the VO file either in jDev or in $JAVA_TOP xml to see the SQL Query used. Please note the VO where clause might be modified with additional conditions in the processRequest of the controller.


Thanks
Anil Passi
...
written by Anil Passi , February 24, 2007
Hi Venkat,

I am yet to experiment with Mobile apps.
Is there nothing on Metalink ?

Cheers
Anil Passi
...
written by venkat , February 24, 2007
Hi Anil,
I need a tutorial on how to use Jdeveloper.
Actually I am working on MWA customizations. I do not know how to consolidate the java files available on server as a project.

I need to develop MWA pages. Please suggest any documentation and means by which development can be done.

regards
Venkat
...
written by bobby , February 26, 2007
hi anil,
i need an advice regarding apps. I am new to apps
and u r site is ver helpful to me.i want to know which module will be fetching for me for getting job as my btech is on nonit.is it necessary to learn java too.please help me regarding this.i already completed my training in apps 11i.
...
written by Narasimharao , February 28, 2007
Hi Anil,

This is narasimha rao, iam new to this Apps technical, i want to know complete information about conversions and can you please tell me where can i get sample conversion scripts so that i can practise.
Hope to hear from you soon.

thank you.
...
written by Anil Passi , February 28, 2007
Hi AY

The best way to approach the market is to be prepared for most possible skillsets, that which are commonly used in most projects.

Examples are:-
1. Interfaces using API and interface tables
2. Concurrent programs of type pl/sql to create processes
3. Workflow modifications and creating Workflows from scratch
4. CUSTOM.pll
5. Forms Personalizations
6. Self Service personalizations and framework concepts
7. some data migration examples
8. workflow business events

If you can try couple of in each of the categories, then I can say you are prepared for it. It might take you long time to get the job, but then it also means you get long time to learn and experiment these things.

also, look at forums.oracle.com and see the kind of questions people are raising there, its a nice place to learn about practical problems that people face and also their resolution. so do as much reading as possible on the forum

good luck
anil
...
written by AY , February 28, 2007
Anil,

Well done for the excellent job you are doing on you site. Its been very useful. I am Oracle developer and I have just completed my Apps training. Can you give some insight into how best to approach the market. Obviously I have got no Apps experience and all prospective employers are looking for some apps experience

Many thanks
AY
...
written by Braja Bandhu Behera , March 01, 2007
in concurrent programe if the executable is PL/SQL
in that case when i pass a parameter that is attache with a value set in that case what shoub be the value set because I wrtie the proceduer and table and register all in my application table which value I have to pass.
...
written by Anil Passi , March 01, 2007
Hi Braja

The valueset name used will depend upon how you wish to validate the parameter selection values.

In case, you want to restrict your user to enter either Yes[Y] or No[N] into a parameter, then the value set attached will be FND_YES_NO

Thanks,
Anil Passi
...
written by Jitu , March 02, 2007
Hi Anil, You have done an excellent work in most of the area. I would request you to put in a basic setup steps for Oracle Advance Pricing along with modifiers and qualifiers and formulae as it is 1 module which generally no one gets into the details. Thanks in advance
...
written by mahes , March 22, 2007
dear anil

what is open purchase order?
...
written by Nemai , March 23, 2007
Hi Anil,
I have a requirement described below. Could you please give me any suggestion regarding this.

I need to create a discoverer report, which will display all the details of the user, who is currently executing this discoverer report.
The details should include:
1) Apps user id, through which he loggeged in the discoverer desktop edition.
2) Any other details attached to the user id, such as Employee ID, Name etc etc..

Looking for your quick reply.

Thanks,
Nemai
...
written by Anil Passi , March 24, 2007
mahes [3questions above], open PO is a Purchase Order that has not closed. A po can be closed, for example, after its goods have been received.

thanks
anil
...
written by Anil Passi , March 24, 2007
Hi Nemai

If APPS login option is being used, then fnd_global package has the functions that you need

thanks
anil
...
written by Anil Passi , March 31, 2007
Hi Manish

please visit http://www.oracle.com/global/u...urses.html

thanks,
anil
...
written by Anil Passi , March 31, 2007
Hi Manish

See if think link gives you required info
http://www.oracle.com/global/us/education/certification/ebus11i_appteccourses.html

Thanks,
Anil
...
written by Partha , April 02, 2007
Can u please send me interview questions on INV, OM & PO
...
written by RK , April 06, 2007
Anil,
SQL n PLSQL can be practiced using database. What about D2K, is it JDeveloper?
...
written by Keyur Joshi , April 12, 2007
Hi,
I am a functional person. Just changed my field and into Oracle Apps, after 10 years of hardcore process manufacturing experience. I have started with learning basic modules, Purchasing, GL,AP,INV. My focus is to master the process manufacturing module. Can u pl. tell me what is the first step in learning oracle. There are so many things out there that i got confused, PL. HELP.
...
written by Keyur Joshi , April 12, 2007
Hi,
I am a functional person. Just changed my field and into Oracle Apps, after 10 years of hardcore process manufacturing experience. I have started with learning basic modules, Purchasing, GL,AP,INV. My focus is to master the process manufacturing module. Can u pl. tell me what is the first step in learning oracle. There are so many things out there that i got confused, PL. HELP.
...
written by Keyur Joshi , April 12, 2007
Could you pl. try to explain considering an end to end implementation scenario, What are the few basic steps involved to start setups. say for a process manufacturing industry manufacturing polymers
...
written by Anil Passi , April 14, 2007
Hi Keyur

Before you learn Oracle Financials, try to navigate through the various screens/business processes to get familiar with the Architecture.

Make a start with GL module, and then Payables integrating to GL.

Solution Beacon website has hosted R12 instance, on which you can play around.

Thanks
Anil
...
written by mayur , April 16, 2007
Hi Anil,
I am encountering following problem.

When I am trying to run Helloword Page from JDEveloper I am getting the page along with following Error.

You are to Access a Page that is no longer Active
-The referring page may ahve come from a previous session.Please select Home to proceed


Can you help me?
...
written by srinivas , April 16, 2007
hi,
please explain interfaces, gl, ap,ar in detail. thanks this site is really helpful.
...
written by sheeba , April 19, 2007
hi Anil,
Your websitte is a good resource for apps enthusiast.
can you give more articles with some examples on workflow.Im a fresher in Apps.
...
written by Anil Passi , April 20, 2007
Hi Sheeba

Please let me know which area of workflow are you interested in?

THanks
Anil
...
written by Keyur Joshi , April 21, 2007
Hi Anil,
Thnks a lot for the tips. I am a bit comfortable now in screens, navigations, . Have almost tested all the cases in Vision instance 11i of P2P cycle. My question now is that does Oraccle Apps have any Entity Relationship diagram sort of a thing which can be understood by a layman like me. Or is there any other way of finding relationships between the objects, or each module has a different set of objects. Kindly xplain?
...
written by Anil Passi , April 22, 2007
Hi keyur

You can download the diagrams from http://etrm.oracle.com

Thanks,
Anil Passi
...
written by User , April 27, 2007
Hi, I have something to clarify. Could you please provide your valuable suggestions? Right now,Iam 2 years experienced in the field of Oracle Applications(OM,AR)( I joined as a fresher). Worked on Few outbound interfaces(utl packages) and some customized packages, simple forms and reports. Now, I have been given an option to work on Oracle Discoverer(with training provided from Oracle University). Can you suggest whether to proceed with that? Will that come under Oracle applications(ERP)..How is the Market(Future market as well) for that? Is that a kind of stepping down compared to the kind of work that I do? Please clarify. Thanks.
...
written by Keyur Joshi , April 27, 2007
Hello Anil,
I have just started Inventory module. Which i am going to learn in detail, because this the base for any manufacturing application. I am trying to understand the hierarchy and relationships of Items templates,Item categories, categorysets. Could you please throw some light on these topic. Shall be better if any short article which can help. Can I use different category KFF for different items, in the same Organization?
...
written by dilip , May 02, 2007
Hi Anil,
I was as tech.consultant and i am asked to move to Functional suddenly.

I want some sample documents of BR 100.
To list the setup information of older existing application

Thanks in advance!

Dilip
...
written by User , May 03, 2007
Thanks Anil
...
written by Kamal , May 08, 2007
Hi ,

How to make a standalone form in D2K which can run as an independent form without using D2K like we do in VB.
...
written by Shiva , May 09, 2007
Hi Anil,

I am a Oracle & D2K developer.I want to move on to Oracle Apps Technical and I prefer financials.Can u pls suggest the topics that I need to learn from a technical point of view.

Kind Regards
Shiva
...
written by Mayank , May 10, 2007
Hi Anil

It would be really great and helpful if you could provide something on self-service personalization with examples.

THanks!
Mayank
...
written by suresh , May 11, 2007
hi ani
what are the basetables,interface tables,standard conc prog for approved supplter list conversion.
...
written by Keyur Joshi , May 12, 2007
Hello Anil,
I want to restrict the multiple parellel logins from a single username. Can I do this with profile options? Is there any profile options for this? How this can be done? Please HELP.

Regards,

Keyur
...
written by Saroj Kumar Nayak , May 14, 2007
Hi Anil,
I am here once again with a question whose answer I have not got till now .
Can you help me with a site where I can get implementation knowledge of oracle application modules(manufacturing and Finance) . Also I am desperately looking for FAQs from functional point of view .
Can you help me out . I accept that it is very hard to post such a doc that can give what I require in a nutshell . Still is there any approx solution to what I am looking for ?

Thanks & Regards

Saroj
...
written by Kashyap , May 20, 2007
Hi Anil.
This is Kashyap.Could you please send/give some notes/documents related to Process & Discrete Mfg.
Thanks and regards
Kashyap.
...
written by Apps Developer , May 22, 2007
Hi,

Can you please let me know where i can information about Item Master. Also please let me know, if I need to know any prerequesites to know item master.

Thanks!
...
written by Rinks , May 25, 2007
Hi Anil,

Is it possible to see output of request run by other user from my log in? As through system administrator i can see all requests and their logs but not output.I heard like there is a profile option to do this.is it so?

Please tell me is there any way to see that.This will help me in debugging me issues.


Thanks,
rinks
...
written by CH , May 30, 2007
hi Anil,

I am into oracle Apps for 3 yrs and wants to pursue the functional stream.My interest is towards HR and CRM.Can you please give me a rough scope about these two.which would has the more viable scope.
...
written by Anil Passi , June 04, 2007
Hi Lucky

To get started, I suggest you take a course on Fundamentals of Oracle Applications.

Just the fundamentals, on architecture.
Oracle Applications is more about the methodology, than about technology. You can learn technology from otn and books and self-practice, but you will require some guidance to understand the basic concepts of Oracle Applications

Thanks,
Anil Passi
...
written by Rajeev , June 14, 2007
Hi Anil,

How to view EXCEL output of a concurrent program using XML Publisher.

I tried but it is giving error it is showing the output as html.
...
written by Anil Passi , June 15, 2007
Hi Rajeev
I have covered this in below link, simply search on excel [although not in context of XMLP]
http://oracle.anilpassi.com/technical-interview-questions-oracle-apps.html

Thanks,
Anil
...
written by mohan , June 21, 2007
hi
Anil
Can u provide India Localization related stuff
Regards
Mohan.Katepalli
...
written by Anil Passi , June 21, 2007
Hi Mohan,

I am yet to work on Indian Localizations myself.

Thanks,
Anil Passi
...
written by Ashok , June 21, 2007
Would like to put job opportunity for Oracle Apps functional on this site, will it be possible?

May update the process and detail?

Do I have to pay for that?

Regards,
Ashok
...
written by User , June 21, 2007
Hi Anil,

Iam intersted to know about Install Base,technically. What kind of information is stored in which tables in order to cash life cycle.
What are the most frequently used tables/columns.
...
written by Anil Passi , June 22, 2007
No problems Ashok.

And, you do not have to pay for that either.
...
written by satya , June 26, 2007
hi anil,
This is Satya,and I want to know about XDO Reports.Could u please help me.
Regards,
Satya
...
written by Anil Passi , June 27, 2007
Hi Bhaskar

All you need to do is to create a hyperlink to AppsLocalLogin.jsp
If you are currently in oa_html/bbrr/xx.jsp
Then your URL will be ../AppsLocalLogin.jsp

Thanks
Anil
...
written by Anil Passi , July 03, 2007
Hi Nimish,

Please can you elaborate your question smilies/angry.gif

Thanks,
Anil Passi
...
written by Nimish , July 04, 2007

Sorry Anil for being so vague, I have seen word “USAGES” used on the data entry screen and in some of the Table/ view names (e.g. PER_PERSON_TYPE_USAGES_F). So is there any significance of word Usage?

Hope this time I am bit more clear in my question.

Thanks!
...
written by Ajay Singh , July 04, 2007
hai
anil i m ajay singh from mumbai . i have 3 years in oracle . im learning oracle apps for last six month . i have basic knowledge of oracle apps and all i got from your great blog . i thanks ful to you . now trying for real time exp .
rest is fine .
Ajay Singh
...
written by Anil Passi , July 05, 2007
Hey Ajay

Good luck with your job.

Thanks,
Anil Passi
...
written by Mandev , July 07, 2007
Hi Anil,
I am using your blog since quite a long time for my knowledge upgradation.
I am working in oracle apps since then 3 years,

Though most of the people i know work in different implementation projects but i have doubt that how a new company which is planning to implement ERP will freeze a particular ERP package i.e whether company should go for oracle apps or SAP, I have never worked in SAP but I suppose that 80-90 % processes of any discreet manufacturing industry can be mapped in either SAP or Oracle apps therefore only thing of prime importance left is money.
How is the cost comparison done of different ERP packages, The cost of implementing any ERP package includes One time & repetitive cost, One time cost is the initial cost incurred in implementation, training etc. Repetitive cost is the license fees, fee for future customizations etc.

Can u suggest me any resource where i can get a detailed idea for parameters of cost comparison for different ERP's.
...
written by Anil Passi , July 08, 2007
Hi Mandev

Costs depends on your implementation strategy.
Costs can be kept down by involving as much of your permanent staff as possible in the Business Analysis roles. In your location, you should compare the hourly wage for SAP and Oracle consultants. That will give you a fair idea of which ERP implementation will be cheaper.

Keeping money aside, Oracle is pushing for open standards. Oracle's BPEL is much more powerful that SAP's netweaver.

FMW[FUsion middleware] will provide your organization scalability both within and outwards[integration with trading partners], as the company grows.

Having open standard technologies will keep the technical costs lowers in the longer run.
Hence Oracle is my choice

Thanks,
Anil

...
written by Tony , July 09, 2007
Hi Anil,

I have a small doubt
1. Why most of the Apps Tables don't have Primary key's and only Indexes
what is the reason

Thanks
Tony
...
written by Anil Passi , July 09, 2007
Hi Tony

For performance reasons Oracle does not use Foreign Keys in EBS.
Hence there isn't a need for primary keys either.

The net effect of Unique Key and Primary Key is the same.

Thanks,
Anil


...
written by swapna , August 04, 2007
hai
i completed mca in 2006. Now i wnat to do oracle apps pls provide some information about orcle apps
...
written by Vishnu , August 07, 2007
hi
can u tell me how can i add multiple assignments by using fa_mass_additions
...
written by subbareddy r , August 07, 2007
hi anil,
U r explaining each and every point amazing.keep it up.
Could u explain how to debugging a report ?
Is there any diff b/n debugging a report in D2K AND apps?
...
written by Anil Passi , August 07, 2007
Hi Subb,

There are two ways by which you can debug a report in APPS[assuming its deployed on server].
1. run trace. you can turn the tracing on in concurrent program definition.
after the tracing has been turned on, you can simply check the trace file to see the sql
2. pur srw2.message, these will be visible in the log file of the report

In order to debug report on PC, using D2k, simply use the D2k debugger.

Thanks
Anil
...
written by Kapil Kaushik , August 08, 2007
Hi Anil.

i have recently joined an ERP team in an MNC. Can you (or anybody else withing this group) please help me out and learn Oracle Apps. need to know how to start with it. i am pretty much comfortable with SQL,PL/SQL,forms 6i,forms 9i and reports i and reports 9i and some exposure on 10g too.
Thanks a lot in advance..
...
written by User , August 08, 2007
Hi,
I would be pleased to know if there is any place to know Order Management. Not the pdfs that are provided by oracle, expecting something in anil passi style. Would be glad, if someone helps in this regard.

Thanks!
...
written by User , August 09, 2007
Hi,
I would be pleased to know if there is any place to know Order Management. Not the pdfs that
are provided by oracle, expecting something in anil passi style. Would be glad, if someone helps in this regard.

Thanks!
...
written by Shweta Naugaiya , August 13, 2007
Hi Anil
I have some issues while adding code in CUSTOM.pll
Please refer to the explanation below:
Subsmilies/cheesy.gifeselecting a line on Autocreate Form through CUSTOM.pll

I have written code to customize the Autocreate form. In this form only the valid lines (validity is checked based on certain conditions) should get selected when I check the checkbox corresponding the requisition line.

For deselecting the line I have written the code:

if (invalidity_condition is TRUE for a line) then
copy('N', 'REQ_LINES.SELECT_LINE');
end if;

But through this code only the checkbox is deselected and not the lines.
The lines remains selected because it remains highlighted in yellow color. Also when I press Autocreate button these lines appear on Purchase Order form.

Please guide me how to do this ..as I am a fresher in Oracle Apps/CUSTOM.pll
Please reply to this asap..

Regards
Shweta


...
written by vivek khosla , August 16, 2007
Hi Anil ,

I am 2006 passout (Btech- Electronics and Communication - 79.5%) and Just joined an organization as a fresher and I am told to work as a functional consultant .Since I have read ur comments that tech. persons should go for Tech. Consultant but As a fresher I did not get the choice ..I have to work on "Payroll" module as functional consultant. Please guide me is it ok to be a functional consultant and the role can be changed after some time.....and if u can provede me some material on "Payroll" as what I have to go through in Payroll . please reply me to my mail id -> vivek_khosla@rediffmail.com

thanks
Vivek
...
written by Anil Passi , August 19, 2007
Hi Vivek

I am sorry if I have ever unknowingly advised against taking up functional role.

In fact one of my friends from Tech background[from REC] is one of the highest paid Functional consultants in Europe.

Payroll functional role will also involve some mathematics, when you design your Fast Formulaes.

It is a good opportunity, I would have taken this role if I were to be in your position.

Thanks,
Anil Passi
...
written by Shailesh , August 20, 2007
Dear Anil,

First of all I have to thank you for doing such a wonderful job on taking out the time and starting this initiative.

I have been struggling to get information on the Oracle financials (functional) and how to go about it. Infact I have too much information in the way of manuals and presentations. There is lot available on the technical front and there is not always a good demarkation to add to the confusion.
I would like to know if you have any particular blog or are you planning to put together something specifically for Oracle Financials (functional) students.

Once again, good job!

Shailesh

...
written by JayaKrishna , August 23, 2007
Hi Anil,

I am new to Oracle Apps and would like to know about Oracle Process Manufacturing

I have an interview on OPM

PLease let me know if you have any notes on OPM

thanks

JayaKrishna.
...
written by Manojkumar , August 24, 2007
Hi Anil,
Could you please send me the P2P document as an attachment in my id mkumar1975@hotmail.com.

Thanks
Manoj
...
written by lakshminarasareddy , August 24, 2007
Hi Anil,

I am tryng to compile a Form in R12,
But it is showing below error


[applmgr@apps US]$ frmcmp_batch.sh module=XXDARXTWMAI.fmb userid=apps/apps@VIS Module_Type=FORM
Forms 10.1 (Form Compiler) Version 10.1.2.0.2 (Production)

Forms 10.1 (Form Compiler): Release - Production

Copyright (c) 1982, 2005, Oracle. All rights reserved.

PL/SQL Version 10.1.0.5.0 (Production)
Oracle Procedure Builder V10.1.2.0.2 - Production
Oracle Virtual Graphics System Version 10.1.2.0.0 (Production)
Oracle Multimedia Version 10.1.2.0.2 (Production)
Oracle Tools Integration Version 10.1.2.0.2 (Production)
Oracle Tools Common Area Version 10.1.2.0.2
Oracle CORE 10.1.0.5.0 Production
ORA-12154: TNS:could not resolve the connect identifier specified

Form not created


can u please suggest any thing on this one.

Thanx

Lakshmi Narasaiah
...
written by vasu , August 30, 2007
Hi Anil,

I would like to hide "Save Search" and "Views" button on "vacancies" page of Oracle irecruitment. Please let me know if any profile setup is available to do this or I need to customize the SSWA page.

Thanks & Regards,
Sreenivasa
...
written by Padmaja , August 30, 2007
Dear Mr. Anil

I hav some working knowledge in Oracle Applications 11 i. hence i wish to explore more about Oracle Apps (Starting from the basics).Can u plz suggest me some useful documentations/steps that helps me

Thanks & regards
padmaja
...
written by Aniket Mahajan , August 31, 2007
Hi Anil,

Could you please elaborate on the order import cycle in Order management. Like once I was asked in the interview. How does the order import work. Also as per my knowledge we can use API. But I don't know how to use it, invoke it from where??. Got a lot of confusion regarding API's.

Thanks
Aniket
...
written by Jaspal , September 08, 2007
Dear Anil, What is the exact difference between following profile options:
1) HR: Security Profile
2) HR: Business Group

If we attach the HR:security profile option to responsibilities then It is automaticallt attached to HR:Business Group but what exactly is the need of having two different profile options, can't we manage with a single profile option
Regards,
Jaspal

...
written by amarnath , September 13, 2007
Hi Anil,
U r doing marvelous job,
i have one question in oracle.
how i can convert the numbers in to characters
when i am getting the numbers dynamically.
if i get 4578..i heve to print 'four thousand five hundred seventy eight'
or 'four five seven eight'.

i hope i will reply to my question soon.
thank u .
...
written by Anil Passi , September 13, 2007
Hi Amarnath,

Thanks for your kind words.

Please use the SQL below

SELECT initcap((to_char(to_date(&enter_your_amount, 'j'), 'jsp')))
FROM dual
/

Thanks,
Anil Passi

...
written by Hanu , September 21, 2007
HI,

I would like to have Application setup document for the Advance Product Cataloug.If any of you guys have worked on tie pleas ele tme know. Send it to my mail id mai2hanu at the rate of gmail dot com. I appreciate if any of you guys forward me the same.

Thanks
Hanu
...
written by Meera , September 25, 2007
Amazing Blog !!!

Really Useful.....

Thanks,
Meera
...
written by kalyan , September 26, 2007
Hi Anil,
This is the first time iam implementing DBI on Finance,HRMS and Projects.Please can i get guidence from you in understanding the concepts and setups.
...
written by P Ahuja , September 26, 2007
Dear Anil,
Could u please guide the steps on How to make Attachments as mandatory in Oracle Purchase Requisition Form Header section.
Thanks & regards
P Ahuja
...
written by Pallavi , September 29, 2007
Hi Anil,

I would be very thankful to you if you give a brief on multi-org.

thanx & regards,
Pallavi.
RICE Components
written by Nidhi Gupta , October 05, 2007
Hi

Do you have anything on RICE components??

Regards,
Nidhi
...
written by Mavis , October 09, 2007
Hi,

I would like to know more about the Link between Applications Modules and the Tables.

Thanks,

Mavis smilies/kiss.gif
urgent requirement: Oracle Technofunctional candidate needed for our very big project.
written by P. Pradeep , October 09, 2007
Job title : Oracle Techno functional.
Location : Coimbatore, India
Duration : Very Long term
Salary : Negotiable

Job description : Candidate should have solid experience with Oracle Financials preferably in AP and AR.
Should have realtime experience with Oracle 10.0 and 11.03 (Mandatory)

Please call me at 0422-3294524 or email me at pradeep.prabhakar@alliedgroups.com

Best regards,

Pradeep Prabhakaran
Resource Analyst
Allied Solutions Group inc.
440-397-0550 x 111
offshore : 0422-3294524
www.alliedgroups.com
...
written by Sandy-kashyap , October 10, 2007
Hi Anil,
Please read the following scenario and advise accordingly:

While implementing the HRMS in Oracle 11i, for the Company X that contains two offices: Office Y and Office Z, both are based in the same country then both are controlled by the same legislation code, furthermore they have the same structure.

How would they be classified, in order to secure data of each one and make them partitioned. Is this done by classifying them as two legal entities? Or two business groups?
...
written by Sandy-kashyap , October 10, 2007
Hi Anil,
Please read the following scenario and advise accordingly:

While implementing the HRMS in Oracle 11i, for the Company X that contains two offices: Office Y and Office Z, both are based in the the same set of countries and they have the same structure.

How would they be classified, in order to secure data of each one and make them partitioned. Is this done by classifying them as two legal entities? Or two business groups?
...
written by Anil Passi , October 10, 2007
Hi Sandy

If the sole purpose if to separate the Employee Data, then simply create these two as HRMS Organizations. No need to make them Legal Entity, as these both fall under same tax legislation and also share the same Flex. All you want is different cost centre for each of them, that can be achieved by creating two different organizations.

Usually, HRMS Organizations are mapped to Cost Centres.

Having created the two organizations, you can create two different Security profiles, and attach these Org's to respective security Profiles.

A user's access will be associated to a HRMS Security Profile, for HRMS Responsibilities. Hence the data security/visiblility will be controlled.

Thanks,
Anil Passi
OCP
written by john , October 14, 2007
Hi,

Are the OCP developer exams worth gaining?

thanks
Questions on some terminology
written by KReddy , October 15, 2007
Hi Anil,

Can you add some information on this site on terminology related to Implementation such as --
Solutions Design
Unit & System Testing
User Acceptance Test (UAT)
Conference room pilot
Configuration
Customization
Extensions

As always you do, I would love to see explanation with live examples.

Thanks
...
written by Anil Passi , October 25, 2007
Hi John

I haven't got any certifications within any of the streams with Oracle.
Hope that answers your question.

Thanks,
Anil Passi
Plz Let me where can i get the buyer setup document
written by Amir , October 29, 2007
Could you please Let me where can i get the buyer setup document.

Thanks
Amir
...
written by Jana , October 30, 2007
Hi Anil,
how to find the form names, for the jsp pages as we find for applet screens?

Please also give me the table name which holds that info.

Thanks Anil.

->Jana
Gatekeepers functionality
written by Praveen Kumar Boodala , October 31, 2007
Hi Anil,
I am new to Purchasing module, Can help me in explaing the 'Gatekeepers functionality'
Thank you,
Praveen
hi anil
written by jayanthi pavan kumar , October 31, 2007
i am mca background fresher. i want to learn oracle apps finance plz give me any suggestion is it best for me or not.

thanking you,
pavan
Bank Account Types
written by santhosh , November 02, 2007
Hi All,

I need your suggestion regarding the Account type filed in Bank Accounts Screen.
Navigation for it is : Payables responsibility ->payables-> banks-> bank Accounts.
The field is "BANK_ACCOUNT_TYPE". Actually it is a free flow text. My requirment is that i need to add a list of values or validate the values entered by users. How could i achieve it?

Is that possible for me to add a List of values for the field through Personalisation?
Please suggest me some solution through which i could achieve it?

Regards
Santhosh

Future of Oracle CRM in fusion release
written by Manishe , November 02, 2007
Hi Anil,
Would like to know abt the Future of Oracle CRM (sales. mktg and service modules) in the fusion release. jst finished implementing on 10.2 version. In fusion Is it gonna be replaced by Siebel CRM features. any info on this would of great help.
Anil also, can you pls suggest me any URL which has a huge resource of oracle CRM related info. ..sumwhat similar to your blog.

Well Hats Off to your blog..Chak de
God bless u
MKB
Regarding Parameters
written by Krishnab , November 07, 2007
Hi Anil,
I have requirement like below.
I have created one Concurrent Program and I have Defined 2 parameters for that Concurrent
Program and these 2 Parameters are not mandatory,but user has to enter the value into any one of these parameter among these two.If the user left these 2 Parameters as blank then
the system should not allow to submit the concurrent program and it should display message to user to prompt the user should enter value into any one parameter.I Heard that it is impossible in Oracle Apps,Could you Please suggest whether it is possible or not.If it is Possible how can i do that.
Defining Event Alert
written by Amitha , November 13, 2007
Hi Anil,
I'm facing problem in defining the Event Alert on Custom Table. I'm able to define the periodic alert on Custom Table. I registered the table in Apps for my custom Application and define the event alert on after update but I didnt receive any mails even i updated my table. Could you please help me regarding this and I need this very urgent.

Regards,
Amitha.

...
written by SrinivasReddy , November 14, 2007
anil,
i am unable to open lot of links,i want to read those thinkgs.let me know reason to that
i am giving some of links below
1)what-happens-when-you-login-to-apps
2)why-call-it-apps-and-not-oracle-erp
3)what-are-profile-options-in-oracle ...ETC


...
written by nasir hussain07 , November 14, 2007
I am getting a very good knowledge about oracle apps
PO Update through API
written by Vinay , November 15, 2007
Hi Anil,

I am having requirement to update PO once it get's approved.
I have to update PO at line level,if my vendor say he can not supply the full ordered quantity.
And also if he say he can can not send any item,then I want to cancel that line of PO and also if there is only one line then cancel that line or close that line of PO.(Because I can not update that line for 0 item,so what is the alternative.)
How this can be achived.
I want this procees automated.

Thanks & Regards

Vinay


PO Update through API
written by janarthanan , November 16, 2007
hi Vinay,
you can use the API, PO_CHANGE_API1_S.update_po for updating the quantity and price alone.

And for cancelling the PO, you can use PO_Document_Control_PUB.control_document

->Jana
Plz explain wht do we mean by request group.
written by G.Janardhan , November 20, 2007
Plz explain wht do we mean by request group and where it is use in real time scenerio
Becoming an expert 11i Apps DBA
written by Mohammed Arshad , November 26, 2007
Hi Anil,
Ur Blogs look very helpful.Good work.I'm basically an Oracle DBA (8,8i,10g) joining a company having 11i Apps and 10g database . Pls suggest where I've to startfrom to become an expert Apps DBA (I know basics of 3-tier architechtures). Oracle is my pet product and I'm yearing to master Apps stuff also.
...
written by Anil Passi , November 26, 2007
Hi Arshad

Please have a look at Atul's blog[http://onlineappsdba.com] where you will find wealth of information about Oracle Apps DBA Stuff.

Thanks
Anil
UNABLE TO OPEN LINKS
written by SrinivasReddy , November 29, 2007
anil,
i am unable to open lot of links,i want to read those thinkgs.let me know reason to that
i am giving some of links below
1)what-happens-when-you-login-to-apps
2)why-call-it-apps-and-not-oracle-erp
3)what-are-profile-options-in-oracle ...ETC


functional document - O2C
written by Navdeep , December 06, 2007
Hi Anil

I am really thankful to you and Siva for a very summarised document on O2C and P2P. Now I am looking for some document for setup of O2C module as I am going for Functional Consultant role. If you have setup doc, please help me in knowing where it is available or send it to me. My email id is navdeep.garg@gmail.com

Regards
Navdeep
Business group creation --- steps involved
written by farha , December 08, 2007
Hi Anil,


I have come across so many books in my life, i think your way of explaining things is the best of them all . one can never have problems in understanding any topic.
Could you give me a real life example how to create a business group ???

regards,
farha

Is it possible to set record property with personalization?
written by pavel , December 08, 2007
Is there analog in Personalization for the following custom.pll line?

SET_RECORD_PROPERTY(:SYSTEM.TRIGGER_RECORD, 'TOLINES_BLK', STATUS, QUERY_STATUS);
...
written by rsl , December 21, 2007
Hi Anil,
thanks for providing useful materials.
i developed a form, o/p shd display empno,ename.
empno having lov.

first i have created record grp manually as below:
ITEM:Empno
TRIGGER:When-New-Item-Instance

declare
rg_name varchar2(30):='XRECGRP';
rg_id recordgroup;
errcode number;
begin
rg_id:=find_group(rg_name);
if id_null(rg_id) then
rg_id:=create_group_from_query (rg_name,'select empno from emp');
end if;
ERRCODE:=POPULATE_GROUP (RG_ID);
end;


next i created lov at design time(option:manually)name:lov8.
(i didn't change any property)becouse i'm setting recgrp to lov using set_lov_property

in same above code i changed as
declare
lov_result boolean;
rg_name varchar2(30):='XRECGRP';
rg_id recordgroup;
errcode number;
begin
rg_id:=find_group(rg_name);
if id_null(rg_id) then
rg_id:=create_group_from_query(rg_name,'select empno from emp');
end if;
ERRCODE:=POPULATE_GROUP(RG_ID);
set_lov_property ('lov',GROUP_NAME,'XRECGRP');
lov_result:=show_lov('lov8');
end;

it showing errror as:
FRM-30048: Unable to find record group .
LOV LOV8
Form: XFORM_RGRP_LOV
FRM-30085: Unable to adjust form for output.

In Code i have attach record grp to lov(using set_lov_property) why its not taking.

if that lov already consists another record grp then it is setting rec grp used in set_lov_property.i don't want like that.plz ans me.
and is there any way to create lov manually(using code) or we have create at design time only(using create button)
Move Order Number Generation in Order Management Pick Release process
written by BalaMurali , December 27, 2007
Hi Anil,

Your articles are really Good and are very Helpful.

I had a small doubt. How to know the process that is responsible for allotting the move order Header numbers to the Sales Orders, while Pick Releasing.

Please help me by giving some reply.

Thank You,
Murali
Move Order Number Generation in Order Management Pick Release process
written by BalaMurali , December 27, 2007
Hi Anil,

This example suggests what my actual doubt is.

While pick Releasing Sales Orders, a single move order header number is assigned for the lines belongs to different Sales Orders.

My Requirement is to get a distinct move order numbers for the lines belongs to different Sales Orders.

Please suggest me if this is possible or not.

Thank You,
Murali.
sending a report output file as an attachment via email using oracle applications
written by SrinivasReddy Chilkuri , January 03, 2008
Hi Anil,
I need to send a report output file as an attachment via email using oracle applications.when i run the report,output should sent to user who is inside of our organization as well as to customer who is outside of our organization(he dont have our URL access). I do not know where to add the coding for sending the email? i dont know the process

Any help on this appreciated.
Thanks
Srini


TOIs and Delta docs Information Required
written by Greesh , January 14, 2008
Hi Anil,

I am working on upgradation from 11 to R12 on GL module.Could you help me in finding TOIs(Technical Functional).I am not able find TOIs information on metalink.Please see the document note for your reference-

Upgrading to Release 12: 414710.1

Oracle General Ledger Documentation Resources, Release 12

Doc ID: Note:396911.1 Type: REFERENCE
Last Revision Date: 16-FEB-2007
Status: PUBLISHED

Transfer of Information (TOI) Online Training

*First-time TOI users: follow these setup instructions
Functional TOIs

Provides information for users on how to set up and use the new features included in base Release 12.
Includes:
Benefits of new features from a business perspective
Details on product dependencies and interactions
Links to additional resources

Technical TOIs

Contains information about changes made to existing Release 11i features in base Release 12.
Describes the changes made to database objects, profile options, forms, reports, programs, workflows, lookups, and seed data.
Please upload some R12 docs on your portal in this regard especially techical.

Regards,

Greesh

Need Materials on OPM Physical Inventory
written by SanthoshMani , January 19, 2008
Hi Anil

Can You please help me out with the flow involved in OPm Physical Inventory and Cycle count with screen shots?

Thanks
Santhosh Mani
Wrong link
written by AKishore , January 21, 2008
Hell Anil,

Can you fix the link for the below as I am looking for an example for interface.

Design and Development of Open Interfaces in Oracle Apps

Thanks
Kishore
ATO process is not generating a routing for the configured item
written by Jyoti Mohanty , January 23, 2008
Hi Anil,

Could you please clarify my following doubt?

The ATO process for one organization is not generating a routing when creating the configured item. Can you please let me know the reason why this happened & how to iradicate this issue in future?

Thanks in advance for the help.

Regards,
Jyoti
How to delete element if run results exist.
written by Vignesh kumar , January 23, 2008
Hi Anil,

I want to delete element which has run results.

I deleted the element entry using hr_entry_api corresponding to element entry id.but run result exist for that element entry id .

I tried to rollback quick pay and prepayments if any,but i culdn't.
also i deleted element entries from element entry scrren.

kindly suggest me how to delete element in this case.

Thanks and Regards
Vignesh
OTL Setup Document
written by SSHR , January 25, 2008
Hi,

Please let me know where I can find the OTL and OLM Setup document. I am into implementing Core HR and want to get myself trained on OTL and OLM.

Thanks & Regards
SSHR
Data changes tracking using FND_STANDARD.SET_WHO API.
written by Pavankumar B Barlota , January 29, 2008
Hi Anil,

Can you please give me step by step process of how to track the data using FND_STANDARD.SET_WHO API.
I want this to track from Form and concurrent program both.
(In my custom table i have added the WHO columns,
now,whenever user will enter any data to Custom form(Wich i have developed) or changes any data then i want to track the change made and fill this WHO column.)

I was working on some other technology and new this one.
So please elaborate all the needfull.
TOI Information Required
written by Greesh , January 30, 2008
Hi Anil,

I am working on upgradation from 11 to R12 on GL module.Could you help me in finding TOIs(Technical Functional).I am not able find TOIs information on metalink.Please see the document note for your reference-

Upgrading to Release 12: 414710.1

Oracle General Ledger Documentation Resources, Release 12

Doc ID: Note:396911.1 Type: REFERENCE
Last Revision Date: 16-FEB-2007
Status: PUBLISHED

Transfer of Information (TOI) Online Training

*First-time TOI users: follow these setup instructions
Functional TOIs

Provides information for users on how to set up and use the new features included in base Release 12.
Includes:
Benefits of new features from a business perspective
Details on product dependencies and interactions
Links to additional resources

Technical TOIs

Contains information about changes made to existing Release 11i features in base Release 12.
Describes the changes made to database objects, profile options, forms, reports, programs, workflows, lookups, and seed data.
Please upload some R12 docs on your portal in this regard especially techical.

Regards,

Greesh
About Comment Field
written by Arun Babji , February 02, 2008
Hi Anil,
I am following your Apps material.Thank you vey much for the service you are doing towards your flat form members.
I am here becoz, recently our client asked us,they want to enter comments that which they have to found them in Auot Invoices.I saw a Comment Field in sales Order.I enbled it by personalization and gave the data.
After booking the order I find that Comment column to be empty.I also reopened through Organization(B).But there I find the comment field in the disabled mode and didn't find the data which I typed.Please gind me a solution.I searched in metalink also.There they are also not clear about the issue.
Iprocurement
written by srisanth , February 05, 2008
Hi, Anil, Its nice to see a blog on Oracle Apps. I want to if there is any user guide exists for Oracle Iprocurement. I have this Implementation guide. Can you send me the steps and setups to do in Iprocurement.
...
written by Anuj Kumar t , February 06, 2008
Hi Anil,
Can You please provide step by step information of OPM Module,i am new in this module.
I have to learn this module of R12.

anuj
API Required in OPM Conversion in R12
written by Anuj Kumar t , February 07, 2008
Hi Anil,
I am facing a problem of opm item conversion in R12.
I have used GMI_ITEM_PUB--> GMI_ITEM_PVT and
GMIPAPI-->GMIGAPI-->GMIVITM-->GMIVDBL these api for item create.
when i try to create a item through api ,i found an error.
error is-->
err msg 1is: ORA-01779: cannot modify a column which maps to a non key-preserved
table in Package GMI_ITEM_PVT Procedure insert_ic_item_mst
when i try to find out the solution related with this error,
then i got,it should be happen of missing of trigger on that table(ic_item_mst)in R12.
In 11i trigger is working on that table 'ic_item_mst'
I don't now,it is happing because of that trigger or may be some other method for item conversion.
Please give me an idea related with this ,
It's urgent
Thanks in Advance.

Anuj
Wrong Link
written by Shaik Shahid , February 20, 2008
Hi Anil,

Can you fix the link for the below as I am looking for an example for interface.

Design and Development of Open Interfaces in Oracle Apps

Thanks
Shaik
Question re. pick release form
written by Carmen , February 22, 2008
Hi Anil - my compliments on your blog - its excellent.

I'm a business user and I wanted to know what's the difference in functionality btween
"execute now" and "concurrent" ways to run a pick release?
Oracle Applications
written by Bharath , February 26, 2008
I have one problem. That is based on 2 discoverer reports i need to create one discoverer report by gathering some columns in both reports. Can u please send me the step by step process to generate this report.I am very greatfull to u, if u send screen shots also.
Segment Qualifiers in Chart of Accounts
written by santhosh , February 29, 2008
Hi Anil,
We are using 11.5.9. We have implemented Oracle apps 2 yrs back. I have a doubt with value definition for the segments in Chart of Accounts.

While defining the values for the segments, the segment qualifiers pops up based upon the assignment of segment to the flexfield qualifiers. Is that possible to define a new segment qualifer and assign values to that segment qualifier while defining values for the segment?

Regards
Santhosh
Need to CANCEL PO using API
written by Imran , March 05, 2008
Hi Anil,

I need to cancel the POs using API. When I am using:

DECLARE
l_return_status VARCHAR2(1);
BEGIN
--FND_GLOBAL.apps_initialize ('48816','50104','20043');
--call the Cancel API
PO_Document_Control_PUB.control_document (
1.0, -- p_api_version
FND_API.G_TRUE, -- p_init_msg_list
FND_API.G_TRUE, -- p_commit
l_return_status,-- x_return_status
'PO', -- p_doc_type
'STANDARD', -- p_doc_subtype
null, -- p_doc_id
'120991273', -- p_doc_num
null, -- p_release_id
null, -- p_release_num
null, -- p_doc_line_id
null, -- p_doc_line_num
null, -- p_doc_line_loc_id
null, -- p_doc_shipment_num
'CANCEL', -- p_action
SYSDATE, -- p_action_date
null, -- p_cancel_reason
'N', -- p_cancel_reqs_flag
null, -- p_print_flag
null, -- p_note_to_vendor
null); --p_use_gldate
-- Get any messages returned by the Cancel API
FOR i IN 1..FND_MSG_PUB.count_msg
LOOP
DBMS_OUTPUT.put_line(FND_MSG_PUB.Get(p_msg_index => i,
p_encoded => 'F'));
END LOOP;
END;


I am getting errors:
l_return_status :E
You do not have sufficient authority to control the status of this document
...
written by Anil Passi , March 05, 2008
Hi Imran

Do this..
Loop for the PO's that you wish to cancel.
Find the fnd_user.user_id for the buyer of that PO
call fnd_global.initialize by setting the user_id to that of the buyer against that PO
call cancel API
end loop

Thanks
Anil
Thx Anil.....
written by Imran , March 06, 2008
Thx Anil, I got it.........smilies/smiley.gif
To find organization wise subordinates
written by khadeer786 , March 13, 2008
select *
FROM per_org_structure_elements pose,
hr_all_organization_units hou1,
hr_all_organization_units hou2,
hr_all_organization_units_tl hou1tl,
hr_all_organization_units_tl hou2tl
WHERE pose.organization_id_parent = hou1.organization_id
AND pose.organization_id_child = hou2.organization_id
AND hou1.organization_id = hou1tl.organization_id
AND hou2.organization_id = hou2tl.organization_id
AND hou1tl.LANGUAGE = USERENV ('LANG')
AND hou2tl.LANGUAGE = USERENV ('LANG')
and hou1.name like 'Assessment and Testing'

please help me to avoid duplicate rows
...
written by Danda , March 13, 2008
Hi Anil

I need your help on writing host programs. following is my requirement.

Need to create a directory, the dirrectory named will be passed as a parameter. Need to register this program as a concurrent program. Need to capture the concurrent status also. If program error out I need to capture the status.

what are the basic requirements to register host program. I really appriciate your help on this.

Thanks
Srini
need help for creating extensible attributes in an application
written by mythu , March 13, 2008
Hi anil,
I'm very glad to see ur site. I'm a beginner. Can u explain me how to create an extensible attribute using an application.
Inserting a row in Gl_code_combinations table
written by santhosh , March 14, 2008
Hi All,

I am working with an interface, in which i need to generate/retrieve the Code Combination id on the fly with segment values. I have retrieved all the segment values. Now how could i insert the values in GL_Code_combinations?. Is there any API or can we insert directly into the table?

I heard that there is an API named "FND_FLEX_EXT.GET_COMBINATION_ID" .
How to use it? I am new to API's?
Could anyone please help me in this regard?


Regards
Santhosh
Problem with passing parameter to a report through value set.
written by vamsi krishna , March 17, 2008

Hi Anil,

I have a requirement of displaying supplier name as value set (at application level) but to pass its corresponding supplier id as parameter to a report.

Can you pls. let me know on how to proceed. Pls. respond ASAP..

Thanks in advance,
Vamsi.
Item ageing in inventoy
written by Ajay Aggarwal , March 20, 2008
Hi Anil



I have one problem in inventory module

How to calculate the ageing days of items in inventory as on sysdate

For e.g

Like today sysdate is 20-mar-2008

one item BM001 HAS PO RECEIPT 19-mar-2007 with 200 qty.

receipt 15-jul-2007 with 15 qty

receipt 20-jul-2007 with 30 qty



issue 25-mar-2007 with 15 qty

issue 14-jul-2007 with 1 qty

issue 20-aug-2007 with 10 qty

issue 20 -sep-2007 with 5 qty

issue 20-oct-207 with 25 qty

issue 20-dec-2007 with 22 qty





Kindly help me to calculate the no .aging days of that invemtory in system as on sysdate



Thanks and Regards

ajay

Hi Anil
written by Pavithara , March 20, 2008
Hai Anil,
This is Pavithara, working as an oracle apps professional in a leading organisation . Your blog is very useful to us.

Regards,
Pavithara
Delete Service Contract using API ?
written by Shankar , March 21, 2008
Hi Anil,

I want to delete around 1000 service contracts. I want to write a Procedure .Waht is the perfect API in SCM.Please tell me API name.

Thanks
Shankar
oracle configurator
written by vemula , March 21, 2008
Hi Anil,

You are really making so many lifes easy by writing articles on various topics.You are explaining Oracle in very easy way and we get enthusiasm to work on it.

Iam in very urjent need on Oracle Configurator..Can you help me by writing blog on that..

Will be very greatful to you if you can do that...
You must be logged in to a comment. Please register if you do not have an account yet.

busy