Collection Snapshots errors with ORA-04021: timeout occurred while waiting to lock object
(Doc ID 2431090.1)
Last updated on JULY 21, 2022
Applies to:Oracle Advanced Supply Chain Planning - Version 184.108.40.206 and later
Information in this document applies to any platform.
On : 220.127.116.11 version, Data Collections
Collection Snapshots errors ORA-04021: timeout occurred while waiting to lock object
In an upgraded test instance (12.1.3 to 18.104.22.168) an error is occurring in Refresh Collection Snapshots (DC Processes with Errors). This instance has been running Collections and ASCP with no errors, until a few days ago.
Then when running Data Collections (Planning Data Pull) it completed with a Error - Error Setting Up Source Objects. Thus decided to run Planning Data Collection - Purge Staging Tables, followed by Refresh Collection Snapshots. Upon running Refresh Collection Snapshots in Complete mode there were several errors (attached) related to materialized views being locked or missing.
The error happens in different requests that create the snapshots each time Collections is run. First a BOM table, then an INV, then and OM, and now a WIP request.
ORA-04021: timeout occurred while waiting to lock object
The issue can be reproduced at will with the following steps:
1. Navigation: Advanced Supply Chain Planner > Collections > Oracle Systems > Standard Collections
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document