Correct table to report on Candidates Readiness - HRM_PLAN_CANDIDATES
(Doc ID 2772978.1)
Last updated on APRIL 30, 2021
Applies to:Oracle Fusion Succession Management Cloud Service - Version 11.13.21.01.0 and later
Information in this document applies to any platform.
On : 11.13.21.01.0 version, Succession Planning
1. A candidate is added in a succession plan with readiness with Readiness = 1-3 years - new record is created in table HRT_PROFILE_ITEMS and table HRM_PLAN_CANDIDATES
2. A candidate is added in a succession plan with readiness with Readiness = 1-3 years and then Readiness is changed to 3-5 years- record is updated in both tables HRT_PROFILE_ITEMS and HRM_PLAN_CANDIDATES
3. A candidate is added in a succession plan with readiness with Readiness = 3-5 years -new record is created only in HRM_PLAN_CANDIDATES and no record in HRT_PROFILE_ITEMS
Query used to interogate table HRT_PROFILE_ITEMS : select * from hrt_profile_items where profile_id in (select profile_id from hrt_profiles_b where person_id='xxxxxxxxxxxxxxx'
Current set-up of Readiness Values:
Lookup Code : Ready now , Meaning: Ready Now
Lookup Code :XXYY_2-3 , Meaning : 1-3 years
Lookup Code: NO_Readiness, Meaning : 3-5 years
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document