EAP: Voucher Build abends at Step APVEDTDFVL.MAIN.Step16 when running on SQL Server

(Doc ID 2111673.1)

Last updated on FEBRUARY 29, 2016

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When running Voucher Build on a SQL Server database, process abends at Step APVEDTDFVL.MAIN.Step16 with an error.

Issue occurred after applying Image #16.

ERROR
File: e:\pt85418b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'A'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'AND'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not b
Failed SQL stmt: UPDATE PS_VED_VLN_TAO4 A SET KK_PROCESS_PRIOR = 'Y' WHERE EXISTS( SELECT 'X' FROM ps_installation WHERE commitment_cntl_po = 'Y') AND PROCESS_INSTANCE = 5342845 AND BUSINESS_UNIT_PO <> ' ' AND PO_ID <> ' ' AND NOT EXISTS ( SELECT BUSINESS_UNIT , VOUCHER_ID FROM PS_AP_IPAC_HDR HDR WHERE HDR.BUSINESS_UNIT = A.BUSINESS_UNIT AND HDR.VOUCHER_ID = A.VOUCHER_ID)

Process 5342845 ABENDED at Step APVEDTDFVL.MAIN.Step16 (SQL) -- RC = 8601 (108,524)

STEPS
1. Apply Image #16
2. Load an external Voucher
3. Run Voucher Build
4. Above error will occur

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