EAP: Voucher Build Goes to No Success in DB2 & MSSQL Server at AP_VCHRBLD.G0000.STEP05 (Doc ID 2009847.1)

Last updated on MARCH 09, 2017

Applies to:

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

Symptoms

After applying PUM Image 11 or Patch 19713187, Voucher Build erroring out with a SQL error on MSSQL Server 2012 and DB2 at AP_VCHRBLD.G0000.Step05 (Do Select)

ERROR
File: e:\pt85409c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 0 Return: 8614 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Executing SQL directly; no cursor.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'GROUP'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) c
Failed SQL stmt: SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , COUNT(*) FROM PS_VCHR_HDR_TMP4 B , PS_VCHR_PYMT_TMP4 A WHERE B.PROCESS_INSTANCE = 138 AND B.PROCESS_INSTANCE = A.PROCESS_INSTANCE AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.VOUCHER_ID = A.VOUCHER_ID AND NOT EXISTS ( SELECT 'X' FROM PS_VCHR_PYMT_TMP4 AA WHERE AA.PROCESS_INSTANCE = 138 AND AA.BUSINESS_UNIT = A.BUSINESS_UNIT AND AA.VOUCHER_ID = A.VOUCHER_ID AND AA.PYMNT_CNT = 1) HAVING COUNT(*) = 1 GROUP BY A.BUSINESS_UNIT, A.VOUCHER_ID

Process 138 ABENDED at Step AP_VCHRBLD.G0000.Step05 (Do Select) -- RC = 8614 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

STEPS
1) Checked if the patch is applied by navigating to Main Menu, PeopleTools, Utilities, Administration, Updates by Update ID and search on 19713187.
2) Added a quick invoice
3) Ran voucher build
4) The process ended with the above error.

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