Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Monday, August 1, 2011

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;
/

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect