Role Discrepancy in PER_USER_ROLES Table for Terminated Employees — 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

Role Discrepancy in PER_USER_ROLES Table for Terminated Employees

in Human Capital Management 3 comments

Summary:

We observed that for a few terminated employees, roles appear to be assigned in the PER_USER_ROLES table when pulling through the report, even though the frontend interface (Security Console) shows no roles assigned.
Upon further investigation, we found that the start_date and end_date values in the table were interchanged. Specifically, the start_date is set to 4712-12-31, and the end_date is 2024-08-27.

We tried removing these roles again using HDL (template attached below), but these roles were still visible when querying from the backend.

Note: We tried running all the role synchronization related scheduled processes as well but it didn't help.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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