Query to get users deleted roles — 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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Query to get users deleted roles

edited Feb 13, 2020 11:22AM in Reporting and Analytics for HCM 16 comments

Content

Hi All,

I am trying to fetch details of roles assigned to a user including the one deleted in the past.

In ebiz we only had option to end date a responsibility but in cloud we can delete it (role) also.

When I checked table PER_USER_ROLES I found that it holds only active/current roles. 

I also need to fetch roles which were assigned to user and then deleted, including role assignment date and role deletion date.

May I know which table to use for this?

Thanks - Avinash

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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