Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Query to get users deleted roles
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
Tagged:
2