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

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'

and frt.language='US'

    ORDER BY 1;

If you like please follow and comment