ERS9.2: Incorrect Changes to Data in in RS_WRKR_EFFDT and RS_WRKR_ELGBL Tables When Effdt of History Row of Job is Changed in HCM (Doc ID 2182139.1)

Last updated on SEPTEMBER 13, 2016

Applies to:

PeopleSoft Enterprise FIN Resource Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When Effdt of the History row of Employee's Job data is changed (in Correct History Mode) in HCM, a new Effdt row is getting added RS_WRKR_EFFDT table and RS_WRKR_ELGBL is getting updated with the new Effdt in FSCM.

Steps:
------------
1) Enable WORKFORCE_SYNC between HCM and FSCM.
2) Open Job Information of an Employee in Correct History Mode in HCM.
3) Change the Effdt of a History row.
4) Save the changes.
5) Check the data in RS_WRKR_EFFDT and RS_WRKR_ELGBL tables in FSCM.

Expected result:
-------------------
There should not be any change.

Actual result:
-----------------
A new Effdt row is getting added RS_WRKR_EFFDT table and RS_WRKR_ELGBL iable is getting updated with the new effdt in FSCM.

Please see replication steps document for more details.

Cause

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