Total Pageviews

October 27, 2015

10/27/2015 04:44:00 PM
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
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
mo_global.set_org_access(NULL,111,‘ONT’);
END;
 
Related Posts Plugin for WordPress, Blogger...