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 JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 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.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms