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
Last updated on MARCH 08, 2017
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms