MOAC initialization in EBS

MOAC - Multi-Org Access Control

This feature in R12 version enables users to access secured data in multiple operating units from a single responsibility. End-Users can access data within several operating units based on a Security Profile attached to the responsibility. 

For Single Operating Unit:

begin
mo_global.set_policy_context('S',12345);
end;

MO_GLOBAL.SET_POLICY_CONTEXT ('S', 12345);

S => SINGLE
12345 => Org ID

For Application (More than one Org):

exec apps.mo_global.init('PO');

PO => Purchasing Application

APPS initialization:

For Package Level  Usage:

User ID :  FND_GLOBAL.USER_ID;
Responsibility ID : FND_GLOBAL.RESP_ID;
Responsibility Application ID:  FND_GLOBAL.RESP_APPL_ID;


     FND_GLOBAL.APPS_INITIALIZE( lv_user_id,
       lv_resp_id,
                                                               lv_resp_app_id);

COMMIT;

For Anonymous Package Usage:

select user_id user_id from fnd_user where user_name = '<User_Name>';


select responsibility_id resp_id, application_id resp_app_id from fnd_responsibility_tl where responsibility_name = '<Responsibility_Name>';

     FND_GLOBAL.APPS_INITIALIZE( user_id,
                                                        resp_id,
                                                               resp_app_id);