ORA-00001: unique constraint (INV.MTL_CST_ACTUAL_COST_DETAILS_U1) violated (Doc ID 290868.1)

Last updated on APRIL 22, 2017

Applies to:

Oracle Cost Management - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

Records with the following Error Message are found in the Material Transactions Form
Navigation: INV: Transactions: Material Transactions: Query erred transactions: Reason Reference Tab:

Or by direct query from the Mtl_Material_Transactions (MMT) table:

Error Message: ORA-00001: unique constraint (INV.MTL_CST_ACTUAL_COST_DETAILS_U1) violated

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