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.


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 We are in a distributed environment and we also upgraded our source VCP to

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

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

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


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

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.