EAP: Voucher Build Goes to No Success in DB2 & MSSQL Server at AP_VCHRBLD.G0000.STEP05
(Doc ID 2009847.1)
Last updated on SEPTEMBER 03, 2023
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
[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
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 |
| Cause |
| Solution |
| References |