My Oracle Support Banner

Error MMT CSTPAVCP.Cost_Processor (87): ORA-00001: unique constraint (INV.MTL_CST_TXN_COST_DETAILS_U1) violated (Doc ID 2431933.1)

Last updated on JULY 13, 2022

Applies to:

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

Symptoms

On : 12.1.3 version, Costing Transaction Errors

There is an error when Cost manager is trying process records from mtl_material_transactions.
The errors occur only for the receiving transaction with serial no. For non serialized items we are not seeing any issue.


ERROR
-----------------------
CSTPACIN.COST_INV_TXN:CSTPAVCP.Cost_Processor (87): ORA-00001: unique constraint (INV.MTL_CST_TXN_COST_DETAILS_U1) violated




STEPS
-----------------------
The issue can be viewed at will with the following steps:
1. Query the MTL_MATERIAL_TRANSACTIONS for transactions with costed_flag - E




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!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.