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 11.5.10.2 and laterInformation 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
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
Goal |
Solution |