Your UX is waiting ...interact, engage, explore in Las Vegas at CloudWorld 2023

Learn more
User Role Membership Report SQL Query / Tables — Cloud Customer Connect
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

User Role Membership Report SQL Query / Tables

Accepted answer
168
Views
8
Comments
in Reporting and Analytics for HCM 8 comments

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):


Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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