My Oracle Support Banner

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 MARCH 04, 2022

Applies to:

Oracle Inventory Management - Version 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.