ODS LOAD FAILS ON EXCHANGE PARTITIONS FOR MSC_SUPPLIES with ORA-14097
(Doc ID 1997640.1)
Last updated on NOVEMBER 23, 2020
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.2.4 and laterInformation in this document applies to any platform.
Symptoms
Planning Data Collection Failing at ODS load stage.
In MSCPDC: Planning ODS Load it appears the error:
01-APR 09:17:58 : exchange part:-ALTER TABLE MSC_SUPPLIES EXCHANGE PARTITION SUPPLIES__2021 WITH TABLE SUPPLIES_E5X INCLUDING INDEXES WITHOUT VALIDATION
01-APR 09:17:58 : ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
01-APR 09:17:58 : Fatal Error in Exchange Partition.
In MSCPDCW: Planning ODS Load Worker appear many of:
01-APR 09:15:09 : OTHER========================================
01-APR 09:15:09 : Error in PROCEDURE=LOAD_SUPPLY, TABLE=MSC_SUPPLIES
01-APR 09:15:09 : COLUMN=MSC_CL_ITEM_ODS_LOAD.ITEM_NAME, VALUE=200131C-13
01-APR 09:15:09 : COLUMN=ORGANIZATION_CODE, VALUE=E5X:CMI
01-APR 09:15:09 : COLUMN=ORDER_TYPE, VALUE=Purchase order
01-APR 09:15:09 : ORA-00904: "ALTERNATE_ROUTING_DESIGNATOR": invalid
identifier
01-APR 09:15:09 : OTHER========================================
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Standard Data Collection in Complete Refresh Mode
Cause
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
Symptoms |
Cause |
Solution |
References |