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
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
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
Thank you so much
ReplyDeletenice
ReplyDeleteHi let ,me know if you are interested in blogging professionally for a company
drop me a mail for details (kmihir@gmail.com)