Query to find security profile attached to responsibility

Query to find security profile attached to responsibility

In this post , We will be discuss about Query to find security profile attached to responsibility. This sql query will help to extract the details of security profile attached for the responsibilities in oracle apps. This is one of the useful sql query to get the security profile value for any responsibility in oracle apps. We can find out the security profile attached to a responsibility in oracle apps. Here below is the complete detail about Query to find security profile attached to responsibility.

Query to find security profile attached to responsibility

5 Important Tables used by Query to find security profile attached to responsibility

1.fnd_profile_option_values
2.FND_PROFILE_OPTIONS_VL
3.per_security_profiles
4.fnd_responsibility
5.fnd_responsibility_tl

Detail SQL Query to find security profile attached to responsibility

SELECT frt.responsibility_name, psp.security_profile_name, E.USER_PROFILE_OPTION_NAME
 FROM applsys.fnd_profile_option_values a,
 FND_PROFILE_OPTIONS_VL e,
 hr.per_security_profiles psp,
 applsys.fnd_responsibility fr,
 applsys.fnd_responsibility_tl frt
 WHERE e.profile_option_id = a.profile_option_id
 AND a.level_value = fr.responsibility_id
 --AND a.level_id = 10003
 AND frt.responsibility_name LIKE '%XX%'
-- AND e.profile_option_name = 'PER_SECURITY_PROFILE_ID'
AND TO_CHAR (psp.security_profile_id) = a.profile_option_value
 AND fr.responsibility_id = frt.responsibility_id