My Oracle Support Banner

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.