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.
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:
"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)"
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms