EAP: Matching POrocess Abends At Step AP_MATCH_RAP.DMVchrs.Step18 (SQL) -- RC = 1427 (Doc ID 2276428.1)

Last updated on JUNE 13, 2017

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Matching process abends when run by Business Unit

ERROR:
SQL error. Stmt #: 1723 Error Position: 50 Return: 14 27 - ORA-01427: single-row subquery returns more than one row Failed SQL stmt: UPDATE PS_AP_VCHRLSUM_T4 SET QTY_MATCHED_RECV = ( SELECT SUM(C.QTY_MATCHED) FROM PS _AP_VCHRLSUM_T4 A , PS_RECV_LN_SHIP B , PS_RECV_LN_SHP_MTH C WHERE A.PROCESS_INSTANCE = 117356 AND A.BUSINESS_UNIT_PO =B.BUSINESS_UNIT_PO AND A.PO_ID = B.PO_ID AND A.LINE_NBR = B.LINE_NBR AND A.SCHED_ NBR = B.SCHED_NBR AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.RECEIVER_ID = C.RECEIVER_ID AND B.RECV _LN_NBR = C.RECV_LN_NBR AND B.RECV_SHIP_SEQ_NBR = C.RECV_SHIP_SEQ_NBR GROUP BY B.BUSINESS_UNIT, B.BU SINESS_UNIT_PO, B.PO_ID, B.LINE_NBR, B.SCHED_NBR), AMT_MATCHED_RECV = ( SELECT SUM(C.AMT_MATCHED) FR OM PS_AP_VCHRLSUM_T4 A , PS_RECV_LN_SHIP B , PS_RECV_LN_SHP_MTH C WHERE A.PROCESS_INSTANCE = 117356
Process 117356 ABENDED at Step AP_MATCH_RAP.DMVchrs.Step18 (SQL) -- RC = 1427

STEPS:
Run Matching process by Business Unit

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