PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center