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 and later
Information in this document applies to any platform.


12.2.6 OR Any 12.2.x customer who has applied - Patch 21841299

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 ?

Set MSC: Source Setup Required = Yes
Launch collection




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