Thursday, 24 January 2019

Query to List All User Roles in EBS as it shows in Application

The following query list all the Roles and responsibilities as they appears in the Application security screen

SELECT DISTINCT UR.USER_NAME, WR.DISPLAY_NAME, WR.description
  FROM APPLSYS.wf_user_role_assignments ur, apps.WF_ROLES wr
 WHERE     1 = 1
       AND ROLE_ORIG_SYSTEM IN ('FND_RESP', 'UMX')
       AND wr.name = ur.role_name
       AND ur.user_name LIKE '<USER_NAME>%';

No comments:

Post a Comment