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 21, 2023

Applies to:

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

This situation can also occur with the following:

• MSC_REGIONS <BR>MSC_ZONE_REGIONS
• MSC_REGION_LOCATIONS
• MSC_ST_REGIONS EXCHANGE
  

Should this occur with any of the above, the solution is the same as MSC_ITEM_SUBSTITUTES described below.

ALSO SEEN
28-JUN 17:14:20 : Specified partition: ZONE_REGIONS__1 on table: MSC_ZONE_REGIONS does not exist
28-JUN 17:14:20 : Please create all the missing partitions
28-JUN 17:14:20 : Create_Temp_Tbl failed

Note: the ZONE_REGIONS__1 ending with __1

• this is the instance partition number
• will be different if using instance partition that is not the default installed partition  -- e.g ZONE_REGIONS__1021 or some other number

--  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"

This setup instance error is NOT covered in this note. 

Cause

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