OPM Cost Update Error

OPM COST UPDATE ERROR 

Error number: -127

Error ORA-00001: unique constraint (GMF.GL_ITEM_DTL_PK) violated

Function: cmcuput_gl_item_dtl_insert

Cause

Running this script

select * from all_ind_columns
where table_name='GL_ITEM_DTL'
order by index_name,column_position

revealed that the constraint GL_ITEM_DTL_PK had only 3 columns i.e. ITEMCOST_ID, COST_CMPNTCLS_ID, COST_ANALYSIS_CODE.

Solution

1. Drop the constraint

drop index GMF.GL_ITEM_DTL_PK;

2. Recreate it as follows

create unique index GMF.GL_ITEM_DTL_PK on GMF.GL_ITEM_DTL (ITEMCOST_ID, COST_CMPNTCLS_ID, COST_ANALYSIS_CODE,COST_LEVEL);

This Should Complete the cost processor successfully