Stuck Transactions In The MTL_MATERIAL_TRANSACTIONS_TEMP Table For A Cancelled Sales Order (Doc ID 234973.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Inventory Management - Version 11.5.7 to 11.5.10.CU2 [Release 11.5 to 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 14-Aug-2014***

Symptoms

Stuck Transactions In The MTL_MATERIAL_TRANSACTIONS_TEMP Table For A Cancelled Sales Order

Records in the MTL_MATERIAL_TRANSACTIONS_TEMP table have a transaction_status = 2, which is an allocated/untransacted move order

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