Script to list profile option values for a specific user

Posted on June 26, 2008. Filed under: DBA/Admin Tips, R12, Scripts | Tags: , |

col profile_option_name for a35
col profile_option_value for a30
col profile_option_id for 9999

set lines 500

select
 p.profile_option_name,
 substr(decode(v.level_id,10001,’Site’,10002,’Application’,
 10003,’Repsonsibiltiy’,10004,’User’,10005,’Server’,10006,’Organisation’),1,15) profile_level,
 substr(fu.user_name,1,12) user_name,
 v.level_value,
 v.profile_option_value
from
 fnd_profile_options p,
 fnd_profile_option_values v,
 fnd_user fu
where
 p.profile_option_id = v.profile_option_id
and  v.level_value = fu.user_id
and fu.user_name like upper(‘&USER_NAME’)
/

Advertisements

Make a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Liked it here?
Why not try sites on the blogroll...

%d bloggers like this: