MRCMON - Snapshot Monitor Will Not Complete Due To Locks On Table MTL_MATERIAL_TRANSACTIONS_TEMP (Doc ID 566273.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Materials Requirement Planning - Version 11.5.9 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
EXECUTABLE:MRCMON - Snapshot Monitor

*** Checked for relevance on 23-Apr-2012 ***
***Checked for relevance on 27-Sep-2013***


Goal

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?

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