How to set the org context in Oracle ebs 11i and 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"