My Oracle Support Banner

ORA-06512: At "SYSTEM.AD_DDL", MSCSLD : Error In Main 105 : Table_name_str MSC_ITEM_SOURCING 2001 OR ORA-14501 Error In Snapshot Delete Worker (Doc ID 2483280.1)

Last updated on NOVEMBER 16, 2020

Applies to:

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

Symptoms

Symptom #1  - When attempting to run a plan, the following error occurs in the Loader Worker

ERROR
-----------------------
Error string=
Statement with the error:
declare v_sql_stmt VARCHAR2 ( 4000 ) ; lv_partition_name VARCHAR2 ( 30

APP-FND-01564: ORACLE error 14501 in
exchange_and_drop_table (MSCSLD)
Cause:
exchange_and_drop_table (MSCSLD) failed due to ORA-14501: object is not partitioned
ORA-06512: at "SYSTEM.AD_DDL", line 210
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 .

Symptom #2 - Snapshot Delete worker fails with error

Failed attempt to lock : LOCK TABLE MSC_ITEM_SOURCING PARTITION (ITEM_SOURCING_10001) IN EXCLUSIVE MODE NOWAIT
ORA-14501: object is not partitioned

-14501
Unable to obtain a lock on table MSC_ITEM_SOURCING


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the plan


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.