ETL9.1: TL Load Abend With Error ORA-00054: Resource Busy And Acquire With NOWAIT.
(Doc ID 1425019.1)
Last updated on JULY 16, 2023
Applies to:
PeopleSoft Enterprise HCM Time and Labor - Version 9.1 to 9.2 [Release 9]Information in this document applies to any platform.
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
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
| Symptoms |
| Cause |
| Solution |