...
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.

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