Query to find full Access Details for Users in EBS/Oracle Apps

This query can be helpful during audits and other user details-related requirements.

Query:

SELECT
    distinct fu.user_name "User_Name",
    fu.end_date "User_End_Date",
    frt.responsibility_name "Responsibility_Name",
    fat.application_name "Application_Name",
    furg.start_date "Responsibility_Start_Date",
    furg.end_date "Responsibility_End_Date",
    fu.last_update_date "Last Updated Date",
    (SELECT user_name
FROM fnd_user
WHERE user_id = fu.last_updated_by) "Last Update By"
FROM
    fnd_user_resp_groups_direct furg,
    applsys.fnd_user fu,
    applsys.fnd_responsibility_tl frt,
    applsys.fnd_responsibility fr,
    applsys.fnd_application_tl fat,
    applsys.fnd_application fa
WHERE
        furg.user_id = fu.user_id
    AND
        furg.responsibility_id = frt.responsibility_id
    AND
        fr.responsibility_id = frt.responsibility_id
    AND
        fa.application_id = fat.application_id
    AND
        fr.application_id = fat.application_id
        and fat.language='US'
    ORDER BY 1;





If you like please follow and comment