How to set the Organization Context in R12

To set org context to any specific single org:

BEGIN
   MO_GLOBAL.SET_POLICY_CONTEXT('S', ); 
END;

To set the mo security profile so that sqlplus will have same org context as given responsibility

DECLARE
   l_resp_id number;
   l_user_id number;
   l_security_profile_id number;
   l_org_id number;

BEGIN

   SELECT user_id
     INTO l_user_id
     FROM fnd_user
    WHERE user_name LIKE '&USER_NAME';

   SELECT responsibility_id
     INTO l_resp_id
     FROM FND_RESPONSIBILITY_VL
    WHERE responsibility_name LIKE '&responsibility_name';

   FND_GLOBAL.APPS_INITIALIZE(l_user_id,
                              l_resp_id,
                              ); -- APPLICATION_ID: Oracle Payables is 200 

   MO_GLOBAL.INIT('SQLAP');

END;
/

Related Posts by Categories