Thursday, 6 August 2015

How to use MO_GLOBAL.INIT

5 comments
Purpose of mo_global.init :-

It will check if new Multi Org Security Profile is set, to decide if new Security Profile method will be used.

If the new MO security profile is set, then mo_global.init inserts one record, for each Organization in Org Hierarchy, in table mo_glob_org_access_tmp

When & from where is mo_global.init called ?

This package procedure will be called as soon as you login or as soon as you switch responsibility. Just like

FND_GLOBAL.INITIALIZE is called. It is safe to assume that Oracle will invoke MO_GLOBAL.INIT after FND_GLOBAL.INITIALIZE


From SQL*Plus, you can simulate login to a specific responsibility by calling
a. Call FND_GLOBAL.INITIALIZEThis will set your responsibility id, user_id etc
b. call MO_GLOBAL.INITThis will read the MO profile option values for your responsibility/user, and will initialize the Multi Org Access.



Ur's
Amar Alam (Nani)