My Oracle Support Banner

Planning ODS Load Is Failing After VCP 12.1.3.9.2 Upgrade (Doc ID 2446052.1)

Last updated on SEPTEMBER 11, 2019

Applies to:

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

Symptoms

On : 12.1.3.9.2 version, Data Collections

Planning ODS Load is failing after VCP 12.1.3.9.2 upgrade 


VCP Data Collections taking much time and Planning ODS Load is failing after timeout with following ORA message in the log file.

This started appearing during SIT Testing after 12.1.3.9.2 upgrade with one off patch 27245675:R12.MSC.B for 12.1.3.9.2 environment 


ERROR
-----------------------
Planning ODS Load:
18-APR 12:05:54 : User-Defined Exception
18-APR 12:05:54 : Alter table: ALTER TABLE MSC.DELIVERY_DETAILS_R12 LOGGING
18-APR 12:05:54 : exchange part:-ALTER TABLE MSC_ST_DELIVERY_DETAILS EXCHANGE PARTITION DELIVERY_DETAILS_2247 WITH TABLE DELIVERY_DETAILS_R12 WITHOUT VALIDATION
18-APR 12:05:54 : Alter table: ALTER TABLE MSC.REGION_LOCATIONS_R12 LOGGING
18-APR 12:05:54 : exchange part:-ALTER TABLE MSC_ST_REGION_LOCATIONS EXCHANGE PARTITION REGION_LOCATIONS_2247 WITH TABLE REGION_LOCATIONS_R12 WITHOUT VALIDATION

Planning ODS Load Worker:
18-APR 18:28:57 : IS_MONITOR_STATUS_RUNNING
18-APR 18:28:57 : Concurrent Message : Timeout error.
18-APR 18:28:57 : There is an Unknown Error in the Worker.
18-APR 18:28:57 : Planning ODS Load process failed.


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


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