ERS 9.2: RS_MEMBER_DATES.END_DATE Not Getting Cleared When Deleting the Termination Record in HCM (Doc ID 2176473.1)

Last updated on AUGUST 29, 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 deleting termination record from from Job Details in HCM, the data is getting synced to FSCM Environment correctly but End Date is not resetting to blank/Null in the Record RS_MEMBER_DATES.  

Steps:
The issue can be reproduced at will with the following steps:
1. Make sure the integration is setup properly between HCM and FSCM environment
2. Terminate an employee in HCM.
     -- Check the data in FSCM environment.
3. As employee wants to stay in the company now delete the termination record from Job Information of employee.
     -- Check the data in FSCM environment.

Actual Result:
After Step2: When a Employee is Terminated in the System with the terminated row is updated in the Job Data in the HCM System then the pool End Date in the RS_MEMBER_DATES is getting updated with the Eff Date -1 of the Job Data.
After Step3: If the Employee Termination row is deleted then the pool End Date in the RS_MEMBER_DATES is not getting deleted.

Expected Result:
If the Employee Termination row is deleted then the pool End Date in the RS_MEMBER_DATES should be reset to blank/null.

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