Users and Responsibilities in Oracle E-Business Suite

Getting to know all Oracle Users and their responsbilities within E-Business Suite? Yes, this will be required during audit purposes and also to keep a track of who has what and whether they should be using that responsibility or not.



select fu.user_name, fu.description,fu.start_date,fu.end_date,
fu.email_address, fr.responsibility_name,  furg.START_DATE, 
furg.END_DATE from fnd_user_resp_groups_direct furg,
fnd_user fu, fnd_responsibility_tl fr
-- where fu.user_name = ‘&user_name’
where furg.user_id = fu.user_id
and furg.responsibility_id = fr.responsibility_id
and fr.language = userenv('LANG')
order by 1