My Oracle Support Banner

OPM Accounting Pre-processor, OM source, Insert_OneSoIssue:ORA-00001: unique constraint (BOM.CST_COGS_EVENTS_U2) violated (Doc ID 1608929.1)

Last updated on MARCH 01, 2024

Applies to:

Oracle Process Manufacturing Financials - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 or Later, Period Close for Process Orgs

When attempting to run OPM Accounting Preprocessor with Source:OrderManagemnt
the following error occurs.

ERROR
-----------------------
OTHERS EXCEPTION IN Insert_OneSoIssue:ORA-00001: unique constraint (BOM.CST_COGS_EVENTS_U2) violated
PROGRAM_EXCEPTION IN Match_RevenueCOGS at (10):
Unexpected error in CST_RevenueCogsMatch_PVT . Insert_OneSoIssue ( 60 )
Unable to insert the sales order issue transaction into the Revenue / COGS Matching data model.
OM Line ID = &COGS_LINE_ID
MMT Transaction ID = 46682335 (COGS_OM_LINE=4978465)
Unexpected error in CST_RevenueCogsMatch_PVT . Insert_OneSoIssue ( 60 )
Unable to insert the sales order issue transaction into the Revenue / COGS Matching data model.
OM Line ID = &COGS_LINE_ID

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.