MRP_CL_FUNCTION Collection Views Hang - Library Cache Pin Wait (Doc ID 2244977.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

12.2.6 OR Any 12.2.x customer who has applied R12.AD.delta.8 - Patch 21841299

PROBLEM
-------------
In previous time the library cache pin was held 1,5 hours and hanged the refresh-> Then Completed with Error
It was submitted trough the Planning Collection that submits the Refresh Collection Snapshot.
Now we submitted just Refresh Collection Snapshot.
Now Re-creation of objects hanged for 5 minutes but eventually completed in 15 min .

After it completed - have a problem that the All VCP MV re-creating with Fast-Refresh NO.

Definition of those what are created by Refresh Collection having Primary KEY instead of ROWID.
-> so those are NOT Fast refreshable -> causing issues with Net Change performance.

We need to have those re-created with ROWID. Why Oracle's Standard program creates those automatically with Primary Key instead of ROWID ?

STEPS
--------
Set MSC: Source Setup Required = Yes
Launch collection


Changes

 Applied R12.AD.C.delta.8

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