Financial Management - PSFT (MOSC)

MOSC Banner

9.2 Upgrade ABENDED at Step UPG_AR.ARC40.REMSEWS4 (SQL) Single Row Subquery

edited May 23, 2013 4:40PM in Financial Management - PSFT (MOSC) 2 comments
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)

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