ETL9.2: ORA-00060 Payroll Deadlock Issue. (Doc ID 2163913.1)

Last updated on AUGUST 08, 2016

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When attempting to run the payroll with the delivered pspldtl2.dms,
the following error occurs.

ERROR
-----------------------
Application Program Failed
Action Type : SQL UPDATE
In Pgm Section : SQLRT: EXECUTE-STMT
With Return Code: 00060
Error Message : ORA-00060: deadlock detected while waiting for resource
Stored Stmt : PSPLDTL2_D_WRKPYTM
SQL Statement : DELETE FROM PS_PY_PYBL_TM_WRK WHERE PAYROLL_REQ_NUM <= :1

Application Program Failed
In Pgm Section : DEL-EMPLOYEE-SETS D-WRKPYTM(DELETE)
With Return Code: 00060
Error Message : ORA-00060: deadlock detected while waiting for resource

Application Program Failed
In Pgm Section : PSPLDTL2
With Return Code: 00060
Error Message : ORA-00060: deadlock detected while waiting for resource

 


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run payroll

Due to this issue, the delivered pspldtl2.dms is causing major problem with the payroll processing since once it deadlocks it is difficult to recover from.

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