My Oracle Support Banner

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 later
Information 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


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