My Oracle Support Banner

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 JANUARY 30, 2022

Applies to:

PeopleSoft Enterprise SCM Inventory - Version 8 SP1 to 9.2 [Release 8 to 9]
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.


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)



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

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