MRCMON - Snapshot Monitor Will Not Complete Due To Locks On Table MTL_MATERIAL_TRANSACTIONS_TEMP
(Doc ID 566273.1)
Last updated on MAY 05, 2021
Applies to:Oracle Materials Requirement Planning - Version 11.5.9 and later
Information in this document applies to any platform.
EXECUTABLE:MRCMON - Snapshot Monitor
When users schedule MPS/MRP plan runs they are getting table locks on MTL_MATERIAL_TRANSACTIONS_TEMP showing in the MRCMON - Snapshot Monitor log file and the concurrent request will not complete. The log file shows the following information or similar:
APP-MRP-22050 Table mtl_material_transaction_temp is locked
APP-MRP-22065 snapshot unable to lock mtl_material_transaction_temp
It's also possible the errors will not show but another indication of the problem are literally hundreds of lines in the log file like the following:
MTL_MATERIAL_TRANSACTIONS_TEMP locked on 23-ABR-2008 23:38:15
How do we fix this problem?
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