SELECT p.profile_option_name short_name,
n.user_profile_option_name NAME,
DECODE(v.level_id,
10001,'Site',
10002,'Application',
10003,'Responsibility',
10004,'User',
'UnDef'
) level_set,
v.level_value level_val,
v.profile_option_value VALUE
FROM fnd_profile_options p,
fnd_profile_option_values v,
fnd_profile_options_tl n
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('&ProfileName%');
I am a software engineer and working as an Oracle Apps DBA. I have started this blog to share my knowledge with others . Here you can find stuff related to Oracle DBA,Oracle Applications DBA,
Wednesday, December 28, 2022
Find EBS Profile Value in All Level
Subscribe to:
Posts (Atom)