My Oracle Support Banner

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

Last updated on OCTOBER 02, 2018

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 and later
Information in this document applies to any platform.

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

To view full details, 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 a vibrant support community of peers and Oracle experts.