Introduction
This Post illustrates the steps required to get Profile Option Values at Responsibility level in Oracle EBS R12
Script to get Profile Option Values at Responsibility level
SELECT frv.responsibility_name,
fpo.profile_option_name,
fpot.user_profile_option_name,
fpov.profile_option_value
FROM fnd_profile_options_tl fpot,
fnd_profile_options fpo,
fnd_profile_option_values fpov,
FND_RESPONSIBILITY_VL frv
WHERE fpot.profile_option_name = fpo.profile_option_name
AND fpo.profile_option_id = fpov.profile_option_id
AND fpov.level_id = ‘10003’
AND fpov.level_value = frv.responsibility_id
–AND frv.responsibility_name = ‘General Ledger Super User’
order by frv.responsibility_name;
What we expect in the script.
This script helps us to set the Profile Option Values at Responsibility level
A couple of tables which is being used in the scripts are fnd_profile_options,fnd_profile_option_values etc
Queries
Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions.
