Planning Data Pull Fails with Errors ORA-04062: timestamp of package "APPS.MRP_CL_REFRESH_SNAPSHOT" has been changed - OR Same Error For APPS.MRP_CL_FUNCTION (Doc ID 2715075.1)

Last updated on SEPTEMBER 04, 2024

Applies to:

Goal

After Edition cleanup Data Pull failed and Log shows -

ORA-04062: timestamp of package "APPS.MRP_CL_REFRESH_SNAPSHOT" has been changed

AND/OR

ORA-04062: timestamp of package "APPS.MRP_CL_FUNCTION"

Example from log

MSCPDPW: Planning Data Pull Worker
+---------------------------------------------------------------------------+

Current system time is 28-SEP-2020 06:15:28

+---------------------------------------------------------------------------+

[28-SEP-2020 06:15:28]: **Starts**
[28-SEP-2020 06:15:28]: **Ends**
Planning Data Pull process failed.
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
28-SEP 06:15:28 : Initialized the Pipes for IPC
28-SEP 06:15:28 : ORA-04062: timestamp of package "APPS.MRP_CL_FUNCTION" has been changed
28-SEP 06:15:28 : Schema : APPS
28-SEP 06:15:28 : RAC_ENABLED value 2
28-SEP 06:15:28 : Send Pipe :MSC_CL_PULL_WM1
28-SEP 06:15:28 : sucess_flag :0
28-SEP 06:15:28 : Message :-9999999
28-SEP 06:15:28 : Send Pipe :MSC_CL_PULL_ST1
28-SEP 06:15:28 : sucess_flag :0
28-SEP 06:15:28 : Message :1
28-SEP 06:15:28 : Error_Stack...
28-SEP 06:15:28 : ORA-04062: timestamp of package "APPS.MRP_CL_FUNCTION" has been changed

28-SEP 06:15:28 : Error_Backtrace...
28-SEP 06:15:28 : ORA-06512: at line 1
ORA-06512: at "APPS.MSC_CL_PULL", line 615
ORA-06512: at "APPS.MSC_CL_PULL", line 1503

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.