This blog is about to find list of responsibilities which has been assigned for a user .
This script will be very useful to identify the list of responsibilities while migrating and also will usefull to prepare
list's while upgrading ,reimplementation and also very useful to find unauthorized responsibilities of a user.
SELECT fu.user_name,
frt.responsibility_name,
furgd.start_date,
furgd.end_date
FROM fnd_user fu,
fnd_user_resp_groups_direct furgd,
fnd_responsibility_tl frt
WHERE fu.user_id = furgd.user_id
AND furgd.responsibility_id = frt.responsibility_id
AND UPPER (fu.user_name) = UPPER ('USER_NAME')
ORACLE
Let us share our knowledge to the world of oracle apps. I am trying my best to do so and I request every one to contribute their part. If you have any thing useful related to oracle apps, do send me I will post in my blog on behalf of you. If you like my blog tell the world about it, else tell me i will improve. You can suggest me, what exactly you want on oracle apps. Mail your queries.
No comments:
Post a Comment