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 MARCH 08, 2017

Applies to:

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

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

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