ETL9.1: TL Load Abend With Error ORA-00054: Resource Busy And Acquire With NOWAIT.
(Doc ID 1425019.1)
Last updated on JULY 21, 2020
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***
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document