Search This Blog

How to set the org context in Oracle ebs 11i and R12

oracle ebs r12


Set org context in R12


1. The SQL command to set the ORG_ID prior to running a script is:

SQL> exec mo_global.init('PN');

exec mo_global.set_policy_context('S','org_id');

The procedure mo_global.set_policy_context has two parameters

p_access_mode and p_org_id

p_access_mode

S ( In case you want your current session to work against single org_id)

M (In case you want your current session to work against multiple org_id )

p_org_id: only applicable if p_access_mode is passed value of "S"