ODS Load Completes With Error lv_msg_data MSC_PROJECTS Is Not Partitioned ORA-14006: invalid partition name (Doc ID 1340768.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

Run Standard data Collections.
MSCPDCW module: Planning ODS Load Worker failes with errors:

14-JUL 10:17:29 : Procedure
MSC_CL_OTHER_ODS_LOAD.LOAD_PROJECT started.
14-JUL 10:17:29 :
Procedure DELETE_MSC_TABLE:MSC_PROJECTS started.
14-JUL 10:17:29 : MSC_PROJECTS:
14-JUL 10:17:29 : debug1
14-JUL 10:17:29 : parameters passed to get_partiton_name are
14-JUL 10:17:29 : p_plan_id-1
14-JUL 10:17:29 : p_instance_id1
14-JUL 10:17:29 : p_table_nameMSC_PROJECTS
14-JUL 10:17:29 : lv_is_plan2
14-JUL 10:17:29 : lv_partition_name
14-JUL 10:17:29 : lv_return_statusE
14-JUL 10:17:29 : lv_msg_dataMSC_PROJECTS is not partitioned
14-JUL 10:17:29 : ALTER TABLE MSC_PROJECTS TRUNCATE
PARTITION
14-JUL 10:17:29 : ORA-14006: invalid partition name
14-JUL 10:17:29 : ORA-14006: invalid partition name
14-JUL 10:17:29 : Sending message :-9999999 to monitor.
14-JUL 10:17:29 : Error_Stack...
14-JUL 10:17:29 : ORA-14006: invalid partition name

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms