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 AUGUST 21, 2018

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

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
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.