MOAC (Multi Org Access Control) is a feature in R12 that allows users to submit requests and access data from multiple organizations/Operating Units from a single responsibility. The multi org mo security profile query will be the subject of conversation. We’ll teach you how to use a thorough sql query to retrieve information from Oracle apps’ security profiles.
Multi Org Access Control (MOAC) Concept in Oracle Apps R12
We already know that the multi org mo: security profile assists in the implementation of the MOAC in Oracle applications. MOAC stands for multi-organizational access control. We can access multiple operating units from same responsibility in Oracle apps using MOAC, we must change/switch the responsibility in Oracle apps to access another operating unit.
The mo: security profile is incredibly significant in MOAC. We assign all of the operating units that one would want a responsibility to access in the mo security profile in HR responsibility. A concurrent request from HR called “Run Security List Maintenance” will make those security profiles available and allow them to be assigned to a responsibility through a profile option called MO: Security Profile. In this post, we’ll show you how to use a sql query to get the details of these mo: security profile details in Oracle apps. Please see below for more information on mo: security profile query.
Important Tables uses in multi org mo security profile query
- FND_PROFILE_OPTION_VALUES
- FND_PROFILE_OPTIONS_VL
- FND_RESPONSIBILITY
- FND_RESPONSIBILITY_TL
- PER_SECURITY_PROFILES
Query to Get Multi Org (MO) Security Profile Details in Oracle Apps R12
SELECT frt.responsibility_id,
frt.responsibility_name,
psp.security_profile_name,
fnd_prof_opt.USER_PROFILE_OPTION_NAME,
fnd_prof_v.profile_option_value
FROM apps.fnd_profile_option_values fnd_prof_v,
apps.FND_PROFILE_OPTIONS_VL fnd_prof_opt,
apps.hr.per_security_profiles psp,
apps.fnd_responsibility fr,
apps.fnd_responsibility_tl frt
WHERE TO_CHAR (psp.security_profile_id) = fnd_prof_v.profile_option_value
AND fr.responsibility_id = frt.responsibility_id
AND fnd_prof_opt.profile_option_id = fnd_prof_v.profile_option_id
AND frt.responsibility_name LIKE '%Payables%'
AND fnd_prof_v.level_value = fr.responsibility_id