MSCPDCW - Planning ODS Loader Worker Fails With Error - ORA-14096: tables in ALTER TABLE EXCHANGE PARTITION must have the same number of columns (Doc ID 2923079.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

MSCPDCW: Planning ODS Load Worker Failed
 

ERROR
-----------------------
09-JAN 22:42:45 : Alter table: ALTER TABLE MSC.REGIONS_TST LOGGING
09-JAN 22:42:45 : exchange part:-ALTER TABLE MSC_ST_REGIONS EXCHANGE PARTITION REGIONS_1 WITH TABLE REGIONS_TST WITHOUT VALIDATION
09-JAN 22:42:45 : ORA-14096: tables in ALTER TABLE EXCHANGE PARTITION must have the same number of columns
09-JAN 22:42:45 : Exchange partition failed
09-JAN 22:42:45 : User-Defined Exception
09-JAN 22:42:45 : User-Defined Exception
09-JAN 22:42:45 : Sending message :
  -9999999 to monitor.

STEPS
NAV: Advanced Supply Chain Planning (R) / Collections / Oracle Systems / Standard Collections
- Launch the request set and check Log file with error

Changes

 Customer has migrated from 12.1.3 to 12.2.6 or higher - then the issue started.

Cause

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