How To Resolve the Error "ORA-00001: unique constraint (EMDBO.PS_CM_AVGADJ_COST) violated Statement: INSERT INTO PS_CM_AVGADJ_COST" when Running the 'Cost Accounting Creation' Process (CM_CSTACCTG) (Doc ID 1395677.1)

Last updated on AUGUST 04, 2016

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 8 SP1 and later
PeopleSoft Enterprise SCM Cost Management - Version 8 SP1 and later
PeopleSoft Enterprise SCM Manufacturing - Version 8.4 and later
Information in this document applies to any platform.
***Checked for relevance on 11-Apr-2013***

Goal

How to prevent the 'Cost Accounting Creation' process (CM_CSTACCTG) (navigation: Cost Accounting, Inventory and Mfg Accounting, Create Accounting Entries, Cost Accounting Creation) from failing with the following error:

SQL error. Function:  SQLExec Error Position:  0 Return:  805 - ORA-00001: unique constraint (EMDBO.PS_CM_AVGADJ_COST) violated Statement:  INSERT INTO PS_CM_AVGADJ_COST

Process 13599 ABENDED at Step CM_COSTING.CostAdj.MExpand (PeopleCode)

 

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