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 FEBRUARY 07, 2022

Applies to:

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

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