Query to get user responsibilities in oracle apps EBS R12. Run it now

Query to show all changes on responsibilities and roles on oracle apps EBS R12,

It show all added or removed responsibilities for all users within range of date.

This query will be helpful for auditing requirement’s purpose or preparing access rights while migrating

to oracle fusion cloud.

SELECT
 fu.user_name userlogin,
 ppf.employee_number employee_number,
 ppf.full_name full_name,
 fr.responsibility_name responsibility_associated,
 to_char(fur.start_date,'dd/mm/yyyy') "Added Date",
 to_char(fur.end_date ,'dd/mm/yyyy') "Removed form user date"
FROM
 apps.fnd_user fu,
 apps.per_all_people_f ppf,
 apps.hr_all_organization_units hou,
 apps.fnd_user_resp_groups_all fur,
 apps.fnd_responsibility_tl fr
WHERE
 ppf.person_id = fu.employee_id
 AND hou.organization_id = ppf.business_group_id
 AND ppf.business_group_id = :P_ORG_ID
 AND ppf.effective_end_date = TO_DATE('31/12/4712', 'DD/MM/RRRR')
 AND fu.user_id = fur.user_id
 -- AND nvl(fur.end_date, sysdate + 1) > sysdate
 -- AND ( fu.end_date IS NULL OR fu.end_date >= trunc(sysdate) )
 AND fur.responsibility_id = fr.responsibility_id
 AND fr.language = 'US'
 AND ( fur.END_date BETWEEN :ED1 AND :ED2 -- Add range of date for ended responsibilities 
 OR fur.START_date BETWEEN :ES1 AND :ES2 -- Add range of date for added responsibilities
ORDER BY
fu.user_name,
 fr.responsibility_name

Read more:

Query to get AR invoice details on Oracle E-business EBS R12, Easy and Fast.

How to get AP invoices in Oracle EBS r12 for Oracle Fusion Data migration FBDI, Simple Query

Query to find all GL transactions on oracle EBS R12, Easy and fast!

How to get all supplier sites and contacts on oracle EBS R12. easy and fast.