MRP_CL_FUNCTION Collection Views Hang - Library Cache Pin Wait
Last updated on JUNE 28, 2017
Applies to:Oracle Advanced Supply Chain Planning - Version 220.127.116.11 and later
Information in this document applies to any platform.
12.2.6 OR Any 12.2.x customer who has applied R12.AD.delta.8 - 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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms