WMS Pending Transactions Stuck In MMTT For Receipt Or Putaway Process (Doc ID 1075083.1)

Last updated on MAY 25, 2017

Applies to:

Oracle Warehouse Management - Version 11.5.10 and later
Information in this document applies to any platform.

Symptoms

Problem

Receiving or Putaway transactions that have already been transacted are still showing in the MTL_MATERIAL_TRANSACTIONS_TEMP table.
All the transactions are related to receiving or putaway.

Steps

The issue can be seen with the following steps:
Inventory management > Transactions > Pending transactions

NOTE: This appears to have been an isolated incident possibly caused by manual update of database tables.

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