How to check profile options in oracle apps from backend

How to check profile options in oracle apps from backend

In this post , We will be discuss about the how to check profile options in oracle apps from backend. I will share the sql query which will help to extract the profile options with values from oracle apps. We will also get the information about , who set this value and when changed these profile option in system. This is one of the detail level profile options sql query in oracle apps which will share you the more detail profile informations in oracle apps. Here below is the detail sql query  to check profile options in oracle apps from backend.

8 Most Important Tables used by ql query  to check profile options in oracle apps from backend.

1.fnd_profile_options

2.fnd_profile_option_values
3.fnd_profile_options_tl
4.fnd_user
5.fnd_application
6.fnd_responsibility
7.fnd_nodes
8.hr_operating_units

Detail sql query to check profile options in oracle apps from backend.

select p.profile_option_name SHORT_NAME, n.user_profile_option_name "PROFILE NAME",
decode(v.level_id, 10001, 'Site', 10002, 'Application',
10003, 'Responsibility', 10004, 'User', 10005, 'Server',
10007, 'SERVRESP', 'UnDef') LEVEL_SET,
decode(to_char(v.level_id), '10001', '',
'10002', app.application_short_name, '10003', rsp.responsibility_key,
'10005', svr.node_name, '10006', org.name, '10004', usr.user_name,
'10007', 'Serv/resp', 'UnDef') "CONTEXT", v.profile_option_value VALUE, v.LAST_UPDATE_DATE 
from fnd_profile_options p,

fnd_profile_option_values v,
fnd_profile_options_tl n,
fnd_user usr,
fnd_application app,
fnd_responsibility rsp,
fnd_nodes svr,
hr_operating_units org
where p.profile_option_id = v.profile_option_id (+)
and p.profile_option_name = n.profile_option_name
--and upper(n.user_profile_option_name) like upper('BNE%')
--and trunc(v.LAST_UPDATE_DATE) > trunc(sysdate-170)
and usr.user_id (+) = v.level_value
and rsp.application_id (+) = v.level_value_application_id
and rsp.responsibility_id (+) = v.level_value
and app.application_id (+) = v.level_value
and svr.node_id (+) = v.level_value
and org.organization_id (+) = v.level_value
and v.LAST_UPDATE_DATE is not null
order by last_update_date desc, short_name, level_set