My Oracle Support Banner

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.

Symptoms

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'

 

Changes

 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

Cause

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
Symptoms
Changes
Cause
Solution


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