Supply Chain Cost Rollup Err CSTPSCCR.remove_rolledup_costs stmt_num= 40:ORA-00001: unique constraint (BOM.CST_ITEM_COSTS_U1) violate (Doc ID 2106359.1)

Last updated on APRIL 19, 2017

Applies to:

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

Goal

Need to know if Supply Chain Cost Roll-up program can be run in parallel for a single organization.
i.e a single instance of Supply chain cost roll-up program for the same org by multiple users in parallel.

Submitted multiple instances of Supply Chain Cost Roll-up program for a single org,
the program completed with the below error.

CSTPSCCR.remove_rolledup_costs stmt_num= 40:ORA-00001: unique constraint (BOM.CST_ITEM_COSTS_U1) violate

Got the below error:

MSG-00000: Running for Category 'XXSCM_CST_PGT_BOCR'
MSG-00000: Before CSTPSCEX.supply_chain_rollup 2016/01/28 08:39:30
MSG-00000: After CSTPSCEX.supply_chain_rollup 2016/01/28 08:47:40
MSG-00000: No loop found
MSG-00000: INFO! Alternate Designator cannot be NULL for the specified Cost Type
MSG-00000: CST_LOCK_FAILED_CIC: 8888
REP-1825: Before Report trigger returned FALSE.
 

Solution

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