ODS LOAD FAILS ON EXCHANGE PARTITIONS FOR MSC_SUPPLIES with ORA-14097 (Doc ID 1997640.1)

Last updated on NOVEMBER 23, 2020

Applies to:

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

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