Refresh Collection Snapshot In Automatic Mode Error Out With ORA-00054

(Doc ID 2257382.1)

Last updated on JUNE 28, 2017

Applies to:

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

Goal

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
TRUNCATE TABLE INV.MLOG$_MTL_ONHAND_QUANTITIE
Error while truncating Snapshot Log : MLOG$_MTL_ONHAND_QUANTITIE
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
User-Defined Exception
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms