My Oracle Support Banner

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


On : version, Data Collections

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

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

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