My Oracle Support Banner

Intermittently MSCPLD Loader Worker With Direct Load Option Errors With APP-FND-01564 ORA-00054 ORA-06512 (Doc ID 1534849.1)

Last updated on JULY 16, 2020

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

In 12.1.3 Memory Based Planner:

Users are running ASCP plan. However, intermittently MSCPLD module: Loader Worker With Direct Load Option fails with the following:

Error string=
Statement with the error:
declare v_sql_stmt VARCHAR2 ( 4000 ) ; lv_partition_name VARCHAR2 ( 30
13255190/msc/lib/mscsld.pc

APP-FND-01564: ORACLE error 54 in
exchange_and_drop_table (MSCSLD)

Cause:
exchange_and_drop_table (MSCSLD) failed due to ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
ORA-06512: at "SYSTEM.AD_DDL", line 165
ORA-06512: at line 1

The SQL statement being executed at the time of the error was: declare v_sql_stmt VARCHAR2 ( 4000 ) ; lv_partition_name VARCHAR2 ( 30 and was executed from the file 13255190/msc/lib/mscsld.pc.

How is this resolved?
 

Solution

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
Goal
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.