My Oracle Support Banner

Transaction Get Stuck in Transaction Interface Table (mtl_transactions_interface) When Attempting to do a WIP Completion Return on Correct Transactions Screen, and Inventory is no Longer Available (Doc ID 1618981.1)

Last updated on APRIL 05, 2023

Applies to:

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


On : 12.1.3 version, Batches

When attempting to create a WIP Completion Return on Correct Transactions, and the inventory is no longer available to return, the user gets a message 'Transaction Quantity must be less than or equal to available quantity'

When this occurs, the WIP Completion Return transaction gets stuck in MTI, and a corrupt gme_transaction_pairs row is written without the transaction_id2, causing the original transaction to no longer display on View Material Transactions.

'Transaction Quantity must be less than or equal to available quantity'

The issue has the following business impact:
Due to this issue, pending transactions get stuck, available inventory is affected,batch data becomes corrupted.


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

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