After Applying VCP 12.1.3.9 or VCP 12.1.3.9.1 Patching MSRFWOR - Refresh Collection Snapshots Performance /Hangs And Will Not Complete (Doc ID 1591417.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3.9 and later
Information in this document applies to any platform.
MSRFWOR

Symptoms

Refresh Collection Snapshots with refresh mode of Complete has been running for over 48 hours without completing..

Trace files shows
-----------------------
BEGIN MRP_CL_REFRESH_SNAPSHOT.REFRESH_SNAPSHOT(:errbuf,:rc,:A0,:A1,:A2,:A3);
  END;

call    count  cpu      elapsed    disk       query      current    rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse   1          0.01       0.00          0          0          0          0
Execute 1          0.34 1830.68            84       6304          6          0
Fetch   0          0.00       0.00          0          0          0          0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total   2          0.35 1830.68            84       6304          6          0



The following SQL was used to locate the request's temporary log file:

The above SQL allowed the DBA to locate the temporary log file for the Refresh Collection Snapshots request.

The contents looked like:

04-SEP 11:23:20 : The beginning of Refresh Snapshot
04-SEP 11:23:20 : Standalone RCS - no instance details
04-SEP 11:23:20 : Waiting for all other runs to finish

If your temporary log file contains these messages, then the solution delivered in the patch below will resolve the issue.

STEPS
1. Run Refresh Collection Snapshots

Changes

 Upgrade to  VCP 12.1.3.9 <Patch.16974659> or <Patch 17350769> - VCP 12.1.3.9.1 PATCH

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