Login
Register

Home

Trainings

Fusion

R12

Blogs

Contact Us

Common Apps Training Articles
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new Click here to raise Support Ticket. Get reply within 48 hours.

Search Courses

User Rating: 5 / 5

Star ActiveStar ActiveStar ActiveStar ActiveStar Active
 
A reader suggested that Apps Training Articles are quite scattered, hence suggested a single access point.

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

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

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



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

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

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

Using XML Publisher with Pre-Printed Stationary

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

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



Oracle Workflows Training and Examples / Tutorials

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


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


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

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


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

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


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


Oracle Projects, Grants & Purchasing

Encumbrance Migration to Oracle Grants for Open Purchase Orders


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

Fusion Related
http://www.google.com/search?q=site:apps2fusion.com+oracle-fusion-development-tools


Miscellaneous Other articles

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

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


Discoverer 
Discoverer 4i to Discoverer 10g Migration Steps
Invoke Discoverer Report from Oracle Applications
Oracle Discoverer Overview
Discoverer Installation and EUL Setup

 

 

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


Anil Passi

Overall Rating (0)

0 out of 5 stars
  • 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

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • 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.

    Short URL:
  • 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

    Short URL:
  • 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.

    Short URL:
  • 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

    Short URL:
  • hi anil,

    What is the difference between interface,conversion and migration?

    Thanks,
    YJ

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • hi anil,

    What is the difference between interface,conversion and migration?

    Thanks,
    YJ

    Short URL:
  • 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

    Short URL:
  • 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.

    Short URL:
  • Hi YJ,

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

    Please check on Monday.

    Thanks
    Anil

    Short URL:
  • As requested, please find the two articles

    Hierarchy Profile Options http://www.google.com/search?q=site:apps2fusion.com+hierarchy-profile-options

    Also, another article that explains difference between migration/conversion & interface practices in Apps
    http://www.google.com/search?q=site:apps2fusion.com+open-interfaces-in-apps-ebs-best-practices

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

    Thanks
    Anil Passi

    Short URL:
  • Anil,
    your site is very infromative. Can you touch upon writing fast formulas in application.

    Thanks
    Sastry

    Short URL:
  • 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.

    Short URL:
  • Hi YJ,

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

    Please check on Monday.

    Thanks
    Anil

    Short URL:
  • As requested, please find the two articles

    Hierarchy Profile Options http://www.google.com/search?q=site:apps2fusion.com+hierarchy-profile-options

    Also, another article that explains difference between migration/conversion & interface practices in Apps
    http://www.google.com/search?q=site:apps2fusion.com+open-interfaces-in-apps-ebs-best-practices

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

    Thanks
    Anil Passi

    Short URL:
  • Anil,
    your site is very infromative. Can you touch upon writing fast formulas in application.

    Thanks
    Sastry

    Short URL:
  • Thank you so much. Great blog will visit over and over. Want to see you java concurent program.
    Have a great day.

    Short URL:
  • Thank you so much. Great blog will visit over and over. Want to see you java concurent program.
    Have a great day.

    Short URL:
  • Hi Ripal,

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

    Thanks,
    Anil

    Short URL:
  • 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

    Short URL:
  • Hi Anil,
    You are doing a great job.
    My heartiest congratulations to you.
    Do you have any EAM set up?
    Regards
    Ripal

    Short URL:
  • 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.

    Short URL:
  • Hi Ripal,

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

    Thanks,
    Anil

    Short URL:
  • 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

    Short URL:
  • Hi Anil,
    You are doing a great job.
    My heartiest congratulations to you.
    Do you have any EAM set up?
    Regards
    Ripal

    Short URL:
  • 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.

    Short URL:
  • Hi Anil, Please let me know how to default/replace the Item Master Rates from the latest PO Item rate.

    Thanks

    raju

    Short URL:
  • Hi Anil, Please let me know how to default/replace the Item Master Rates from the latest PO Item rate.

    Thanks

    raju

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • Hi Reddy,

    I am writing on functional topics these days.
    Thus far 5 articles have been written, that can be acessed from link http://www.google.com/search?q=site:apps2fusion.com+hr-suite/19

    Thanks,
    Anil passi

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • Hi Reddy,

    I am writing on functional topics these days.
    Thus far 5 articles have been written, that can be acessed from link http://www.google.com/search?q=site:apps2fusion.com+hr-suite/19

    Thanks,
    Anil passi

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • 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?

    Short URL:
  • 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?

    Short URL:
  • .


    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://www.google.com/search?q=site:apps2fusion.com+java-concurrent-programs-in-oracle

    Thanks
    Anil Passi


    .

    Short URL:
  • 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

    Short URL:
  • .


    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://www.google.com/search?q=site:apps2fusion.com+java-concurrent-programs-in-oracle

    Thanks
    Anil Passi


    .

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • .
    .
    .
    .

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

    Short URL:
  • .
    .
    .
    .

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

    Short URL:
  • .
    .
    .
    .
    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

    Short URL:
  • 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.

    Short URL:
  • 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.

    Short URL:
  • Thanks Anil.

    Regards
    Santhosh

    Short URL:
  • .
    .
    .
    .
    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

    Short URL:
  • 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.

    Short URL:
  • 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.

    Short URL:
  • Thanks Anil.

    Regards
    Santhosh

    Short URL:
  • Hi Santosh,
    This is listed in interview questions.
    Thanks
    Anil Passi

    Short URL:
  • Hi Santosh,
    This is listed in interview questions.
    Thanks
    Anil Passi

    Short URL:
  • 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.

    Short URL:
  • 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.

    Short URL:
  • .
    .
    .
    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

    Short URL:
  • .
    .
    .
    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

    Short URL:
  • 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.

    Short URL:
  • 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.

    Short URL:
  • Guest - Deblina

    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.

    Short URL:
  • Guest - Deblina

    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.

    Short URL:
  • Anil,

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

    Thanks.

    Short URL:
  • Anil,

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

    Thanks.

    Short URL:
  • 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!

    Short URL:
  • 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!

    Short URL:
  • Great blog...keep it up !

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

    sajeedmujawar@gmail.com

    Regards, Sajeed

    Short URL:
  • Great blog...keep it up !

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

    sajeedmujawar@gmail.com

    Regards, Sajeed

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • .
    .
    .
    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

    Short URL:
  • .
    .
    .
    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

    Short URL:
  • 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

    Short URL:
  • Anil,
    Thanks a lot for ur reply.i will work hard as per your guidance and keep questioning you.
    thanks
    again
    Shell

    Short URL:
  • Hi Anil;
    I was wondering if you can help me out with our Logon Securities predicament: We have set up some generic apps ids that are only known to a handful of users. Regular but unauthorized users are trying to sign-on using these generic ids by guessing the password and end up locking them when they exceed sign-on attempts. Is it possible to trace these unauthorized users? (via ip address or terminal id?) (We are on 11.5.8)

    Thanks, Al

    Short URL:
  • 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

    Short URL:
  • .
    .
    Hi Madhu

    Have a look at the comment section of link http://getappstraining.blogspot.com/2006/10/orgid-and-multi-org-in-oracle-apps.html

    The answer to your question has been discussed there.

    Thanks,
    Anil Passi

    Short URL:
  • 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

    Short URL:
  • Great work Anil with your amazing experience and skill. I planned to take ocp-ebs - SCM track. Can I have some sample questions.

    Short URL:
  • 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

    Short URL:
  • hi anil,
    your blog is really very helpful for people you need help for oracle applications.
    with regards
    murthy

    Short URL:
  • Hi Venkat,

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

    Cheers
    Anil Passi

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • 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.

    Short URL:
  • 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.

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • 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.

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • dear anil

    what is open purchase order?

    Short URL:
  • 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

    Short URL:
  • 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

    Short URL:
  • Hi Nemai

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

    thanks
    anil

    Short URL:
  • Short URL:
  • Hi Manish

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

    Thanks,
    Anil

    Short URL:
  • Can u please send me interview questions on INV, OM & PO

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

    Short URL:
  • 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.

    Short URL:
  • 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

    Short URL:
  • 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.

    Short URL:
  • 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

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

    Short URL:
  • 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?

    Short URL:
  • 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.

    Short URL:
  • Hi Sheeba

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

    THanks
    Anil

    Short URL:
  • 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?

    Short URL:
  • Hi keyur

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

    Thanks,
    Anil Passi

    Short URL:
  • 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.

    Short URL:
  • 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?

    Short URL:
  • 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

    Short URL:
  • Thanks Anil

    Short URL:
  • Hi ,

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

    Short URL:
  • Guest - Shiva

    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

    Short URL:
  • Hi Anil

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

    THanks!
    Mayank

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

    Short URL:
  • 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

    Short URL:
  • 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

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

    Short URL:
  • 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!

    Short URL:
  • 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

    Short URL:
  • 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.

    Short URL:
  • 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

    Short URL:
  • 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.

    Short URL:
  • Hi Rajeev
    I have covered this in below link, simply search on excel [although not in context of XMLP]
    http://www.google.com/search?q=site:apps2fusion.com+technical-interview-questions-oracle-apps

    Thanks,
    Anil

    Short URL:
  • hi
    Anil
    Can u provide India Localization related stuff
    Regards
    Mohan.Katepalli

    Short URL:
  • Hi Mohan,

    I am yet to work on Indian Localizations myself.

    Thanks,
    Anil Passi

    Short URL:
  • 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

    Short URL:
  • 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.

    Short URL:
  • No problems Ashok.

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

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

    Short URL:
  • 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

    Short URL:
  • Guest - Anil Passi

    Hi Nimish,

    Please can you elaborate your question >:(

    Thanks,
    Anil Passi

    Short URL:
  • Guest - Nimish

    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!

    Short URL:
  • Guest - Ajay Singh

    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

    Short URL:
  • Guest - Anil Passi

    Hey Ajay

    Good luck with your job.

    Thanks,
    Anil Passi

    Short URL:
  • Guest - Mandev

    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.

    Short URL:
  • Guest - Anil Passi

    Hi Mandev

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

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

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

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

    Thanks,
    Anil

    Short URL:
  • Guest - Tony

    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

    Short URL:
  • Guest - Anil Passi

    Hi Tony

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

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

    Thanks,
    Anil

    Short URL:
  • Guest - swapna

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

    Short URL:
  • hi
    can u tell me how can i add multiple assignments by using fa_mass_additions

    Short URL:
  • Guest - subbareddy r

    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?

    Short URL:
  • Guest - Anil Passi

    Hi Subb,

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

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

    Thanks
    Anil

    Short URL:
  • Guest - Kapil Kaushik

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

    Short URL:
  • Guest - User

    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!

    Short URL:
  • Guest - User

    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!

    Short URL:
  • Guest - Shweta Naugaiya

    Hi Anil
    I have some issues while adding code in CUSTOM.pll
    Please refer to the explanation below:
    Sub:Deselecting 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

    Short URL:
  • Guest - vivek khosla

    Hi Anil ,

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

    thanks
    Vivek

    Short URL:
  • Guest - Anil Passi

    Hi Vivek

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

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

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

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

    Thanks,
    Anil Passi

    Short URL:
  • 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

    Short URL:
  • Guest - JayaKrishna

    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.

    Short URL:
  • Guest - Manojkumar

    Hi Anil,
    Could you please send me the P2P document as an attachment in my id mkumar1975@hotmail.com.

    Thanks
    Manoj

    Short URL:
  • 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

    Short URL:
  • Guest - vasu

    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

    Short URL:
  • 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

    Short URL:
  • Hi Anil,

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

    Thanks
    Aniket

    Short URL:
  • Guest - Jaspal

    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

    Short URL:
  • 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 .

    Short URL:
  • Guest - Anil Passi

    Hi Amarnath,

    Thanks for your kind words.

    Please use the SQL below

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

    Thanks,
    Anil Passi

    Short URL:
  • Guest - Hanu

    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

    Short URL:
  • Guest - Meera

    Amazing Blog !!!

    Really Useful.....

    Thanks,
    Meera

    Short URL:
  • 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.

    Short URL:
  • Guest - P Ahuja

    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

    Short URL:
  • Guest - Pallavi

    Hi Anil,

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

    thanx & regards,
    Pallavi.

    Short URL:
  • Guest - Nidhi Gupta

    Hi

    Do you have anything on RICE components??

    Regards,
    Nidhi

    Short URL:
  • Guest - Mavis

    Hi,

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

    Thanks,

    Mavis :-*

    Short URL:
  • Guest - P. Pradeep

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

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

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

    Best regards,

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

    Short URL:
  • Guest - Sandy-kashyap

    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?

    Short URL:
  • Guest - Sandy-kashyap

    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?

    Short URL:
  • Guest - Anil Passi

    Hi Sandy

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

    Usually, HRMS Organizations are mapped to Cost Centres.

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

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

    Thanks,
    Anil Passi

    Short URL:
  • Guest - john

    Hi,

    Are the OCP developer exams worth gaining?

    thanks

    Short URL:
  • Hi Anil,

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

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

    Thanks

    Short URL:
  • Guest - Anil Passi

    Hi John

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

    Thanks,
    Anil Passi

    Short URL:
  • Guest - Amir

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

    Thanks
    Amir

    Short URL:
  • Guest - Jana

    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

    Short URL:
  • Guest - Praveen Kumar Boodala

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

    Short URL:
  • Guest - jayanthi pavan kumar

    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

    Short URL:
  • Guest - santhosh

    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

    Short URL:
  • Guest - Manishe

    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

    Short URL:
  • Guest - Krishnab

    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.

    Short URL:
  • Guest - Amitha

    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.

    Short URL:
  • 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

    Short URL:
  • Guest - nasir hussain07

    I am getting a very good knowledge about oracle apps

    Short URL:
  • 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

    Short URL:
  • Guest - janarthanan

    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

    Short URL:
  • Guest - G.Janardhan

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

    Short URL:
  • Guest - Mohammed Arshad

    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.

    Short URL:
  • Guest - Anil Passi

    Hi Arshad

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

    Thanks
    Anil

    Short URL:
  • 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

    Short URL:
  • Guest - Navdeep

    Hi Anil

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

    Regards
    Navdeep

    Short URL:
  • Guest - farha

    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

    Short URL:
  • Is there analog in Personalization for the following custom.pll line?

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

    Short URL:
  • Guest - rsl

    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)

    Short URL:
  • Guest - BalaMurali

    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

    Short URL:
  • Guest - BalaMurali

    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.

    Short URL:
  • 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

    Short URL:
  • Guest - Greesh

    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

    Short URL:
  • Guest - SanthoshMani

    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

    Short URL:
  • Guest - AKishore

    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

    Short URL: