E-QR: A Query That Has a Prompt in a HAVING Clause Will Fail At Runtime on PeopleTools 8.54.14 to 8.54.17 (Doc ID 2071389.1)

Last updated on DECEMBER 29, 2015

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 to 8.54 [Release 8.4]
Information in this document applies to any platform.

Symptoms

The "HAVING" clause generated for a query in 8.54.14 is incorrect if the HAVING clause includes a Prompt.

This is visible specially in 2-tier but the error is received from Query Manager when running the query:

MS-SQL:

"A SQL error occurred. Please consult your system log for details. Error in running query because of SQL Error, Code=8601, Message=[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Executing SQL directly; no cursor. [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near the keyword 'AND'. [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Statement(s) cou (50,380)"

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