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:
Oracle Advanced Supply Chain Planning - Version 12.1 and laterInformation in this document applies to any platform.
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
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
Goal |
Solution |
References |