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 JUNE 28, 2017

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

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