Begin
dbms_application_info.set_client_info('&ORG_ID');
End;
In R12:
BEGIN
MO_GLOBAL.SET_POLICY_CONTEXT('S', <orgid>);
END;
MO_GLOBAL.SET_POLICY_CONTEXT('S', <orgid>);
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>); -- APPLICATION_ID: Oracle Payables is 200
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>); -- APPLICATION_ID: Oracle Payables is 200
MO_GLOBAL.INIT('SQLAP');
END;
/
/
In SQL*plus
SQL> exec mo_global.init('SQLAP');
exec mo_global.set_policy_context('S','&org_id');
exec mo_global.set_policy_context('S','&org_id');
from ECE_POO_LINES_V; --43721
How to set org context for multi org in r12?
ReplyDeleteHow multi org context works internally?
ReplyDelete