FSCM 88to91 Upgrade : UPG_DELIVERY.INIT.ShFrtMsc ABENDED
We are upgrading from FSCM 88 to 91., during initial pass the data conversion App Engine EOUFDATACONV failed with following error:
Process 6289649 ABENDED at Step UPG_DELIVERY.INIT.ShFrtMsc (SQL) -- RC = 805
PSAESRV.18334 (4) [11/30/11 22:59:56](3) File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1617 Error Position: 0 Return: 805 - ORA-00001: unique constraint
(SYSADM.PS_UPGDLV_MP_TAO4) violated
Failed SQL stmt:INSERT INTO PS_UPGDLV_MP_TAO4 (PROCESS_INSTANCE, SOURCE_BUS_UNIT, DEMAND_SOURCE, ORDER_NO, SHIP_ID_EST, SHIP_ID, DEPLETED_FLAG, DUPLICATE_FLG, ORDER_TYPE_CD, FREIGHT_BILL_TYPE, SOURCE_CD, BUSINESS_UNIT, DELIVERY_ID, BASE_CURRENCY, RT_TYPE, RATE_MULT, RATE_DIV, RATE_DATE, CURRENCY_CD, CURRENCY_CD_BASE, SETID_AUTO_NUM, SETID_TRFT, SETID_SRC_CD, SETID_INV_ITEM, BILL_ONLY, DOC_REFNUM, FRT_CHRG_METHOD, EFFDT) SELECT DISTINCT 6289649, M.SOURCE_BUS_UNIT, M.DEMAND_SOURCE, M.ORDER_NO, ' ', M.SHIP_ID, 'Y', 'N', H.ORDER_TYPE_CD, H.FREIGHT_BILL_TYPE, H.SOURCE_CD, M.BUSINESS_UNIT, ' ', B.BASE_CURRENCY, B.CUR_RT_TYPE, 0, 0, H.RATE_DATE, H.CURRENCY_CD, H.CURRENCY_CD_BASE, C.SETID, ' ', ' ', ' ', 'Y', ' ', '02', TO_DATE(TO_CHAR(M.DT_TIMESTAMP,'YYYY-MM-DD'),'YYYY-MM-DD') FROM PS_SHIP_FRT_MISC M JOIN
Process 6289649 ABENDED at Step UPG_DELIVERY.INIT.ShFrtMsc (SQL) -- RC = 805
PSAESRV.18334 (4) [11/30/11 22:59:56](3) File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1617 Error Position: 0 Return: 805 - ORA-00001: unique constraint
(SYSADM.PS_UPGDLV_MP_TAO4) violated
Failed SQL stmt:INSERT INTO PS_UPGDLV_MP_TAO4 (PROCESS_INSTANCE, SOURCE_BUS_UNIT, DEMAND_SOURCE, ORDER_NO, SHIP_ID_EST, SHIP_ID, DEPLETED_FLAG, DUPLICATE_FLG, ORDER_TYPE_CD, FREIGHT_BILL_TYPE, SOURCE_CD, BUSINESS_UNIT, DELIVERY_ID, BASE_CURRENCY, RT_TYPE, RATE_MULT, RATE_DIV, RATE_DATE, CURRENCY_CD, CURRENCY_CD_BASE, SETID_AUTO_NUM, SETID_TRFT, SETID_SRC_CD, SETID_INV_ITEM, BILL_ONLY, DOC_REFNUM, FRT_CHRG_METHOD, EFFDT) SELECT DISTINCT 6289649, M.SOURCE_BUS_UNIT, M.DEMAND_SOURCE, M.ORDER_NO, ' ', M.SHIP_ID, 'Y', 'N', H.ORDER_TYPE_CD, H.FREIGHT_BILL_TYPE, H.SOURCE_CD, M.BUSINESS_UNIT, ' ', B.BASE_CURRENCY, B.CUR_RT_TYPE, 0, 0, H.RATE_DATE, H.CURRENCY_CD, H.CURRENCY_CD_BASE, C.SETID, ' ', ' ', ' ', 'Y', ' ', '02', TO_DATE(TO_CHAR(M.DT_TIMESTAMP,'YYYY-MM-DD'),'YYYY-MM-DD') FROM PS_SHIP_FRT_MISC M JOIN
0