My Oracle Support Banner

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 MAY 03, 2019

Applies to:

Oracle Cost Management - Version 12.0.0 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

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
Goal
Solution


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