List Reponsibilities for an user
Posted by
Jiltin 12 March, 2008 1,513 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
Hi, great post. Do you have support script,also for SOX purpose, in order to have all responsibilities and their functions per user ?
Edi,
I did work on SOX user, responsibilities and the functions. However, it has set of sqls and plsql functions and procedures. It is not a simple straight forward sql or plsql, but complex one. If you need specific requirement and scenario, I can share only the portion of it.
Its fantastic..
Thanks a lot for your post