ISSUE WITH EFFECTIVE DATES IN LIST SETS (GP_ELN_SET) (Doc ID 2052125.1)

Last updated on SEPTEMBER 04, 2015

Applies to:

PeopleSoft Enterprise HCM Global Payroll Core - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : HCM 9 version, MP14 General

1. Add a value with new EFFDT in Define List Set Page (Set Up HRMS -> Product Related -> Global Payroll & Absence Mgmt -> Elements -> Define List Set), It will insert date into tables GP_ELN_SET_ATTR, GP_ELN_SET_LST and GP_ELN_PIN_ATTR with new EFFDT.

2.a Modify the EFFDT to some other value, tables GP_ELN_SET_ATTR, GP_ELN_SET_LST are updated with the new effective date but table GP_ELN_PIN_ATTR will not have data with both old and new EFFDT.

2.b Delete the newly added EFFDT row, it will delete the data from GP_ELN_SET_ATTR, GP_ELN_SET_LST but data will be retained in table GP_ELN_PIN_ATTR.

Data integrity is not maintained as data is being deleted or modified in Parent record - GP_ELN_SET_ATTR, GP_ELN_SET_LST but not getting deleted or modified in child record - GP_ELN_PIN_ATTR

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