My Oracle Support Banner

ATP Post Processing Failing in Post Plan Allocation (Doc ID 2920254.1)

Last updated on MARCH 22, 2023

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.6.3 and later
Information in this document applies to any platform.

Symptoms

ATP Post Processing Failing in Post Plan Allocation

This issue occurs after applying one of the listed Cumulative Patches below (based on your release):

12.2.6
Cumulative Patch #24 (Patch 34298827) and Cumulative Patch #25 (Patch 34556440)

12.2.7
Cumulative Patch #22 (Patch 34332881) and Cumulative Patch #23 (Patch 34583256)

12.2.8
Cumulative Patch #17 (Patch 34333061) and Cumulative Patch #18 (Patch 34583341)

12.2.9
Cumulative Patch #12 (Patch 34333097) and Cumulative Patch #13 (Patch 34593424)

12.2.10
Cumulative Patch #8 (Patch 34336086) and Cumulative Patch #9 (Patch 34583466)

12.2.11
Cumulative Patch #3 (Patch 34336751) and Cumulative Patch #4 (Patch 34082334)

 



ERROR
-----------------------
Before alter table msc_alloc_demands
Inside main exception of post_plan_allocation
ORA-14098: index mismatch for tables in ALTER TABLE EXCHANGE PARTITION
Call procedure clean_temp_tables in exception
DROP TABLE MSC_TEMP_ALLOC_DEM_14144
DROP TABLE MSC_TEMP_ALLOC_SUP_14144
After procedure clean_temp_tables in exception
LOAD_PLAN_SD: Post plan allocation failed. Will exit




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigation: Advanced Supply Chain Planner > Supply Chain Plan > Launch


 

Changes

 

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
Changes
Cause
Solution
References


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