Stuck Pending Move Order Transactions (MTL_MATERIAL_TRANSACTIONS_TEMP MMTT) / Available Shows Zero Because Records Are Stuck In MMTT, Move Order Cancelled By Source in Transact Move Order (INVTOTRX) Form
(Doc ID 396523.1)
Last updated on JULY 08, 2020
Applies to:Oracle Inventory Management - Version 22.214.171.124 and later
Information in this document applies to any platform.
FORM: INVTOTRX.FMB - Transact Move Orders
FORM: INVTVTMP.FMB - View Pending Transactions
This document includes all versions of 11i and Release 12
Find pending transactions related to a cancelled sales order in the pending transaction table (MTL_MATERIAL_TRANSACTIONS_TEMP).
STEPS #1: See zero available quantity
Cannot reproduce the issue but see the zero available quantity as follows:
1. Goto Inventory > Item Supply/Demand
2. Query the item
3. See On-Hand 1
4. See Available quantity=0.
STEPS #2: See pending transactions
Cannot reproduce the issue but see pending transactions as follows:
1. Goto Inventory > Transactions > Pending Transactions
2. The find window appears
3. Enter the query criteria.
4. Press Find.
5. The transactions appear showing the error.
The issue has the following business impact:
Inventory is not available for other transactions.
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
|AVOIDING THIS ISSUE?|