You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

User Role Membership Report SQL Query / Tables

Summary:

Hi Team, for audit purposes customer is requesting to know which tables/views at db level are being used to extract the seeded report "User Role Membership Report", is possible for you to share the sql query behind this report or at least table/views names?

Content (required):

Are these the views?

ASE_USER_VL

ASE_USER_ROLE_MBR

ase_role_b 

Version (include the version you are using, if applicable):

23B

Code Snippet (add any code snippets that support your topic, if applicable):


Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!