Get Started with Redwood for Oracle Cloud HCM Begin Now
For more information, please refer to this announcement explaining best practices for getting answers to questions.
How to report on details held in Past Incumbents section of Position Details
Summary:
We need to add some of the fields held in 'Position Details' into an existing report but cannot find within any tables columns that correspond to the fields visible in the UI.
Content (please ensure you mask any confidential information):
In the UI, the data is visible via Position Details, then clicking on 'show past and future incumbents', then expanding each past incumbent. We can see 'position entry date' and 'position exit date'. It's the latter we want to add to our existing vacancy report. I can see that someone asked a similar question previously on Customer Connect and it was suggested that this data is driven by the incumbent's assignment, however there is no corresponding 'position exit date' column in the per_all_assignments_m table. Can someone please help? Surely if the field exists within the UI, there must be a