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.
Symptom #1 - When attempting to run a plan, the following error occurs in the Loader Worker
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) 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
Unable to obtain a lock on table MSC_ITEM_SOURCING
The issue can be reproduced at will with the following steps:
1. Run the plan
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