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
Last updated on FEBRUARY 16, 2017
Applies to:Oracle Inventory Management - Version 188.8.131.52 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.
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