Oracle Applications - Query to list all the responsibilities assigned to a user
SELECT DISTINCT
fu.user_name, frtl.RESPONSIBILITY_NAME
FROM fnd_responsibility fr
, fnd_responsibility_TL frtl
, fnd_user_resp_groups furg
, fnd_user fu
WHERE furg.responsibility_id = fr.responsibility_id
AND frtl.responsibility_id = fr.responsibility_id
and fr.APPLICATION_ID=furg.RESPONSIBILITY_APPLICATION_ID
AND fu.user_id = furg.user_id
AND fu.user_name = '12345' -- username here
order by fu.user_name
Wow. This query is very useful for a database administrator to know all the responsibilities that are assigned to a user. The query is explained very well in the above post and one can easily understand all the parameters and options that are passed to the query. Thanks for sharing it.
ReplyDeleteupgrade sap 6.0