EAP: Load Assets Request abends at Step INTFAPAM.B0000.Step11 -- Subquery returned more than 1 value

Last updated on JUNE 20, 2018

Applies to:

Symptoms

Load Asset Request (INTFAPAM) process abends at Step INTFAPAM.B0000.Step11 with an error.

ERROR
Error. Stmt #: 1623  Error Position: 0  Return: 8601 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. [Microsoft][SQL Server Native Client 10.0][SQL Failed SQL stmt: UPDATE PS_INTFC_AP_AM_TAO SET DISTRIB_SEQ_NUM = ( SELECT B.DISTRIB_SEQ_NUM FROM PS_VCHR_DIST_ASSET B WHERE PS_INTFC_AP_AM_TAO.BUSINESS_UNIT_AP = B.BUSINESS_UNIT AND PS_INTFC_AP_AM_TAO.VOUCHER_ID = B.VOUCHER_ID AND PS_INTFC_AP_AM_TAO.VOUCHER_LINE_NUM = B.VOUCHER_LINE_NUM AND PS_INTFC_AP_AM_TAO.DISTRIB_LINE_NUM = B.DISTRIB_LINE_NUM) WHERE PROCESS_INSTANCE = 4154111 AND QUANTITY = 1 AND EXISTS ( SELECT 'X' FROM PS_VCHR_DIST_ASSET C WHERE PS_INTFC_AP_AM_TAO.BUSINESS_UNIT_AP = C.BUSINESS_UNIT AND PS_INTFC_AP_AM_TAO.VOUCHER_ID = C.VOUCHER_ID AND PS_INTFC_AP_AM_TAO.VOUCHER_LINE_NUM = C.VOUCHER_LINE_NUM AND PS_INTFC_AP_AM_TAO.DISTRIB_LINE_NUM = C.DISTRIB_LINE_NUM)
 
Process 4154111 ABENDED at Step INTFAPAM.B0000.Step11 (SQL) -- RC = 8601 (108,524)

STEPS
1.  Installation Options > Payables is setup with Posting Method = Detail Offset Method
2.  Create a 2 line PO with an Asset specified for both lines with Matching turned on
3.  Dispatch the PO
4.  Create 2 Receipts from the PO, one for each PO line, and serialize both Assets
5.  Create a Voucher by copying the 1st Serialized Asset Receipt
6.  Delete the Voucher Line
7.  Copy the 2nd Serialized Asset Receipt
8.  Run Matching
9.  Run Voucher Posting
10.  Run Load Assets Request
11.  Process will abend with the above error

Cause