Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Content Items on Talent Profile - Historical View — 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

Content Items on Talent Profile - Historical View

Received Response
15
Views
1
Comments
edited Aug 10, 2021 5:27PM in Career and Succession 1 comment

Content

Hello Experts,

Based on my research, it appears that content items captured on a worker's Talent Profile are not date-effective in the typical sense. For example: if I make a change to a content item on a worker's Talent Profile and change the value for a single field (e.g., expiry date for a License), a separate row does not get created in the HRT_PROFILE_ITEMS table. Instead, the values for the row simply get updated with the latest data, along with the latest OBJECT_VERSION_NUMBER (e.g., changing from '1' to '2'). 

My question: is there any way to track historical changes for content items on a worker's talent profile? I was thinking perhaps we could enable the audit policy for the "Person Profile Items" object and then query the respective audit tables, such as those ending with _ (e.g., HRT_PROFILE_ITEMS_). Has anyone attempted this approach, or have another clever way to get at the historical rows here? 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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