My Oracle Support Banner

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 later
Information in this document applies to any platform.


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:

"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."

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 "





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.