My Oracle Support Banner

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

Last updated on JANUARY 30, 2022

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.

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

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.