Planning ODS Load fails With "ORA-0000 Specified partition: on table: does not exist" or MSCFINST form gives an ORA-14313 error

(Doc ID 1317027.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

During Standard Data Collections, the Planning ODS Load fails with the following error:

(example)

Specified partition: ITEM_SUBSTITUTES__1 on table: MSC_ITEM_SUBSTITUTES does not exist
Please create all the missing partitions
Create_Temp_Tbl failed
ORA-00000: normal, successful completion

AND/OR

When trying to setup an instance in the MSCFINST (Instances Form), the following error occurs:

(example)

ORA-14313: Value 2021 does not exist in partition ST_CALENDAR_DATES_DEF
ORA-04088: error during execution of trigger "APPS.MSC_APPS_INSTANCES_T1"

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