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

Last updated on MAY 03, 2017

Applies to:

PeopleSoft Enterprise HCM Payroll for North America - Version 9.2 and later
Information 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 "

  

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms