ECC ONT Full Load Is Failing ORA-00054: resource busy and acquire with NOWAIT ORA-06512: at "APPS.OE_ECC_UTIL_PVT" oracle.jdbc.driver.T4CTTIoer11.processError
(Doc ID 2802470.1)
Last updated on AUGUST 26, 2021
Applies to:Oracle Enterprise Command Center Framework - Version 12.2.9 and later
Information in this document applies to any platform.
ECC ONT is failing in PROD
Order management application failing in PROD. One data load is completed successfully another one is failing with error:
There is SQLException while applying load rule for dataset ont-lines for job 409,053. Exception details ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired ORA-06512: at "APPS.OE_ECC_UTIL_PVT", line 1629 ORA-06512: at "APPS.OE_ECC_UTIL_PVT", line 191 ORA-06512: at line 1 oracle.jdbc.driver.T4CTTIoer11.processError
The issue can be reproduced at will with the following steps:
1. Login to Oracle Applications
2. Go to Resp: Order Management HTML UI, standard
2. Navigate: Data Load submission > Enter parameters >
3. Submit and Run the full load
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