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

This e-mail address is being protected from spambots. You need JavaScript enabled to view it

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?

This e-mail address is being protected from spambots. You need JavaScript enabled to view it

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 add***s 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

Hi Manish

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

thanks,
anil

...
written by Anil Passi , March 31, 2007

Hi Manish

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

Thanks,
Anil

...
written by Partha , April 02, 2007

Can u please send me interview questions on INV, OM & PO

...
written by RK , April 06, 2007

Anil,
SQL n PLSQL can be practiced using database. What about D2K, is it JDeveloper?

...
written by Keyur Joshi , April 12, 2007

Hi,
I am a functional person. Just changed my field and into Oracle Apps, after 10 years of hardcore process manufacturing experience. I have started with learning basic modules, Purchasing, GL,AP,INV. My focus is to master the process manufacturing module. Can u pl. tell me what is the first step in learning oracle. There are so many things out there that i got confused, PL. HELP.

...
written by Keyur Joshi , April 12, 2007

Hi,
I am a functional person. Just changed my field and into Oracle Apps, after 10 years of hardcore process manufacturing experience. I have started with learning basic modules, Purchasing, GL,AP,INV. My focus is to master the process manufacturing module. Can u pl. tell me what is the first step in learning oracle. There are so many things out there that i got confused, PL. HELP.

...
written by Keyur Joshi , April 12, 2007

Could you pl. try to explain considering an end to end implementation scenario, What are the few basic steps involved to start setups. say for a process manufacturing industry manufacturing polymers

...
written by Anil Passi , April 14, 2007

Hi Keyur

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

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

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

Thanks
Anil

...
written by mayur , April 16, 2007

Hi Anil,
I am encountering following problem.

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

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


Can you help me?

...
written by srinivas , April 16, 2007

hi,
please explain interfaces, gl, ap,ar in detail. thanks this site is really helpful.

...
written by sheeba , April 19, 2007

hi Anil,
Your websitte is a good resource for apps enthusiast.
can you give more articles with some examples on workflow.Im a fresher in Apps.

...
written by Anil Passi , April 20, 2007

Hi Sheeba

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

THanks
Anil

...
written by Keyur Joshi , April 21, 2007

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

...
written by Anil Passi , April 22, 2007

Hi keyur

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

Thanks,
Anil Passi

...
written by User , April 27, 2007

Hi, I have something to clarify. Could you please provide your valuable suggestions? Right now,Iam 2 years experienced in the field of Oracle Applications(OM,AR)( I joined as a fresher). Worked on Few outbound interfaces(utl packages) and some customized packages, simple forms and reports. Now, I have been given an option to work on Oracle Discoverer(with training provided from Oracle University). Can you suggest whether to proceed with that? Will that come under Oracle applications(ERP)..How is the Market(Future market as well) for that? Is that a kind of stepping down compared to the kind of work that I do? Please clarify. Thanks.

...
written by Keyur Joshi , April 27, 2007

Hello Anil,
I have just started Inventory module. Which i am going to learn in detail, because this the base for any manufacturing application. I am trying to understand the hierarchy and relationships of Items templates,Item categories, categorysets. Could you please throw some light on these topic. Shall be better if any short article which can help. Can I use different category KFF for different items, in the same Organization?

...
written by dilip , May 02, 2007

Hi Anil,
I was as tech.consultant and i am asked to move to Functional suddenly.

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

Thanks in advance!

Dilip

...
written by User , May 03, 2007

Thanks Anil

...
written by Kamal , May 08, 2007

Hi ,

How to make a standalone form in D2K which can run as an independent form without using D2K like we do in VB.

...
written by Shiva , May 09, 2007

Hi Anil,

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

Kind Regards
Shiva

...
written by Mayank , May 10, 2007

Hi Anil

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

THanks!
Mayank

...
written by suresh , May 11, 2007

hi ani
what are the basetables,interface tables,standard conc prog for approved supplter list conversion.

...
written by Keyur Joshi , May 12, 2007

Hello Anil,
I want to restrict the multiple parellel logins from a single username. Can I do this with profile options? Is there any profile options for this? How this can be done? Please HELP.

Regards,

Keyur

...
written by Saroj Kumar Nayak , May 14, 2007

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

Thanks & Regards

Saroj

...
written by Kashyap , May 20, 2007

Hi Anil.
This is Kashyap.Could you please send/give some notes/documents related to Process & Discrete Mfg.
Thanks and regards
Kashyap.

...
written by Apps Developer , May 22, 2007

Hi,

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

Thanks!

...
written by Rinks , May 25, 2007

Hi Anil,

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

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


Thanks,
rinks

...
written by CH , May 30, 2007

hi Anil,

I am into oracle Apps for 3 yrs and wants to pursue the functional stream.My interest is towards HR and CRM.Can you please give me a rough scope about these two.which would has the more viable scope.

...
written by Anil Passi , June 04, 2007

Hi Lucky

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

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

Thanks,
Anil Passi

...
written by Rajeev , June 14, 2007

Hi Anil,

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

I tried but it is giving error it is showing the output as html.

...
written by Anil Passi , June 15, 2007

Hi Rajeev
I have covered this in below link, simply search on excel [although not in context of XMLP]
http://oracle.anilpassi.com/technical-interview-questions-oracle-apps.html

Thanks,
Anil

...
written by mohan , June 21, 2007

hi
Anil
Can u provide India Localization related stuff
Regards
Mohan.Katepalli

...
written by Anil Passi , June 21, 2007

Hi Mohan,

I am yet to work on Indian Localizations myself.

Thanks,
Anil Passi

...
written by Ashok , June 21, 2007

Would like to put job opportunity for Oracle Apps functional on this site, will it be possible?

May update the process and detail?

Do I have to pay for that?

Regards,
Ashok

...
written by User , June 21, 2007

Hi Anil,

Iam intersted to know about Install Base,technically. What kind of information is stored in which tables in order to cash life cycle.
What are the most frequently used tables/columns.

...
written by Anil Passi , June 22, 2007

No problems Ashok.

And, you do not have to pay for that either.

...
written by satya , June 26, 2007

hi anil,
This is Satya,and I want to know about XDO Reports.Could u please help me.
Regards,
Satya

...
written by Anil Passi , June 27, 2007

Hi Bhaskar

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

Thanks
Anil

...
written by Nimish , July 04, 2007

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

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

Thanks!

...
written by Ajay Singh , July 04, 2007

hai
anil i m ajay singh from mumbai . i have 3 years in oracle . im learning oracle apps for last six month . i have basic knowledge of oracle apps and all i got from your great blog . i thanks ful to you . now trying for real time exp .
rest is fine .
Ajay Singh

...
written by Mandev , July 07, 2007

Hi Anil,
I am using your blog since quite a long time for my knowledge upgradation.
I am working in oracle apps since then 3 years,

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

Can u suggest me any resource where i can get a detailed idea for parameters of cost comparison for different ERP's.

...
written by Tony , July 09, 2007

Hi Anil,

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

Thanks
Tony

...
written by swapna , August 04, 2007

hai
i completed mca in 2006. Now i wnat to do oracle apps pls provide some information about orcle apps

...
written by Vishnu , August 07, 2007

hi
can u tell me how can i add multiple assignments by using fa_mass_additions

...
written by subbareddy r , August 07, 2007

hi anil,
U r explaining each and every point amazing.keep it up.
Could u explain how to debugging a report ?
Is there any diff b/n debugging a report in D2K AND apps?

...
written by Kapil Kaushik , August 08, 2007

Hi Anil.

i have recently joined an ERP team in an MNC. Can you (or anybody else withing this group) please help me out and learn Oracle Apps. need to know how to start with it. i am pretty much comfortable with SQL,PL/SQL,forms 6i,forms 9i and reports i and reports 9i and some exposure on 10g too.
Thanks a lot in advance..

...
written by User , August 08, 2007

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

Thanks!

...
written by User , August 09, 2007

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

Thanks!

...
written by Shweta Naugaiya , August 13, 2007

Hi Anil
I have some issues while adding code in CUSTOM.pll
Please refer to the explanation below:
Subeselecting a line on Autocreate Form through CUSTOM.pll

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

For deselecting the line I have written the code:

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

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

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

Regards
Shweta

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

Hi Anil ,

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

thanks
Vivek

...
written by Shailesh , August 20, 2007

Dear Anil,

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

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

Once again, good job!

Shailesh

...
written by JayaKrishna , August 23, 2007

Hi Anil,

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

I have an interview on OPM

PLease let me know if you have any notes on OPM

thanks

JayaKrishna.

...
written by Manojkumar , August 24, 2007

Hi Anil,
Could you please send me the P2P document as an attachment in my id This e-mail address is being protected from spambots. You need JavaScript enabled to view it '> This e-mail address is being protected from spambots. You need JavaScript enabled to view it .

Thanks
Manoj

...
written by lakshminarasareddy , August 24, 2007

Hi Anil,

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


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

Forms 10.1 (Form Compiler): Release - Production

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

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

Form not created


can u please suggest any thing on this one.

Thanx

Lakshmi Narasaiah

...
written by vasu , August 30, 2007

Hi Anil,

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

Thanks & Regards,
Sreenivasa

...
written by Padmaja , August 30, 2007

Dear Mr. Anil

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

Thanks & regards
padmaja

...
written by An**et Mahajan , August 31, 2007

Hi Anil,

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

Thanks
An**et

...
written by Jaspal , September 08, 2007

Dear Anil, What is the exact difference between following profile options:
1) HR: Security Profile
2) HR: Business Group

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

...
written by amarnath , September 13, 2007

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

i hope i will reply to my question soon.
thank u .

...
written by Hanu , September 21, 2007

HI,

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

Thanks
Hanu

...
written by Meera , September 25, 2007

Amazing Blog !!!

Really Useful.....

Thanks,
Meera

...
written by kalyan , September 26, 2007

Hi Anil,
This is the first time iam implementing DBI on Finance,HRMS and Projects.Please can i get guidence from you in understanding the concepts and setups.

...
written by P Ahuja , September 26, 2007

Dear Anil,
Could u please guide the steps on How to make Attachments as mandatory in Oracle Purchase Requisition Form Header section.
Thanks & regards
P Ahuja

...
written by Pallavi , September 29, 2007

Hi Anil,

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

thanx & regards,
Pallavi.

RICE Components
written by Nidhi Gupta , October 05, 2007

Hi

Do you have anything on RICE components??

Regards,
Nidhi

...
written by Mavis , October 09, 2007

Hi,

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

Thanks,

Mavis

urgent requirement: Oracle Technofunctional candidate needed for our very big project.
written by P. Pradeep , October 09, 2007

Job title : Oracle Techno functional.
Location : Coimbatore, India
Duration : Very Long term
Salary : Negotiable

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

Please call me at 0422-3294524 or email me at This e-mail address is being protected from spambots. You need JavaScript enabled to view it '> This e-mail address is being protected from spambots. You need JavaScript enabled to view it

Best regards,

Pradeep Prabhakaran
Resource Analyst
Allied Solutions Group inc.
440-397-0550 x 111
offshore : 0422-3294524
www.alliedgroups.com

...
written by Sandy-kashyap , October 10, 2007

Hi Anil,
Please read the following scenario and advise accordingly:

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

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

...
written by Sandy-kashyap , October 10, 2007

Hi Anil,
Please read the following scenario and advise accordingly:

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

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

OCP
written by john , October 14, 2007

Hi,

Are the OCP developer exams worth gaining?

thanks

Questions on some terminology
written by KReddy , October 15, 2007

Hi Anil,

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

As always you do, I would l**e to see explanation with live examples.

Thanks

Plz Let me where can i get the buyer setup document
written by Amir , October 29, 2007

Could you please Let me where can i get the buyer setup document.

Thanks
Amir

...
written by Jana , October 30, 2007

Hi Anil,
how to find the form names, for the jsp pages as we find for applet screens?

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

Thanks Anil.

->Jana

Gatekeepers functionality
written by Praveen Kumar Boodala , October 31, 2007

Hi Anil,
I am new to Purchasing module, Can help me in explaing the 'Gatekeepers functionality'
Thank you,
Praveen

hi anil
written by jayanthi pavan kumar , October 31, 2007

i am mca background fresher. i want to learn oracle apps finance plz give me any suggestion is it best for me or not.

thanking you,
pavan

Bank Account Types
written by santhosh , November 02, 2007

Hi All,

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

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

Regards
Santhosh

Future of Oracle CRM in fusion release
written by Manishe , November 02, 2007

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

Well Hats Off to your blog..Chak de
God bless u
MKB

Regarding Parameters
written by Krishnab , November 07, 2007

Hi Anil,
I have requirement like below.
I have created one Concurrent Program and I have Defined 2 parameters for that Concurrent
Program and these 2 Parameters are not mandatory,but user has to enter the value into any one of these parameter among these two.If the user left these 2 Parameters as blank then
the system should not allow to submit the concurrent program and it should display message to user to prompt the user should enter value into any one parameter.I Heard that it is impossible in Oracle Apps,Could you Please suggest whether it is possible or not.If it is Possible how can i do that.

Defining Event Alert
written by Amitha , November 13, 2007

Hi Anil,
I'm facing problem in defining the Event Alert on Custom Table. I'm able to define the periodic alert on Custom Table. I registered the table in Apps for my custom Application and define the event alert on after update but I didnt receive any mails even i updated my table. Could you please help me regarding this and I need this very urgent.

Regards,
Amitha.

...
written by SrinivasReddy , November 14, 2007

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

...
written by nasir hussain07 , November 14, 2007

I am getting a very good knowledge about oracle apps

PO Update through API
written by Vinay , November 15, 2007

Hi Anil,

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

Thanks & Regards

Vinay

PO Update through API
written by janarthanan , November 16, 2007

hi Vinay,
you can use the API, PO_CHANGE_API1_S.update_po for updating the quantity and price alone.

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

->Jana

Plz explain wht do we mean by request group.
written by G.Janardhan , November 20, 2007

Plz explain wht do we mean by request group and where it is use in real time scenerio

Becoming an expert 11i Apps DBA
written by Mohammed Arshad , November 26, 2007

Hi Anil,
Ur Blogs look very helpful.Good work.I'm basically an Oracle DBA (8,8i,10g) joining a company having 11i Apps and 10g database . Pls suggest where I've to startfrom to become an expert Apps DBA (I know basics of 3-tier architechtures). Oracle is my pet product and I'm yearing to master Apps stuff also.

UNABLE TO OPEN LINKS
written by SrinivasReddy , November 29, 2007

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

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

Hi Anil

I am really thankful to you and Siva for a very summarised document on O2C and P2P. Now I am looking for some document for setup of O2C module as I am going for Functional Consultant role. If you have setup doc, please help me in knowing where it is available or send it to me. My email id is This e-mail address is being protected from spambots. You need JavaScript enabled to view it '> This e-mail address is being protected from spambots. You need JavaScript enabled to view it

Regards
Navdeep

Business group creation --- steps involved
written by farha , December 08, 2007

Hi Anil,


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

regards,
farha

Is it possible to set record property with personalization?
written by pavel , December 08, 2007

Is there analog in Personalization for the following custom.pll line?

SET_RECORD_PROPERTY(:SYSTEM.TRIGGER_RECORD, 'TOLINES_BLK', STATUS, QUERY_STATUS);

...
written by rsl , December 21, 2007

Hi Anil,
thanks for providing useful materials.
i developed a form, o/p shd display empno,ename.
empno having lov.

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

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


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

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

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

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

if that lov already consists another record grp then it is setting rec grp used in set_lov_property.i don't want like that.plz ans me.
and is there any way to create lov manually(using code) or we have create at design time only(using create button)

Move Order Number Generation in Order Management Pick Release process
written by BalaMurali , December 27, 2007

Hi Anil,

Your articles are really Good and are very Helpful.

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

Please help me by giving some reply.

Thank You,
Murali

Move Order Number Generation in Order Management Pick Release process
written by BalaMurali , December 27, 2007

Hi Anil,

This example suggests what my actual doubt is.

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

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

Please suggest me if this is possible or not.

Thank You,
Murali.

sending a report output file as an attachment via email using oracle applications
written by SrinivasReddy Chilkuri , January 03, 2008

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

Any help on this appreciated.
Thanks
Srini

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

Hi Anil,

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

Upgrading to Release 12: 414710.1

Oracle General Ledger Documentation Resources, Release 12

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

Transfer of Information (TOI) Online Training

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

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

Technical TOIs

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

Regards,

Greesh

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

Hi Anil

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

Thanks
Santhosh Mani

Wrong link
written by AKishore , January 21, 2008

Hell Anil,

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

Design and Development of Open Interfaces in Oracle Apps

Thanks
Kishore

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

Hi Anil,

Could you please clarify my following doubt?

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

Thanks in advance for the help.

Regards,
Jyoti

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

Hi Anil,

I want to delete element which has run results.

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

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

kindly suggest me how to delete element in this case.

Thanks and Regards
Vignesh

OTL Setup Document
written by SSHR , January 25, 2008

Hi,

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

Thanks & Regards
SSHR

Data changes tracking using FND_STANDARD.SET_WHO API.
written by Pavankumar B Barlota , January 29, 2008

Hi Anil,

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

I was working on some other technology and new this one.
So please elaborate all the needfull.

TOI Information Required
written by Greesh , January 30, 2008

Hi Anil,

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

Upgrading to Release 12: 414710.1

Oracle General Ledger Documentation Resources, Release 12

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

Transfer of Information (TOI) Online Training

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

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

Technical TOIs

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

Regards,

Greesh

About Comment Field
written by Arun Babji , February 02, 2008

Hi Anil,
I am following your Apps material.Thank you vey much for the service you are doing towards your flat form members.
I am here becoz, recently our client asked us,they want to enter comments that which they have to found them in Auot Invoices.I saw a Comment Field in sales Order.I enbled it by personalization and gave the data.
After booking the order I find that Comment column to be empty.I also reopened through Organization(B).But there I find the comment field in the disabled mode and didn't find the data which I typed.Please gind me a solution.I searched in metalink also.There they are also not clear about the issue.

Iprocurement
written by srisanth , February 05, 2008

Hi, Anil, Its nice to see a blog on Oracle Apps. I want to if there is any user guide exists for Oracle Iprocurement. I have this Implementation guide. Can you send me the steps and setups to do in Iprocurement.

...
written by Anuj Kumar t , February 06, 2008

Hi Anil,
Can You please provide step by step information of OPM Module,i am new in this module.
I have to learn this module of R12.

anuj

API Required in OPM Conversion in R12
written by Anuj Kumar t , February 07, 2008

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

Anuj

Wrong Link
written by Shaik Shahid , February 20, 2008

Hi Anil,

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

Design and Development of Open Interfaces in Oracle Apps

Thanks
Shaik

Question re. pick release form
written by Carmen , February 22, 2008

Hi Anil - my compliments on your blog - its excellent.

I'm a business user and I wanted to know what's the difference in functionality btween
"execute now" and "concurrent" ways to run a pick release?

Oracle Applications
written by Bharath , February 26, 2008

I have one problem. That is based on 2 discoverer reports i need to create one discoverer report by gathering some columns in both reports. Can u please send me the step by step process to generate this report.I am very greatfull to u, if u send screen shots also.

Segment Qualifiers in Chart of Accounts
written by santhosh , February 29, 2008

Hi Anil,
We are using 11.5.9. We have implemented Oracle apps 2 yrs back. I have a doubt with value definition for the segments in Chart of Accounts.

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

Regards
Santhosh

Need to CANCEL PO using API
written by Imran , March 05, 2008

Hi Anil,

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

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


I am getting errors:
l_return_status :E
You do not have sufficient authority to control the status of this document

Thx Anil.....
written by Imran , March 06, 2008

Thx Anil, I got it.........

To find organization wise subordinates
written by khadeer786 , March 13, 2008

select *
FROM per_org_structure_elements pose,
hr_all_organization_units hou1,
hr_all_organization_units hou2,
hr_all_organization_units_tl hou1tl,
hr_all_organization_units_tl hou2tl
WHERE pose.organization_id_parent = hou1.organization_id
AND pose.organization_id_child = hou2.organization_id
AND hou1.organization_id = hou1tl.organization_id
AND hou2.organization_id = hou2tl.organization_id
AND hou1tl.LANGUAGE = USERENV ('LANG')
AND hou2tl.LANGUAGE = USERENV ('LANG')
and hou1.name like 'Assessment and Testing'

please help me to avoid duplicate rows

...
written by Danda , March 13, 2008

Hi Anil

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

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

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

Thanks
Srini

need help for creating extensible attributes in an application
written by mythu , March 13, 2008

Hi anil,
I'm very glad to see ur site. I'm a beginner. Can u explain me how to create an extensible attribute using an application.

Inserting a row in Gl_code_combinations table
written by santhosh , March 14, 2008

Hi All,

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

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


Regards
Santhosh

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

Hi Anil,

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

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

Thanks in advance,
Vamsi.

Item ageing in inventoy
written by Ajay Aggarwal , March 20, 2008

Hi Anil



I have one problem in inventory module

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

For e.g

Like today sysdate is 20-mar-2008

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

receipt 15-jul-2007 with 15 qty

receipt 20-jul-2007 with 30 qty



issue 25-mar-2007 with 15 qty

issue 14-jul-2007 with 1 qty

issue 20-aug-2007 with 10 qty

issue 20 -sep-2007 with 5 qty

issue 20-oct-207 with 25 qty

issue 20-dec-2007 with 22 qty





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



Thanks and Regards

ajay

Hi Anil
written by Pavithara , March 20, 2008

Hai Anil,
This is Pavithara, working as an oracle apps professional in a leading organisation . Your blog is very useful to us.

Regards,
Pavithara

Delete Service Contract using API ?
written by Shankar , March 21, 2008

Hi Anil,

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

Thanks
Shankar

oracle configurator
written by vemula , March 21, 2008

Hi Anil,

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

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

Will be very greatful to you if you can do that...

Oracle Discoverer
written by Parthadip Bhowmik , March 25, 2008

Hi Anil,

Your blog is too much worthy.......
Can you help me building reports through Oracle Discoverer....

Thanks......

Job and Position Assigment error
written by sushil , April 03, 2008

When we assign Job and Position in Assignment form of Employee> enter and Maintain, and save the information we get an error message mentioning "Please Choose an existing Combination".
Other details given are :
"Position Flexifield" used while giving details in BG
"Job Flexifield" used while giving details in BG
Grade and Groups have not been used.
Do let me know if anyone has any idea of resolution.

...
written by VinodGunjan , April 20, 2008

Hi Anil

Can you write some topics on supply chain please?

Regards
Vinod

Order management API's
written by Begins , April 22, 2008

Hi Anil,

I am a great admirer of the great job that you are doing especially for the newbies.

I was trying to collect some info on APIs.I am right now trying to run an Order managemet Shipping Execution Public API , WSH_TRIPS_PUB.Create_Update_Trip. The manuals, just specify the parameters, but I wonder how to put that into Pl/sql code, as I am a new to this.

I would be grateful if you could direct me on how to run this API,(specifically on how to pass the parameters for this API including the record type variable) with a sample code.

Thanks in advance,
Begins

Matching Prepayment
written by Naveen Mauwala , April 23, 2008

Hi Anil,

I am facing problem in matching the prepayment:

I have made prepayment in USD, but my Invoice is in INR, so when i m trying to match the prepayment to the Invoice the LOV doesn't show the available prepayment.

Will u please help me in resolving the below issue.

Thanks in Adavance
Naveen

...
written by Pradeep Gupta , April 25, 2008

Hi Anil,
Your effort is appreciable. I learnt a lot from ur article.
great job.
cheers...

Shipping Execution API
written by Begins , April 25, 2008

Hi Anil,

I was searching for some info on Shipping execution APIs .
Our company is now working with a logistics system to deliver our finished goods to the customers. So the logistics system will be acting as a warhouse where they would store our finished goods and ship them on demand.

In this process, when they ship the goods, all shipping information will be taken care of by their custom application. They will just send an ASN which holds the shipping info and they want us to send the ASNs to the customers in the customer specific format.

So in the above step, while theysend the ASN, we would like to load all that data into our Oracle ERP using the shipping execution APIs. I would like to know on how this can be implemented.how should I run the APIs , and how can I run all these shipping APIs as as a set and what is the process flow to use each API in this case? I mean in what order these APIs must be run?

Could you please put some light into this?

Thanks in advance.

Begins

Java developer
written by Saddy , May 07, 2008

I am a java developer looking to dive into oracle apps, I am hearing different kinds of stories about java and oracle apps prospects.
Particularly, I am fascinated to work in both areas. Can I find any jobs like that??

Is there any added advantage if an apps developer has java back ground ?

Is there any work that can be done only by an expert in both the fields, etc?

I dont know any thing about apps, your answer will be appreciated.

Thanks for spreading your knowledge.

PO/Req
written by Satheesh Kannan , May 11, 2008

Hi Anil,
I need to cancel requisition lines that are not made to PO. I need to get the complete list of requisitions lines first before I do cancel.
How do i get the list first and do cancel.
Please help

Apps techie OR Apps DBA
written by Jithin Sarath , May 15, 2008

Hi Anil,
I know i am posting this in the wrong section but i was unable to post in your other blog..
I was trained in .NET and then retrained in Oracle Apps technical(forms& reports , PL/SQL) by my company..
Now i work in performance tuning section , where i am involved in tuning the code. I come across requests across all modules.
I wud me in this position for another 6-7 monthes and then i can move on.
My problem is , I can choose either to go to Apps Technical or to Apps DBA since my current profile includes a bit of both.
I am confused as to take which career path. I enjoy coding but at the same time i dont have any problems with DBA work.
Only problem is that i hate shifts.
Please advice...

Thaks in advance,
Jithin

Change LOV using FP
written by Venkat , May 15, 2008

I'm trying to chang the lov(supplier name) on the form APXVDMVD (N)Purchasing super user-->supplybase-->supplier-->find supplier form.
The lov on supplier name field (QF_VENDORS_BY_NAME) currently has 4 columns(supplier name, number, taxpayerId and tax registration number)
I want to add a new column Inactive on Date.
I tried to doing the following
1.Create record group from query
select vendor_name,segment1,num_1099, vat_registration_num,vendor_id, end_active_date from po_vendors order by upper(vendor_name)
2.Attached new record group to LOV
Now I get an error FRM-41826: cannot replace group; columns don’t match lov.
I modified the query and followed the same steps
1.Create record group from query
select vendor_name,segment1,num_1099, to_char(end_date_active, 'DD-MON-YYYY') vat_registration_num,vendor_id, from po_vendors order by upper(vendor_name)
2.Attached new record group to LOV
Now the LOV looks like this
Supplier NameNumberTaxpayerIDTaxRegistrationNum
Abc12345612-Apr-2005
Xyz88755621-Dec-2002

Questions:
Is there any way I can add an extra column to the LOV using FP?
Is there any way I can change the heading of the existing column (in this case TaxRegistrationNum to InactiveOn)?

Thank you,
Venkat.

Change LOV using FP cont.
written by Venkat , May 15, 2008

Lov columns are seperated by "||-||"
Supplier Name||-||Number||-||TaxpayerID||-||TaxRegistrationNum
Abc||-||123||-||456||-||12-Apr-2005
Xyz||-||887||-||556||-||21-Dec-2002

Oracle apps installation in windows vista
written by Praveena , May 25, 2008

Hi Anil,
Your blog is extremely useful. I recently purchased hp laptop which has windows vista OS. I can’t switch back to XP. Can I install Oracle E-Business suite in Vista. Kindly reply to me.
Best regards,
Praveena

...
written by Anil Passi- , May 25, 2008

Hi Praveena

You should instead install EBS within a VMWare Server running linux.
This wil make your EBS instance Windows O/S independent.

Cheers,
Anil Passi

Refreshing eBusiness Center grid via personalization
written by Richard D. Chisnick , May 30, 2008

Hello Anil,

I am posting to this section since I can not post to the appropriate blog. My apologies.

Hopefully, you can help me come up with a solution for a problem I'm having. I am trying to create a menu item that 'refreshes' NOTE_BALI.NOTE_BST, the grid under the Note tab on the eBusiness Center form (ASTRCALL). I thought that JTF_GRID.REFRESH('NOTE_BALI.NOTE_BST') would be the appropriate BuiltIn (built in Type Call Custom Library) to use for the menu. I put the "JTF..." procedure as the argument, and this does not work. I also tried using 'Execute a Procedure' instead, but this also did not work.

After failing with using BuiltIn, I tried using the Property type instead of BuiltIn type. My plan was to use two steps: first clear the grid, and then repopulate it. I wanted to see if there was a way I could just set the value of NOTE_BALI.NOTE_BST to NULL, but this did not clear the grid.

This is proving to be very difficult for me, and any advice on this would be appreciated.

...
written by Amit Goel , July 04, 2008

Hi Anil,

this is really cool stuff.

Thanks,
Amit

eBusiness Center grid refresh resolved - in case anyone could find it useful
written by Richard D. Chisnick , October 01, 2008

So here's what I ended up doing:

First thing to know - the requirement was to toggle a filter on NOTE_BALI.NOTE_BST. The filter displays only one type of Note. So, I was never supposed to clear this grid. Without looking at the details of the JTF_GRID package, I would imagine there is a simple function there that would do this should you require it.

Elements:

1) 2 menu items that get created on the WHEN-NEW-FORM-INSTANCE trigger. "Show -specific- notes only" and "Clear -specific- notes filter". I set up two lines in the personalization for these menu items. Each used an Action type of Menu. I used menu entries Special12 and Special14. This was the "shell" of the solution, and the easy part.

2) Here was the tricky part: I edited CUSTOM.pll, adding these two IF statements within the humongous "event" procedure:

-- show specific notes only
IF event_name = 'SPECIAL12' AND form_name = 'ASTRCALL' THEN

-- set values for start and end dates (assumed that you add these variables at the top of the file)
l_start := name_in('NOTE_BALI_DATES.START_DATE');
l_end := name_in('NOTE_BALI_DATES.END_DATE');

-- created a WHERE clause string here (assumed that this variable is declared)
l_where := (here, you include NOTE_TYPE_MEANING, OBJECT_ID, and ENTERED_DATE in the range between l_start and l_end)

-- grid init
jtf_grid.init('NOTE_BALI.NOTE_BST','AST_NOTES_GRID');

-- finally, apply the filter
jtf_grid.setCharProperty('NOTE_BALI.NOTE_BST', jtf_grid_property.WHERE_CLAUSE, l_where);

END IF;

-- remove the specific notes filter
IF event_name = 'SPECIAL14' AND form_name = 'ASTRCALL' THEN

-- set values for start and end dates (assumed that you add these variables at the top of the file)
l_start := name_in('NOTE_BALI_DATES.START_DATE');
l_end := name_in('NOTE_BALI_DATES.END_DATE');

-- HERE is the MAJOR difference....
l_where := (its the same as before, except you DO NOT include NOTE_TYPE_MEANING)

-- grid init
jtf_grid.init('NOTE_BALI.NOTE_BST','AST_NOTES_GRID');

-- finally, apply the filter
jtf_grid.setCharProperty('NOTE_BALI.NOTE_BST', jtf_grid_property.WHERE_CLAUSE, l_where);

END IF;

Payables Holds
written by santhosh , October 15, 2008

Hi All
I am working in Oracle apps version 11.5.10.
My requirment is :

I want to create two new Custom Invoice types.
Lets take it as Invoice type 'A' and Invoice type 'B'.
I also want to create a new custom hold lets name it as 'Z'.

I need to apply 'Z' automatically only when invoices of type 'A' is created.
How can i do these settings?
Could you please let me know the navigation path for creating custom hold?
Could ayone help me in this regard?

Regards
Santhosh

...
written by Sheena , November 03, 2008

Hi,
I am trying to print a footer and header from plus and export it into excel, but once its exported into excel, the header and footer do not show. They show if exported into PDF. How can I make it appear in excel?
Any ideas will be greatly appreciated

Thanks
Sheena

Oracle Warranty Life Cycle
written by Mohan Prasad , February 11, 2009

Hi,

Please help me with Service contract

--> Warranty Life cycle
--> Subscription End to End Life cycle
--> Usage line life cycle


Thanks
Mohan

re: Screen Getting Locked when two users update the same record in custom form
written by kirubanandh , February 15, 2009

Hi Anil,

The material which u have are really amazing and very useful to many oracle guys.
I have an issue.
We designed many custom forms and in that when two users try to update a single record the screen gets locked for the second user and the system just hangs.
I have not noticed this kind of a behaviour in any of the apps standard forms.
I am creating the block based on the table.But I have seen in standard forms the blocks are based on views.
Will this problem go away if the datablock is created based on a view.
Please advice.

Thanks
Kirubanandh

...
written by Anil Passi--- , February 15, 2009

You need to write a code into ON-LOCK Trigger for that block.
One quick way is to open a CURSOR with FOR UPDATE CLAUSE with the WHERE CLAUSE containing a condition to identify the current record via :block.primary_key field.

cursor c1 is select * from po_headers_all where po_header_id = :po_block.po_header_id for update of po_header_id;
Next-open and immediately close the cursor.

If the record was to be locked by some other user, then you will get a LOCK error straightaway


Another option is the lock error with re-try option, as per standard screens. For that option copy paste the code from ON-LOCK trigger of a standard screen

Thanks,
Anil Passi

re: Problem in using fndload in fnd_request.submit_request
written by kirubanandh , February 18, 2009

Hi Anil,

I am using the FNDLOAD program in apps to download a value set .
I have actually created a pl/sql program and submitted the fndload program using fnd_request.submit_request.
The program completes successfully and the log file says the ldt file has been created,
But I have checked for the file in the corresponding location the file is not present.
I tried to create the ldt file using the standard method from unix box(ie from Putty) it is getting created .
It would be of a great help if you can suggest something on troubleshooting on this problem.
I have given the log file detail below.

FNDLOAD module: Generic Loader
+---------------------------------------------------------------------------+

Current system time is 18-FEB-2009 01:53:56

+---------------------------------------------------------------------------+

Downloading VALUE_SET to the data file /o6_u11/home/applmgr/osp6appl/fnd/11.5.0/patch/115/import/TEST13FEB0902.ldt
Downloaded VALUE_SET TEST13FEB09
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


Thanks and Regards
Kirubanandh

...
written by Nilam , February 23, 2009

Hi Anil,

When I tried to serach some information on Interfaces using the link "Design and Development of Open Interfaces in Oracle Apps" , the page opened is the same as "Reports Customization Steps in Oracle Applications". I am not sure whether there is any problem with my browser or what.
Please have a look on the both the above links on "Basic Concepts - List of useful Oracle Apps Articles" page and let me have brief information on "Interface Development".


Thanks,
Nilam

Record Group is generationg error
written by ZIA , March 14, 2009

Dear Anil,

I am trying to customize the LOV of PAyments Window in Oracle Payables.

I have personalized this form by first using a built-in "Create Record Group from Query"
and then I have attached my Custom Record Group (XXCS_OBJECT_CODE_RG) to the standard LOV.
When I click "Apply Now" I receive the error:
"FRM-41826: Cannot replace group, columns don;t match LOV"

Initially I was using standard Record Group Query and put a condition in the end but it was also not running and
generating the error:
"FRM-40502: Unable to read list of Values"

Later on I decided to write my own custom query. Now I am getting the above mentioned error.

Please help.
This is my custom query:

SELECT
V.INVOICE_NUM,
V.INVOICE_ID,
V.INVOICE_TYPE_LOOKUP_CODE AS INVOICE_TYPE,
NULL AS PAY_ALONE,
V.EXCLUSIVE_PAYMENT_FLAG,
NULL AS PAYMENT_NUM,
NVL(V.INVOICE_AMOUNT,0) - NVL(V.AMOUNT_PAID,0) AS AMOUNT_REMAINING,
NULL AS CHAR_AMOUNT_REMAINING,
0 AS DISCOUNT_AVAILABLE,
NULL AS CHAR_DISCOUNT_AVAILABLE,
SYSDATE AS DISC_DATE,
NULL AS ALWAYS_TAKE_DISC_FLAG,
0 AS DISCOUNT_AMOUNT_AVAILABLE,
SYSDATE AS DISCOUNT_DATE,
SYSDATE AS SECOND_DISCOUNT_DATE,
0 AS SECOND_DISC_AMT_AVAILABLE,
SYSDATE AS THIRD_DISCOUNT_DATE,
0 AS THIRD_DISC_AMT_AVAILABLE,
V.INVOICE_AMOUNT AS GROSS_AMOUNT,
V.DESCRIPTION,
V.ACCTS_PAY_CODE_COMBINATION_ID AS ACCTS_PAY_CODE_COMBI_ID,
V.TERMS_DATE AS DUE_DATE,
NULL AS REMIT_TO_SUPPLIER_NAME,
NULL AS REMIT_TO_SUPPLIER_ID,
NULL AS REMIT_TO_SUPPLIER_SITE,
NULL AS REMIT_TO_SUPPLIER_SITE_ID,
V.RELATIONSHIP_ID,
V.EXTERNAL_BANK_ACCOUN_ID,
NULL AS EXTERNAL_BANK_ACCOUNT_NUM,
NULL AS EXTERNAL_BANK_ACCOUNT_NAM
FROM AP_INVOICES_ALL V
WHERE V.ORG_ID = 82

and this is the standard LOV query,

select v.invoice_num,v.invoice_id,v.invoice_type, v.pay_alone, v.exclusive_payment_flag, v.payment_num, v.amount_remaining,to_char(v.amount_remaining,fnd_currency.get_format_mask(v.currency_code,42)) char_amount_remaining,ap_payment_schedules_pkg.get_discount_available(v.invoice_id, v.payment_num,:pay_sum_folder.check_date,:pay_sum_folder.currency_code) discount_available,to_char(ap_payment_schedules_pkg.get_discount_available(v.invoice_id,v.payment_num, :pay_sum_folder.check_date,:pay_sum_folder.currency_code),fnd_currency.get_format_mask(v.currency_code,42)) char_discount_available, ap_payment_schedules_pkg.get_discount_date(v.invoice_id, v.payment_num, :pay_sum_folder.check_date) disc_date,v.always_take_disc_flag, v.discount_amount_available,v.discount_date,v.second_discount_date,v.second_disc_amt_available, v.third_discount_date,v.third_disc_amt_available,v.gross_amount,v.description, v.accts_pay_code_combi_id,v.due_date,v.REMIT_TO_SUPPLIER_NAME, v.REMIT_TO_SUPPLIER_ID, v.REMIT_TO_SUPPLIER_SITE, v.REMIT_TO_SUPPLIER_SITE_ID, v.RELATIONSHIP_ID,v.external_bank_account_id,apbk.bank_account_num external_bank_account_num,apbk.bank_account_name external_bank_account_name from ap_invoices_ready_to_pay_v v, ap_bank_accounts_all apbk where v.party_id = :pay_sum_folder.party_id and v.invoice_num like :adj_inv_pay.invoice_num||'%' and ((:pay_sum_folder.payment_type_flag = 'M') or (:pay_sum_folder.payment_type_flag = 'R' and v.invoice_type in ('CREDIT','STANDARD', 'DEBIT','EXPENSE REPORT','MIXED','AWT')) or /*Bug5948003, Bug6069211*/ (:pay_sum_folder.payment_type_flag = 'Q' and (v.vendor_site_id = :pay_sum_folder.vendor_site_id or v.invoice_type = 'PAYMENT REQUEST') and ((:system.last_record = 'TRUE' and :system.cursor_record = '1') or (NVL(v.exclusive_payment_flag,'N') = 'N' and nvl(:parameter.pay_alone, 'N') = 'N')))) and v.currency_code = :pay_sum_folder.currency_code and v.payment_method_code = :pay_sum_folder.payment_method_code and nvl(v.payment_function, 'PAYABLES_DISB') = nvl(:pay_sum_folder.payment_function, 'PAYABLES_DISB') and v.set_of_books_id = :pay_sum_folder.set_of_books_id and nvl(v.future_dated_payment_ccid, -1) = DECODE(:parameter.manual_fdp_site_acct_src_flag,'Y',nvl(:parameter.site_fdp_account_ccid,-1), nvl(v.future_dated_payment_ccid,-1)) and v.external_bank_account_id = apbk.bank_account_id(+) order by upper(invoice_num)

Make To Stock (MTS) Business Flow in OA by Sivakumar Ganesan
written by jyo , March 23, 2009

This is regarding the article : Make To Stock (MTS) Business Flow in OA by Sivakumar Ganesan.
I couldnt run the "Update Standard Costs" from Conc Program, as it resultes in error. I cross chekd the detials a couple of times, but no success. If anyone could help me here :
----
+====================================================== ===========+
CMCICU: error processing in main()

Cause: An error is detected in function main() while executing the module CMCICU.

Action: Examine the request log file and contact your Oracle support representative if necessary.

No Error h CSTPSISC.INS_STD_COST (73): ORA-20100: File o1084108.tmp creation for FND_FILE failed.
You will find more information on the cause of the error in request log.

***** End Of Program - Update Standard Costs *****
No Error h CSTPSISC.INS_STD_COST (73): ORA-20100: File o1084108.tmp creation for FND_FILE failed.
You will find more information on the cause of the error in request log.



-------------
Siva could you give me your email . I am jyotsnaguptaATyahooDOTcom

...
written by PrashanthKumar , March 26, 2009

What is the final out come of Oracle Project Costing (Project Type, Template & Project created & Approved, Entered Approved Cost Budget, Entered cost directly in PJC via.PreApproved Exp.Batch, Distributed & Interfaced to GL. Interfaced Cost from PO/AP, Run PSI Update......what next please....)
PrashK

Need info about Oracle AP
written by Ashwini , April 08, 2009

Hi Anil,

Its great checking your website.. I got to know many basic things about oracle apps clearly. It is really easing my job. I am working in Oracle apps.

I wanted some more information from you. I can not find any material related Oracle Account Payables.
It will be of great help if you can give basic flow and explaination of important topics in Account Payables Module.

Thanks
Ashwini

Hi Anil
written by Srilatha Alla , April 28, 2009

I am intrested to help you regarding knowledge sharing to other.please tell me how can it possible.

OAF is Fusion's or Apps architecture?
written by Harpreet Kaur , June 04, 2009

Is OAF is Fusion architecture or Oracle Apps's ? I am working in Oracle Apps But generally people inquire whether I know OAF or not? Is this Oracle Apps framework or Fusion's I get confused. Please let me know

How to disable Button inside a message box that opens in the assignment screen while performing some steps
written by saurabh srivastava , June 06, 2009

Dear Anil,
I am entering some grade in grade screen under employee assignment, and a popup message box opens with three buttons: "Yes","No" and "Cancel". Is it possible to hide/disable the "Yes" button and if yes then please explain the steps. As I am working on Production and need to deliver the functionality tmrw in the morning (India time), please do reply soon.
Regards,
Saurabh

Ms
written by Suhani Rajput , June 29, 2009

Dear Mr.Passi,

Me again Suhani! Sorry to write so many times but I'm a bit confused with the blog as there are so many areas to comments may be I'm very new to this website kindly bare with me please till I familiarise with it.

My email is This e-mail address is being protected from spambots. You need JavaScript enabled to view it '> This e-mail address is being protected from spambots. You need JavaScript enabled to view it . I'm based in UK as well. My comments and 3 queries that I had in my mind were about Ora Apps Funcitonal Stream, I'm sure you must have already read them by now.

I look forward for a reply on This e-mail address is being protected from spambots. You need JavaScript enabled to view it '> This e-mail address is being protected from spambots. You need JavaScript enabled to view it please.

Many thanks
Suhani

...
written by Anil Passi- , July 04, 2009

Hi Suhani

Are you looking for Functional Financials Training in Oracle Applications?
If so, you can visit http://focusthread.com/training

We have launched hands on Functional Implementation training on FocusThread

Thanks,
Anil Passi

Need information about Balancing Segment value in R12
written by ashwini0917 , July 08, 2009

Hi Anil,

I am learning R12 GL ledger setups. I have doubt here. In R11i while setiing up Set of book we will just create one COA structure and attach it to SOB definition and this SOB will attached to Legal entity.

In R12 new feature has come that we can define legal entity while defining ledger itself.
The doubt that I have here is What is the significance of attaching Balancing Segment value at legal Entity Level and Legder level.

It will be very helpful if you provide me some inputs o this.

Thanks
Ashwini

constraint definition language
written by Renuka , July 27, 2009

hi Anil,

Thanks for creating this site.It is very useful for beginners like me.I read article related to Configurator rules.But it will be great if you can have with more examples...Because I could find only limited articles related to statement rules.If you can contribute more examples,it would be of great help.

Regards
Renuka

Help with FRM-40502: Oracle error: unable to read list of values
written by Matias , July 30, 2009

Hi,

I'm facing the same problem ZIA wrote last March 14th. I want to modify the lov of APXPAWKB form and I got the mentioned error.

Could please someone help me? or at least tell me how can I contact ZIA to check if could fix it?

I think I tried everything and still can't solve it.

Thanks in advance

Matias

...
written by Syam S Pai , August 08, 2009

I am now currently working in PO module
Can you please give some advice to shape up my career to be a good knowledgeable person in Apps.
Which all areas i need to look on.
I am now studying JAVA concepts and all.

With Regards
Syam S Pai

Help with FRM-40502: Oracle error: unable to read list of values
written by Joaquin , September 01, 2009

I'm facing the same problem ZIA wrote last March 14th and Matias wrote last July 30....
Could please someone help me? I tried with global variables and nothing... I´m lost
Thanks in advance

...
written by Anil Passi- , October 01, 2009

Hi Joaquin

When you create a custom record group via personalization, you must ensure the following
1. Number of selectable columns is exactly the same as the record group being replaced
2. Name of selectable columns is exactly the same as the record group being replaced
3. Data type of selectable columns is exactly the same as the record group being replaced

Thanks,
Anil Passi

Data To get Stored in the Custom Table
written by Murugesh , November 26, 2009

Hi Anil,

when data is inserted in the per_all_people_f I need the same data to get inserted in the custom table. I have read one article of yours some time before explaing the functionality of how to do it but I am unable to recollect it now can you let me know the article name

Thanks & Regards,
R.MURUGESH

...
written by Anil Passi- , November 26, 2009

Hi Murugesh

You can either use business events or use Functional trigger on per_all_people_f

Thanks
Anil

mjpassion
written by hasnainamjad , December 15, 2009

Hi Anil,

Thanks a lot for the all the informative articles posted by you.
However i am looking for some article , which describes how different modules of Apps fit in an Organisation.
How would the organization work in the absence of any module like AP , AR etc.
How to understand complex terms like Credit Memo, Debit Memo , Invoices , SOB , COA etc from a layman's perspective.

Could you please guide me to some resource which would answer above questions.

Thanks in advance
mjfocus

Org Hierarchy issue
written by Meenakshiing orhganization, Oracle showing iuo an , February 01, 2010

Hi Anil,

When we are trying to move or delete an subordinatye form an exist oracle showing up on ERROR saying, it is not allowed to update or delete that are linked to
Oracle Projects.

Now Oracle has come up with solution copy the existing hierarchy and create a bbnew Vercion and then try to Delete. but we are not preferring this way, please let me know why and how Oracle projects is affected and not allowing to do the changes.

Thanks

Functional Consultant Fin & Scm
written by Balajis.consultant , August 29, 2010

Hi Anil

I am searching for a presentation illustrating differnces between 11i and Release 12. Please let me know if you have any reference.

Thanks

Balaji.S

ar_transaction_pub
written by Brajesh Shukla , February 23, 2011

Hi Anil,
Can you please tell me what is the replacement of API ar_transaction_pub in R12???

Regards,
Brajesh

Oracle Asset Management Integration with Other Modules
written by sunil , March 09, 2011

Hi Anil,

Recently i saw ur blog on oracle apps and it was excellent and thanks for ur posts.
I am working on oracle apps on Asset Management module.
I want to know the integration of Asset Management module with other modules. and also the concepts (deep)

And one more thing is that I cannot find any information on Asset Management.
The guys working on Asset Management module will be happy if you write some posts on this module..


thanks

Need Project Accounting Standard reports Details as well as Project Accounting Costing User guide
written by Girish , June 20, 2011

Hi All,

I need the list of Standard Reports that we run in Project Accounting to clean up the data from Interfaces. In addition to that I am looking for some documents in which I can get the
complete information of Project Accounting from Granaular level.

Kindly do the needful

Thanks
Giirsh

answer this post
written by ClemonsSONJA30 , July 16, 2011

One admits that our life seems to be high priced, but some people need cash for different stuff and not every man gets enough money. Therefore to get quick credit loans or credit loan should be good solution.

Number Format in 2 decimal in Excel Output---- XML Publisher
written by samba , August 26, 2011

hi i developed a report using XML Publisher.our requirement is the out put format should be EXCEL and in the Excel output the Number format should be 2decimal . Its getting fine for more than 3 degits. But the problem is when the number is less than 4 digits i.e for example for 456.00 it is displaying as 456 only and 0.0 displayed as 0 only .... how to overcome this?.. And that is in Number format only not in the text format.

Any body Can help me????

Thanks in Advance
Samba

go
written by merckenzie , February 21, 2012

Ray Ban cups ought to start off innovating all over again. It looks like loads of corporations usually are at their heels. The new that will make to help Ray Ban cups can be a firm identified as Apartment eye protection. Though they're not too often known as Ray Ban cups, they've remained with us for years. Devised for just about all people who would like wonderful creator reading glasses, the company just introduced their brand new assortment.
ray ban wayfarer Ray Ban cups never have still introduced almost any click claims. The actual creator reading glasses specifics likewise comprise skulls along with goods. The actual replacing improved lenses usually are designed with exceptional improved lenses which can be really one of a kind.



Showcase the actual Ray Ban cups that will make assortment, a number of little goods pick up to help anyone who seem to needs. Additionally, each reading glasses model includes a situation. You will find available considerably more for the Ray Ban cups that will make simply by cell phone or even simply by their web site.

Ray Ban cups can’t possibly be really pleased about this announcement.lunettes ray ban Last thirty days Apartment Eye protection introduced their 2010 Eye protection replacing improved lenses assortment. Beneath an innovative partnership, Apartment Eye protection features acquired the capacity to enhance the company. Inbuilt The european union, the actual spherical reading glasses assortment consists of over the dozens replacing improved lenses made from silver precious metal as well as steel. Ray Ban cups is usually actually coming from Italy.

The actual Ray Ban cups that will make BOSS Ilario Sfoggia looks like really pleased as well as states, “John Richmond can be a celebration with the electrical power, imagination as well as of childhood as well as street culture. Replacing improved lenses kinds usually are intensely counting play workout plans combined together with street tasteful, John’s personal irreverent model as well as high quality precision. ”

The actual Ray Ban cups that will make firm had been built ages past.
ray banDavid Richmond is an English replacing improved lenses specialit in Italy. Regarding through 20 several years she has toiled beneath their personal appoint producing 3 replacing improved lenses lines.

Stay tuned for additional Ray Ban cups announcement.

ok ,that is nice
written by merckenzie , February 27, 2012

Perry, the 14-time champion about the PGA Expedition, birdied 3 involving the primitive 8 holes, with no a single anytime obtained afterpiece compared to 4 photos later which.Lunettes de soleil "He performed very, real effectively, inch stated Tom Lehman, commutual using Perry within the final round. "Two-under-par today is really a real acceptable rating. Having been attractive abounding error-free during the day. It had been boxy to obtain any kind of burden upon him or her. "Langer eagled Number seventeen to the 3rd beeline day in the seventy. "It was obviously a acceptable few days, inch Langer stated. "I performed effectively,ray ban pas cher really simply that Perry happened to run away with it. They set up the silly accounts (Saturday) and performed able-bodied once again. inch Lehman test the seventy two to round Bill Glasson (6 and Paul Goodes (69) with fourteen below. Lehman was at extra for a lot of through the day, however bogeyed Number twelve and bogeyed the par-5 seventeenth later hitting the position test within the drinking water.lunettes ray ban First-round flandrin Lewis Mize had been upset for extra about the hold up against opening, however place 2 peace of mind within the baptize and achieved with a seventy five to bead to 7th with twelve below. "Much tougher day with the wind flow, inch Mize stated. "We had 2 perfect moiteur to try out and today was obviously a boxy day.

...
written by GN , February 29, 2012

Hi Anil,

Your blog is really helpful.
Could you please guide me as I want to create Asset, basically it can be upon day to day work in organization.
Technical asset I want to create.

Thanks,
GN

Oracle Application Developer
written by HossamEbada , May 10, 2012

Hi Anial
the following link dosn't work
Oracle Discoverer Overview
http://www.apps2fusion.com/apps/apps/439-oracle-discoverer-training

http://www.n**eMercurialVapor9football.com
written by Vapor 9 , August 17, 2012

Hot Sale Mercurial Vapor 9