My Oracle Support Banner

Correct table to report on Candidates Readiness - HRM_PLAN_CANDIDATES (Doc ID 2772978.1)

Last updated on SEPTEMBER 18, 2023

Applies to:

Oracle Fusion Succession Management Cloud Service - Version and later
Information in this document applies to any platform.


On : 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.