-----Google Analytics Code Start----> <-----Google Analytics Code Close---->
Home |
Technical Articles |
Training Articles |
Receive Email for New Articles |
Contributors |
Apps Book |
Basic Concepts - List of useful Oracle Apps Articles | | Print | |
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. How to find the Request Group for Concurrent program Using XML Publisher with Pre-Printed Stationary Procure to Pay, Order to Cash, End to End Cycle Functional Documents Fusion Related Return to Home Page ( http://oracle.anilpassi.com) Comments
(246)
![]() ![]() written by Mohan Dutt , November 18, 2006 ![]() 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.
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.
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. ![]() 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 ![]() 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 ![]() 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.
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 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!
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
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.
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
hai
i completed mca in 2006. Now i wnat to do oracle apps pls provide some information about orcle apps
hi
can u tell me how can i add multiple assignments by using fa_mass_additions
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?
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..
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!
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!
Hi Anil
I have some issues while adding code in CUSTOM.pll Please refer to the explanation below: Sub ![]() 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
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
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
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.
Hi Anil,
Could you please send me the P2P document as an attachment in my id mkumar1975@hotmail.com. Thanks Manoj
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
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
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
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
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
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 .
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
Amazing Blog !!!
Really Useful..... Thanks, Meera
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.
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
Hi Anil,
I would be very thankful to you if you give a brief on multi-org. thanx & regards, Pallavi.
Hi
Do you have anything on RICE components?? Regards, Nidhi
Hi,
I would like to know more about the Link between Applications Modules and the Tables. Thanks, Mavis ![]() ![]() 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
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?
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?
Hi,
Are the OCP developer exams worth gaining? thanks
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
Could you please Let me where can i get the buyer setup document.
Thanks Amir
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
Hi Anil,
I am new to Purchasing module, Can help me in explaing the 'Gatekeepers functionality' Thank you, Praveen
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
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
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
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.
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.
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
I am getting a very good knowledge about oracle apps
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
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 and where it is use in real time scenerio
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.
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
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
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 there analog in Personalization for the following custom.pll line?
SET_RECORD_PROPERTY(:SYSTEM.TRIGGER_RECORD, 'TOLINES_BLK', STATUS, QUERY_STATUS);
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) ![]() 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 ![]() 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. ![]() 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
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
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
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 ![]() 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
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
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 ![]() 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.
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
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.
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.
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
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
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
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?
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.
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
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
Thx Anil, I got it.........
![]()
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
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
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.
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 ![]() 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.
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
Hai Anil,
This is Pavithara, working as an oracle apps professional in a leading organisation . Your blog is very useful to us. Regards, Pavithara
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
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.
|
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