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.
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms