[Oracle EBS] Query to list Active Responsibilities assigned to Active User

Kadang-kadang kita kesulitan untuk mengelola user yang ada di Oracle EBS. Untuk mempermudah dalam melakukan audit user dan responsibility yang ada di oracle EBS kita bisa menggunakan query berikut ini untuk memunculkan user-user dan responsibility yang aktif.

SELECT fu.user_name, frv.responsibility_name,
TO_CHAR (furgd.start_date, 'DD-MON-RRRR') "START_DATE",
TO_CHAR (furgd.end_date, 'DD-MON-RRRR') "END_DATE"
FROM fnd_user fu,
fnd_user_resp_groups_direct furgd,
fnd_responsibility_vl frv
WHERE fu.user_id = furgd.user_id
AND furgd.responsibility_id = frv.responsibility_id
AND furgd.end_date IS NULL
--AND fu.user_name = '&user_name'
AND furgd.start_date <= SYSDATE AND NVL (furgd.end_date, SYSDATE + 1) > SYSDATE
AND fu.start_date <= SYSDATE AND NVL (fu.end_date, SYSDATE + 1) > SYSDATE
AND frv.start_date <= SYSDATE AND NVL (frv.end_date, SYSDATE + 1) > SYSDATE
order by user_name

Artikel Terkait :