Wednesday, March 26, 2014

Oracle EBS R12 Multi-Org Basics (use of FND_GLOBAL / MO_GLOBAL)

FND_GLOBAL.APPS_INITIALIZE for initializing session in Oracle Ebusiness suite

This procedure sets up global variables and profile values in a database session. Call this procedure to initialize the global security context for a database session. You can use it for routines such as PL/SQL or other programs that are not integrated with either the Oracle Applications concurrent processing facility or Oracle Forms (both of which already do a similar initialization for a database session).
Ex.
exec FND_GLOBAL.APPS_INITIALIZE (1152, --appplication user id
                            51200,                                       --responsibility id
                            385,                                           --applicaton id
                            0);
                           
MO_GLOBAL.SET_POLICY_CONTEXT
This procedure has two parameters
    p_access_mode
          Pass a value "S" in case you want your current session to work against Single ORG_ID
          Pass a value of "M" in case you want your current session to work against multiple ORG_ID's
    p_org_id
          Only applicable if p_access_mode is passed value of "S"

exec MO_GLOBAL.SET_POLICY_CONTEXT('S',141);

MO_GLOBAL.INIT
This will read the MO profile option values for your responsibility/user, and will initialize the Multi Org Access
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
exec  MO_GLOBAL.INIT ('CE');

No comments:

Post a Comment