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 MARCH 26, 2019
Applies to:Oracle Advanced Supply Chain Planning - Version 12.1.1 and later
Information in this document applies to any platform.
During Standard Data Collections, the Planning ODS Load fails with the following error:
Specified partition: ITEM_SUBSTITUTES__1 on table: MSC_ITEM_SUBSTITUTES does not exist
Please create all the missing partitions
ORA-00000: normal, successful completion
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:
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"
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