Data Conversion Group 4 Error "ORA-00001: unique constraint (xxxx.PS_EOEP_PRICE_LIST) violated" at Step UPG_EOEP.PrcLst.UpdPrcLs when Upgrading from a Release <= 8.4 SP2 to Release 9.0 (Doc ID 1950842.1)

Last updated on AUGUST 04, 2016

Applies to:

PeopleSoft Enterprise SCM Order Management - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms

The Data Conversion Group 4 is failing with the below error when upgrading from a release >= 8.4 SP2 to a release > 8.4 SP2.

SQL error. Stmt #: 1613 Error Position: 0 Return: 805 - ORA-00001: unique constraint (xxxx.PS_EOEP_PRICE_LIST) violated
Failed SQL stmt:INSERT INTO PS_EOEP_PRICE_LIST (SETID, PRICE_LIST_ID, CURRENCY_CD, PRODUCT_ID, UNIT_OF_MEASURE, START_DT, BREAK_QTY_LOW, BREAK_QTY_HIGH, PW_FREQUENCY, RECURRING_FLG, END_DATE, EFF_STATUS, LIST_PRICE, PRICE_PROTECTED, DTTIME_ADDED, LASTUPDDTTM, LAST_MAINT_OPRID) SELECT ERR.SETID, ERR.PRICE_LIST_ID, ERR.CURRENCY_CD, ERR.PRODUCT_ID, ERR.UNIT_OF_MEASURE, EOEP_START_DT, 0, 9999999999.9999, ERR.PW_FREQUENCY, ERR.RECURRING_FLG, ERR.END_DATE, ERR.EFF_STATUS, ERR.LIST_PRICE, ERR.PRICE_PROTECTED, DATETIME_ADDED, ERR.LASTUPDDTTM, ERR.LAST_MAINT_OPRID FROM PS_EOEP_PRCLST_ERR ERR WHERE ERR.EOEP_START_DT
Message Number: 0
Message Reason: File: e:\pt84933a-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1613 Error Position: 0 Return: 805 - ORA-00001: unique constraint (NJFCFS.PS_EOEP_PRICE_LIST) violated
Failed SQL stmt:INSERT INTO PS_EOEP_PRICE_LIST (SETID, PRICE_LIST_ID, CURRENCY_CD, PRODUCT_ID, UNIT_OF_MEASURE, START_DT, BREAK_QTY_LOW, BREAK_QTY_HIGH, PW_FREQUENCY, RECURRING_FLG, END_DATE, EFF_STATUS, LIST_PRICE, PRICE_PROTECTED, DTTIME_ADDED, LASTUPDDTTM, LAST_MAINT_OPRID) SELECT ERR.SETID, ERR.PRICE_LIST_ID, (200,0)

Process 1 ABENDED at Step UPG_EOEP.PrcLst.UpdPrcLs (SQL) -- RC = 805 (108,524)
Message Set Number: 108
Message Number: 524
Message Reason: Process 1 ABENDED at Step UPG_EOEP.PrcLst.UpdPrcLs (SQL) -- RC = 805 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

 

Changes

 

Cause

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