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.
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:
Statement with the error:
declare v_sql_stmt VARCHAR2 ( 4000 ) ; lv_partition_name VARCHAR2 ( 30
APP-FND-01564: ORACLE error 54 in
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?
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