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:

Purpose

 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.

Troubleshooting Steps

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.