My Oracle Support Banner

Refresh Collection Snapshot In Automatic Mode Error Out With ORA-00054 (Doc ID 2257382.1)

Last updated on MAY 30, 2023

Applies to:

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


In Any version

Refresh Collection Snapshot in Automatic Mode error out with ORA-00054

This can happen for Any MLOG for the 50+ Snapshots

Example error from the log file
The number of rows in Snapshot log: MLOG$_MTL_ONHAND_QUANTITIE = 22775
The number of rows in Snapshot: MTL_OH_QTYS_SN = 45222
Error while truncating Snapshot Log : MLOG$_MTL_ONHAND_QUANTITIE
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
User-Defined Exception


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.