Triggers and Procedure to Try to Find the Root Cause of Transactions for OPM Batches Getting Stuck in the Transaction Interface table, mtl_transactions_interface (MTI) or the Pending Transactions table, mtl_material_transactions_temp (MMTT)
(Doc ID 2915485.1)
Last updated on DECEMBER 13, 2022
Applies to:Oracle Process Manufacturing Process Execution - Version 12.2 and later
Information in this document applies to any platform.
Transactions for OPM batches sometimes get stuck in either the Transaction Interface table, mtl_transactions_interface (MTI) or the Pending Transactions table, mtl_material_transactions_temp (MMTT). So far, no one has been able to find a pattern as to when this occurs or how to reproduce it, which makes it difficult to find the root cause and fix the issue. This note provides two triggers from Development which customers can apply to capture some data when this occurs, as well as instructions for generating debug information about the stuck transactions.
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