GP Core : Formula Validation Issue when Interchanging a New Effective Date
(Doc ID 2798067.1)
Last updated on AUGUST 10, 2021
Applies to:PeopleSoft Enterprise HCM Global Payroll Core - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
The Formula validation process does not validate successfully.
For any formula, with two effective dates, if a new Effective Date is interchanged, the validation is removing data for the first effective date for the modified Formula from the following tables:
Steps to reproduce the issue:
1. Navigate to Set Up HCM > Product Related > Global Payroll & Absence Mgmt > Elements > Supporting Elements > Formulas
Open for e.g. the Element REJ FM COND PRC
2. For any formula, with two effective dates for e.g. 1 JAN 2000 and 1 JAN 2020, add a new effective date in between: for e.g. 1 JAN 2019
3. Click on Validate
4. Run the following SQL Statements:
select * from PS_GP_FORMULA_VAR where PIN_NUM= ;
select * from PS_GP_FORMULA_CLUE where PIN_NUM= ;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document