ETL9.2:PSPPYRUN Finishing To Error Status (Doc ID 2362259.1)

Last updated on DECEMBER 19, 2023

Applies to:

Symptoms

On : 9.2 version, TL Integrations

PSPPYRUN finishing to Error status

Greetings - our production payroll is being severely impacted by a payroll calculation failure. We run the process PSPPYRUN, and it finishes to an error status. The error log has the following:

Checking PaySheet Update for Company: 018
  Pay Group: 18M
  Pay End Date: 2018-02-28
 at 20:01:07.95.
  2 employee(s)/job(s) checked for update.
  2 employee(s)/job(s) had their paysheet updated.
Checking PaySheet Update ended at 20:01:08.04.
 
If Load Time and Labor does not complete, please refer to the
< PROCEDURE TO FOLLOW WHEN LOAD TIME AND LABOR ABENDS >
provided by Peoplesoft.
  Payroll Req Num...: 0000051679
  Process Instance..: 0000432655
 
 
Application Program Failed
 In Pgm Section : GET-PAYABLE-STATUS (FETCH)
 With Return Code: 00001
 Error Message : ORA-00001: unique constraint (SYSADM.PS_PAY_CAL_BAL_ID) violated
 
 
Application Program Failed
 In Pgm Section : REFRESH-TL-PAYSHEETS
 With Return Code: 00001
 Error Message : ORA-00001: unique constraint (SYSADM.PS_PAY_CAL_BAL_ID) violated
 
 
Application Program Failed
 In Pgm Section : START-RUN(PSPSTRUN)
 With Return Code: 00001
 Error Message : ORA-00001: unique constraint (SYSADM.PS_PAY_CAL_BAL_ID) violated
 
Calculation did not finish at 20:01:08.68 !!!!!

The only way we have found to get around this is to change out the pay run ID in the pay calendar for the paygroup that is impacted by this. If we do that, the calculation proceeds normally. We would like to know if there is a way to identify the data that is causing this. A sample trace file will be included.

ERROR
-----------------------
00001




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run PSPPYRUN and it fails with error

Cause

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