My Oracle Support Banner

Collection Snapshots errors with ORA-04021: timeout occurred while waiting to lock object (Doc ID 2431090.1)

Last updated on APRIL 03, 2021

Applies to:

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

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

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
Symptoms
Changes
Cause
Solution


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