MSRFWOR: WIP_DISCRETE_JOBS, Refresh Collection Snapshots error with ORA-06508: PL/SQL: could not find program unit being called
(Doc ID 1436998.1)
Last updated on APRIL 04, 2025
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.0 and laterInformation in this document applies to any platform.
MSRFWOR
Symptoms
When attempting to run ASCP data collections, Refresh Collection Snapshots and Create XXX Snapshots fails the following error occurs.
ERROR
-----------------------
The following error is seen in the log file:
21-FEB 13:01:35 : Creating Snapshot Log for WIP_DISCRETE_JOBS ...
21-FEB 13:01:35 : ORA-06508: PL/SQL: could not find program unit being called
The following error is seen in the output file:
DECLARE
*
ERROR at line 1:
ORA-20001: Snapshot Log Creation on WIP_DISCRETE_JOBS failed : ORA-06508:
PL/SQL: could not find program unit being called
ORA-06512: at "APPS.MSC_UTIL", line 497
ORA-06512: at line 50
STEPS TO REPRODUCE
-----------------------------------
1. Login to Application.
2. Run Collections. NAV: Advanced Supply Chain Planner (R) -> Collections -> Oracle Systems -> Standard Collection
3. See that the Refresh Collection Snapshot fails.
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 |