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:
PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 and laterInformation in this document applies to any platform.
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
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
Symptoms |
Changes |
Cause |
Solution |
References |