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 DECEMBER 06, 2024
Applies to:
Oracle Inventory Management - Version 11.5.10.2 and laterInformation 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
Symptoms
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.
BUSINESS IMPACT
The issue has the following business impact:
Inventory is not available for other transactions.
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 |
AVOIDING THIS ISSUE? |
References |