Friday, September 23, 2022

Query to get list of users having sensitive responsibilities in Oracle Apps R12

 









Test Instance: R12.2.5


Query:


SELECT fu.user_id, fu.user_name, frt.responsibility_name, TO_CHAR(furg.start_date,'DD-MON-YYYY') start_date, furg.end_date FROM fnd_user fu , fnd_user_resp_groups_direct furg , fnd_responsibility_vl frt WHERE fu.user_id = furg.user_id AND frt.responsibility_id = furg.responsibility_id AND frt.application_id = furg.responsibility_application_id AND NVL(furg.end_date,sysdate+1) > sysdate AND NVL(frt.end_date,sysdate +1) > sysdate AND NVL(fu.end_date,sysdate +1) > sysdate AND frt.responsibility_name IN ( 'System Administrator' ,'Application Developer' ,'Application Developer Common Modules' ,'CRM HTML Administration' ,'Functional Administrator' ,'Functional Developer' ,'Knowledge Administrator' ,'Oracle Sales Administrator' ,'Sales Administrator' ,'TeleSales Administration' );

0 Responses to “Query to get list of users having sensitive responsibilities in Oracle Apps R12”

Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.