Org ID Setting in Oracle R12 From Backend

Org ID Setting in Oracle R12 From Backend

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;