My Oracle Support Banner

After Upgrade MSCPDP: Planning Data Pull fails with ORA-04062: timestamp of package "APPS.MRP_CL_REFRESH_SNAPSHOT" has been changed (Doc ID 2058803.1)

Last updated on NOVEMBER 08, 2018

Applies to:

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

Symptoms

On : 12.2.4 version, Data Collections

Collections Failed After Upgrade

We just upgraded our planning from 12.1.3 to 12.2.4 and took VCP to 12.2.4.1. We are in a distributed environment and we also upgraded our source VCP to 12.1.3.9.1.

We are running our first collection after the upgrade and Planning Data Pull is getting the below errors:

ERROR
-----------------------
MSCPDP: Planning Data Pull

21-SEP 12:49:33 : Collections method: Complete
21-SEP 12:49:33 : Refresh Snapshot process started.
21-SEP 12:49:33 : Application id: 724
21-SEP 12:49:34 : ORA-04062: timestamp of package "APPS.MRP_CL_REFRESH_SNAPSHOT" has been changed
21-SEP 12:49:34 : Error_Stack...
21-SEP 12:49:34 : ORA-04062: timestamp of package "APPS.MRP_CL_REFRESH_SNAPSHOT" has been changed

21-SEP 12:49:34 : Error_Backtrace...
21-SEP 12:49:34 : ORA-06512: at line 1
ORA-06512: at "APPS.MSC_CL_PULL", line 723
ORA-06512: at "APPS.MSC_CL_PULL", line 2836

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade EBS instance to VCP 12.1.3.9.1 Patch 17350769 and VCP instance to 12.2.4.1
2. Run Collections for the first time
3. Get an ORA-04062 error in Planning Data Pull



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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.