My Oracle Support Banner

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.

Symptoms

ECC ONT is failing in PROD

Order management application failing in PROD. One data load is completed successfully another one is failing with error:

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



STEPS
-----------------------
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



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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.