EBS active users responsibility report
Hi team,
Each month we check current active users with their active responsibilities by using this query from Oracle database 12.1.0.2.0 :
SELECT
fu.user_name "User name", frt.responsibility_name "Responsibility Name" ,
furg.start_date "Start Date" , fu.end_date "User End Date", furg.end_date "Resp End Date" ,
fu.last_logon_date "Last Logon Date", fr.responsibility_key "Responsibility key",
fu.email_address "Email Address", fu.description "Description"
FROM
fnd_user_resp_groups_direct furg, applsys.fnd_user fu,
applsys.fnd_responsibility_tl frt, applsys.fnd_responsibility fr
WHERE furg.user_id = fu.user_id
AND furg.responsibility_id = frt.responsibility_id