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 FEBRUARY 10, 2017

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

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