Org ID Setting in Oracle R12 From Backend

BEGIN

dbms_application_info.set_client_info(101);

END;

• In this example 101 is the ORG_ID for the Operating Unit or you could have used FND_GLOBAL.APPS_INITIALIZE to set your context.

In R12 you can set your SQL session context for a single OU with the following:

BEGIN

execute mo_global.set_policy_context('S',101);

END;

• The ‘S’ means Single Org Context

• 101 is the ORG_ID you want set

Also In R12 you can set your SQL session context for multiple OU’s with the following:

BEGIN

execute mo_global.set_org_access(NULL,111,‘ONT’);

END;