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:

Symptoms

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.

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


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

Cause

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