My Oracle Support Banner

PLANNING ODS LOAD FAILED WITH SPECIFIED PARTITION: SALES_ORDERS__1 ERR (Doc ID 2429360.1)

Last updated on FEBRUARY 25, 2019

Applies to:

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

Symptoms

Problem Statement
In new test instance upgraded 11.5.10.2 to 12.2.6, the Planning ODS Load failed with following error when run collection with

Error
07-JUN 20:05:48 : Specified partition: SALES_ORDERS__1 on table: MSC_SALES_ORDERS does not exist
07-JUN 20:05:48 : Please create all the missing partitions
07-JUN 20:05:48 : Create_Temp_Tbl failed
07-JUN 20:05:48 :
07-JUN 20:05:48 : ORA-0000: normal, successful completion

 

Steps to Reproduce

  1. Run Standard collection

Changes

 The instance was upgraded 11.5.10.2 to 12.2.6

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.