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 for Oracle Cloud HCM   Begin Now

Is the Revoke User Access field from HCM termination process available in BI Publisher?

Accepted answer
21
Views
2
Comments
edited Mar 20, 2024 6:11PM in Reporting and Analytics for HCM 2 comments

Summary:

The field "Revoke User Access" stores option of revoking user access on Termination. We need to pull it in a BI Publisher report, but we have not been able to find what table it may reside in.

Content (please ensure you mask any confidential information):

We need to pull the field Revoke User Access to a BI Publisher report but we could not find it documentation for Oracle tables and views for HCM 23C.

Overall we were hoping to use this field to capture the event from HCM and use to deactivate the users Active Directory (AD) Account via custom integrations. There was a similar post from 2017 of someone looking for this field in OTBI and response was it was not available and the thread recommended creating a DFF. Ideally we could grab the native field from BI Publisher. In screen shots below I show the screen in Oracle and also a section of an email notification that is sent out referencing the field.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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