9.2 Upgrade ABENDED at Step UPG_AR.ARC40.REMSEWS4 (SQL) Single Row Subquery
Hi
There was an issue reported by a customer upgrading to 9.2.
Stmt #: 1623 Error Position: 51 Return: 1427 - ORA-01427: single-row subquery returns more than one row Failed SQL stmt: UPDATE PS_ITEM_ACTIVITY SET REMIT_ADDR_SEQ_NUM = ( SELECT DISTINCT B.ADDRESS_SEQ_NUM FROM PS_VENDOR_ADDR B , PS_VENDOR A , PS_CUSTOMER C , PS_SET_CNTRL_REC S , PS_ITEM_ACTIVITY I WHERE A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND B.EFF_STATUS = 'A' AND A.VENDOR_ID =C.VENDOR_ID AND C.SETID = S.SET (200,0) Process 1734 ABENDED at Step UPG_AR.ARC40.REMSEWS4 (SQL) -- RC = 1427 (108,524)
There was an issue reported by a customer upgrading to 9.2.
Stmt #: 1623 Error Position: 51 Return: 1427 - ORA-01427: single-row subquery returns more than one row Failed SQL stmt: UPDATE PS_ITEM_ACTIVITY SET REMIT_ADDR_SEQ_NUM = ( SELECT DISTINCT B.ADDRESS_SEQ_NUM FROM PS_VENDOR_ADDR B , PS_VENDOR A , PS_CUSTOMER C , PS_SET_CNTRL_REC S , PS_ITEM_ACTIVITY I WHERE A.SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND B.EFF_STATUS = 'A' AND A.VENDOR_ID =C.VENDOR_ID AND C.SETID = S.SET (200,0) Process 1734 ABENDED at Step UPG_AR.ARC40.REMSEWS4 (SQL) -- RC = 1427 (108,524)
0