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 FEBRUARY 16, 2017

Applies to:

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

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

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