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:

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

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