Errored Transactions in MTL_MATERIAL_TRANSACTIONS INV_NO_UPDATE / CST_INVALID_WIP (Doc ID 1080033.6)

Last updated on OCTOBER 26, 2023

Applies to:

Oracle Enterprise Asset Management - Version 11.5.10.2 and later
Oracle Cost Management - Version 11.5.10.2 and later
Oracle Work in Process - Version 11.5.10.2 and later
Oracle Inventory Management - Version 11.5.10.CU2 and later
Information in this document applies to any platform.
CST_INVALID_WIP
CST_NO_BALANCE_ROW
Record not found in WIP_PERIOD_BALANCES

Symptoms

This document provides the detailed instructions for fixing transactions that exist in the Material Transactions (MTL_MATERIAL_TRANSACTIONS.MMT) with error CST_INVALID_WIP. You cannot close the period due to error transactions in the MTL_MATERIAL_TRANSACTIONS (MMT) table. In the worker log, you may get a generic message that reads as follows:

This document will also show all the available information regarding the Root Cause of this data corruption.

Please use this document in the following order:

A. Identification Scripts: This will confirm if you are having this data corruption.
B. Verifying your file versions: This will allow you and Support to confirm if you are already using a known fixed version.
C. Root Cause Analysis. It shows all the relevant information about this issue Root Cause.
D. Datafix Instructions. It will provide steps for fixing the data corruption.