ETL9.1: TL Load Abend With Error ORA-00054: Resource Busy And Acquire With NOWAIT. (Doc ID 1425019.1)

Last updated on MAY 12, 2017

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.
*** Checked for relevance on 21-Mar-2012 ***
***Checked for relevance on 20-Jun-2014***


Symptoms

TL Load abended with following error
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

Application Program Failed
Action Type : SQL UPDATE
In Pgm Section : SQLRT: EXECUTE-STMT
With Return Code: 00054
Error Message : ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
Stored Stmt : PSPLDTL2_U_TRUNC
SQL Statement : TRUNCATE TABLE SYSADM.PS_PY_PYBL_TM_WRK

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