Unique Constraint (Bom.Cst_eam_hierarchy_snapshot_u1) Violated Ora-00001

(Doc ID 377956.1)

Last updated on JANUARY 29, 2018

Applies to:

Oracle Complex Maintenance, Repair, & Overhaul - Version 12.0.0 and later
Information in this document applies to any platform.


When attempting to click on Estimate Cost link for a Maintenance Requirement in CMRO Visit page, the following error occurs:

'ORA-00001: unique constraint (BOM.CST_EAM_HIERARCHY_SNAPSHOT_U1) violated in Package AHL_VWP_COST_PVT Procedure Create_Wo_Cost_Structure'

1. (R) Advanced Service Online
2. (N) Planning --> Visit Work Package
3. Select a Visit (in Planning status)
4. Maintenance Requirements (link)
5. Cost/Price
6. Estimate Cost (B)
7. Error occurs


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