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:

Symptoms

On : 12.2.6.3 version, Data Collections

Collection Snapshots errors ORA-04021: timeout occurred while waiting to lock object

In an upgraded test instance (12.1.3 to 12.2.6.3) 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.


ERROR
-----------------------
ORA-04021: timeout occurred while waiting to lock object


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigation: Advanced Supply Chain Planner > Collections > Oracle Systems > Standard Collections

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.