Cstpacin.Cost_inv_txn:Unexpected Error In Cst_revenuecogsmatch_pvt . Insert_onesoissue ( 40 ) (Doc ID 1304185.1)

Last updated on MARCH 15, 2017

Applies to:

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

Symptoms

On : 12.1.1 version,

Customer has one transaction in error:

Log file shows the following :

-----------------------
CMCACW module: Actual Cost Worker
+---------------------------------------------------------------------------+

Current system time is 14-MAR-2011 09:22:43

+---------------------------------------------------------------------------+

debug_level = 0
CM_EXTENDED_DEBUG = 2
pd_txfr_ind = 0
After select into - parent_txn_id = 0.000000
CSTPACIN.COST_INV_TXN:Unexpected error in CST_RevenueCogsMatch_PVT . Insert_OneSoIssue ( 40 )
Failing Transaction ID is 89699418.000000
DS - Exit while loop.
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Posting elemental inv accounts
In Inventory_accounts
In insert accounts
l_ussgl_tc :
OTHERS EXCEPTION IN Insert_OneSoIssue:ORA-01422: exact fetch returns more than requested number of rows
ORA-00001: unique constraint (BOM.CST_REV_COGS_MATCH_LINES_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