E-QR: PS Query With Group Criteria Throws The Error "Illegal usage of parenthesis in criteria!" After PeopleTools 8.55 Upgrade

(Doc ID 2278442.1)

Last updated on JULY 18, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

When attempting to create a PS Query which uses "OR" Criteria and group the criteria using parenthesis, the following error occurs:

Error
-------
"Illegal usage of parenthesis in criteria!"


Steps
--------
The issue can be reproduced at will with the following steps:
1. Login to PIA
2. Navigate to Reporting Tools > Query > Query Manager
3. Construct a query which contains criteria like A.MESSAGE_SET_NBR >= :1 AND A.MESSAGE_SET_NBR <= :2 which both prompts are optional prompts

Sample SQL from Query Manager:

SELECT A.MESSAGE_SET_NBR, A.MSG_SEVERITY, Count( A.MESSAGE_NBR)
FROM PSMSGCATDEFN A
WHERE ( ( A.MESSAGE_SET_NBR < :1
OR A.MESSAGE_SET_NBR = :1)
AND ( A.MESSAGE_SET_NBR > :2
OR A.MESSAGE_SET_NBR = :2))
GROUP BY A.MESSAGE_SET_NBR, A.MSG_SEVERITY
ORDER BY 1, 2, 3


Getting "Illegal usage of parenthesis in criteria! (30,12)" error on running the query (hit enter without entering/changing values when prompt for runtime prompts). Since both prompts are optional, they should be dropped from
criteria.



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