Oracle Sql to get Profile Option Values at Responsibility level

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.