EAP: Load Assets Request ABENDED at Step INTFAPAM.B0000.Step11 -- Subquery returned more than 1 value
(Doc ID 1967824.1)
Last updated on MAY 07, 2019
Applies to:
PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
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 = XXXXXXX 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 XXXXXXX 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
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |