My Oracle Support Banner

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 FEBRUARY 14, 2024

Applies to:

Oracle Process Manufacturing Process Execution - Version 12.2 and later
Information in this document applies to any platform.

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

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
Purpose
Troubleshooting Steps
References

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