R12 MOAC (Multi Org Access Control)

1) R12 offers true Multi-Org Access. Responsibilities are assigned with a Security profile which is a group of operating Units. Assignment is through the

profile option 'MO: Security Profile' set at the Responsibility Level.

2) Security Profile is setup from HR Responsibility. The Security List Maintenance concurrent program must be run each time you add or change Security

Profiles. So from one responsibility you can perform transactions and report on transactions from multiple operating units

3) Pre-R12 you could set your SQL session context for multi-org with the following, Or you could have used FND_GLOBAL.APPS_INITIALIZE to set your context.

BEGIN

dbms_application_info.set_client_info (2);

END;

4) In R12 you can set your SQL session context for a single OU with the following:

BEGIN

Execute mo_global.set_policy_context ('S', 2);

END;

• The ‘S’ means Single Org Context

• 2 is the ORG_ID I want set

5) Also in R12 you can set your SQL session context for multiple OU’s with the following:

BEGIN

Execute mo_global.set_org_access (NULL, 64, 'ONT');

END;

• 64 is the Security Profile you want to use

• ‘ONT’ is the application short name associated with the responsibility you will be using

6) The following SQL will dump out the Security Profiles and Operating Unit Names assigned to them

SELECT psp.SECURITY_PROFILE_NAME,

psp.SECURITY_PROFILE_ID, hou.NAME,

hou.ORGANIZATION_ID

FROM PER_SECURITY_PROFILES psp,

PER_SECURITY_ORGANIZATIONS pso,

HR_OPERATING_UNITS hou

WHERE pso.SECURITY_PROFILE_ID = psp.SECURITY_PROFILE_ID

AND pso.ORGANIZATION_ID = hou.ORGANIZATION_ID;

7) There are three Profile Options you need to be aware of related to Multi-Org that should be set at the Responsibility Level:

MO: Security Profile- Always evaluated first.

MO: Operating Unit- Secondary priority being evaluated after ‘MO: Security Profile’

MO: Default Operating Unit- Sets the default Operating Unit for transactions when running under a Security Profile

/