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 SEPTEMBER 30, 2023

Applies to:

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

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