Thursday, 15 September 2011

Organization selection in Oracle Applications.

Today I had to add Organization access to one of the forms. I found that is actually very easy to do.

Step 1: Add 'FND_ORG.CHOOSE_ORG; ' in the WHEN-NEW-FORM-INSTANCE trigger
Step 2: Define 4 parameters in the form; ORG_ID,ORG_CODE,ORG_NAME,CHART_OF_ACCOUNTS_ID

And you are all set, the list of Orgs appearing will be from the Organization Access defined for the current responsibility.

No comments:

Post a Comment

Integrations Lead - Lessons learnt

 Integrations have been my passion for a while but like anything tech there is no credit given when things go right but always heaps of pres...