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

 10003,’Repsonsibiltiy’,10004,’User’,10005,’Server’,10006,’Organisation’),1,15) profile_level,
 substr(fu.user_name,1,12) user_name,
 fnd_profile_options p,
 fnd_profile_option_values v,
 fnd_user fu
 p.profile_option_id = v.profile_option_id
and  v.level_value = fu.user_id
and fu.user_name like upper(‘&USER_NAME’)


Make a Comment

Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

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

%d bloggers like this: