mo: security profile query

Hi friends, we are going to discuss about the mo: security profile query. We will share the detail sql query which helps to extract the mo security profile informations in oracle apps. We know that mo: security profile helps to implement the MOAC in oracle apps. MOAC means multi org access control. Using MOAC , we can access the multiple operating units from the same/single responsibility in oracle apps otherwise we need to change/switch the responsibility to access the another operating unit in oracle apps application. In MOAC , mo: security profile plays an very important role. In mo security profile in HR responsibility we do assign all of the operating units that one would want a responsibility to access. The one needs to run a concurrent request called “Run Security List Maintenance” from HR which will make those security profile available and allow one to assign them to a responsibility via a profile option called MO: Security Profile. In this post , we are sharing the detail sql query to find out these mo: security profile details in oracle apps. Please find below the complete detail about mo: security profile query.

mo: security profile query

5 Important Tables uses in mo: security profile query

 1.fnd_profile_option_values

 2.FND_PROFILE_OPTIONS_VL

 3.fnd_responsibility

 4.fnd_responsibility_tl

 5.hr.per_security_profiles

Detail Level of mo: security profile query in Oracle Apps

Here below is the sql query to extract the mo: security profile information's in oracle apps.

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

mo: security profile query