How to set org context in Oracle apps R12 and 11i

How to set org context in Oracle apps R12 and 11i

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('AR');
   exec mo_global.set_policy_context('S','&org_id');
2. Enter the org_id when prompted.

The procedure - mo_global.set_policy_context has two parameters
p_access_mode & p_org_id

p_access_mode	Description
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_IDs

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

If using Toad
Begin
mo_global.set_policy_context(‘S’, &org_id);
End;

Set org context in 11i:

1. The SQL command to set the ORG_ID prior to running a script is:
• SQL> execute dbms_application_info.set_client_info(&org_id);

2. Enter the org_id when prompted.

If using Toad

Begin

fnd_client_info.set_org_context(&org_id);

End;