CMP_CWB_HRCHY And CMP_CWB_PERSON_INFO Are Not In Sync (Doc ID 2201357.1)

Last updated on DECEMBER 12, 2016

Applies to:

Oracle Fusion Workforce Compensation Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Compensation - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal


While selecting a different Primary Worksheet Manager in Administer Employees and saving the changes for an employee, The CMP_CWB_PERSON_INFO record get updated with correct WS_MGR_PERSON_EVENT_ID along with other details whereas the CMP_CWB_HRCHY do not reflect the changes with respect to those MGR_PERSON_EVENT_ID .This shows a mismatch between CMP_CWB_PERSON_INFO & CMP_CWB_HRCHY Tables.


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms