List Reponsibilities for an user
Posted by
Jiltin 12 March, 2008 376 views
- Oracle Applications – Find responsibilities associated with the users – using sql
- How To Add Responsibility to USER using pl/sql? – Oracle Applications
- Profile option check – Initialization SQL Statement – Oracle
- List the responsibilities that can run a given concurrent program
- Oracle Applications : How To Setup a Collections User Account?
I often get this issue to find out list of responsibilities assigned to an user, mainly to review the SOX controls or to enable new responsibilities.
Lazy enough to go to System Administrator screen to query it. I always keep the TOAD open session and it is easy to grab the details using this sql.
————————————————————————-
— Author : Jay Gopal
————————————————————————-
SELECT fu.user_name,frt.RESPONSIBILITY_NAME, fu.user_id,furg.responsibility_id
FROM
fnd_user_resp_groups furg,
FND_RESPONSIBILITY fr,
fnd_responsibility_tl frt,
fnd_user fu
WHERE fu.user_name =upper( ‘&username’)
AND fu.user_id = furg.user_id
AND furg.responsibility_id = fr.RESPONSIBILITY_ID
AND frt.responsibility_id = fr.RESPONSIBILITY_ID
ORDER BY 1
— Author : Jay Gopal
————————————————————————-
SELECT fu.user_name,frt.RESPONSIBILITY_NAME, fu.user_id,furg.responsibility_id
FROM
fnd_user_resp_groups furg,
FND_RESPONSIBILITY fr,
fnd_responsibility_tl frt,
fnd_user fu
WHERE fu.user_name =upper( ‘&username’)
AND fu.user_id = furg.user_id
AND furg.responsibility_id = fr.RESPONSIBILITY_ID
AND frt.responsibility_id = fr.RESPONSIBILITY_ID
ORDER BY 1
Categories :
11i Scripts, Oracle AOL

Hi, good post. I have been wondering about this issue,so thanks for posting. I’ll definitely be coming back