My Oracle Support Banner

ATP Data Collection Failing After Upgrade To R12.2.4 OR Higher With Error - MSC_ZONE_REGIONS does not exist (Doc ID 2071795.1)

Last updated on JANUARY 25, 2022

Applies to:

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

Symptoms

12.2.4.1 and also on 12.2.5 after upgrade from 11i


PROBLEM
-------------
 ATP Data Collection failing after upgrade to R12.2.4

24-AUG 18:08:08 : <>
24-AUG 18:08:08 : Specified partition: ZONE_REGIONS__21 on table: MSC_ZONE_REGIONS does not exist
24-AUG 18:08:08 : Please create all the missing partitions
24-AUG 18:08:08 : Create_Temp_Tbl failed
24-AUG 18:08:08 :
24-AUG 18:08:08 : ORA-0000: normal, successful completion

STEPS
--------
Order Management Super User -> Scheduling -> ATP data collection

BUSINESS IMPACT
----------------------
Cannot collect ATP data.

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.