Total Pageviews

October 27, 2015

10/27/2015 04:14:00 AM
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;
 
Related Posts Plugin for WordPress, Blogger...