EPY: Paycheck Modeler Errors Upon Hitting The "previous" Buttons And Re-calculating Modeled Check. (Doc ID 2241383.1)

Last updated on NOVEMBER 23, 2019

Applies to:

Symptoms

ENVIRONMENT
--------------------
HCM 9.2 , 8.55
Image 21

Paycheck modeler calculates the modeled check successfully. However,  upon hitting the "previous" buttons and re-calculating modeled check, the following error is produced:


ERROR
-----------------------
"A fatal PeopleCode SQL error occurred. Please consult your system log for details. " and "SQL error in Exec. (2,280) PY_MOD_DERIVED.EMPLID.FieldFormula Name:ModifyEarnings PCPC:120655 Statement:812
Called from:PY_MOD_DERIVED.EMPLID.FieldFormula Name:BuildPaySheet Statement:1122
Called from:PY_MOD_DERIVED.PY_MOD_CALCULATE.FieldChange Statement:26

During the execution of SQL, an error occurred in the Exec subroutine. The preceding message should have described the SQL being executed."


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Calculate the Modeled paycheck through all steps
2. Hit the "previous" button
3. Make changes
4. Hit the "next" button
5. Hit the "Calculate my modeled check"  and see the peoplecode error above is thrown.
6. Upon running an online sql trace  the following can be seen:
"Error Position: 0 Return: 805 - ORA-00001: unique constraint (HRADM.PS_MOD_PAY_EARNING) violated "

Changes

Cause

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