After Upgrade from 11i, Error Message Launching Planning Data Pull - ORA-02149: Specified Partition Does Not Exist

(Doc ID 1593250.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

Using Advanced Supply Chain Planning / Standard Data Collection
On 12.2.2 recently upgraded from 11.5.10.2,
When attempting to perform Planning Data Pull,
the following error occurs.

ERROR
-----------------------
ORA-02149: Specified partition does not exist
Error_Backtrace...
ORA-06512: at "APPS.MSC_CL_PURGE_STAGING", line 2014

-- Steps To Reproduce:

Customer states the issue can be reproduced at will at customer site with the following steps:
1. Upgrade VCP destination instance from EBS 11i to EBS 12.2
2. (R) Advanced Supply Chain Planner
3. (N) Collections / Oracle Systems / Standard Collection
4. Inspect the Planning Data Pull log file and observe the noted error.

Changes

 Upgrade from EBS 11.5.10

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms