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 MARCH 03, 2020
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.
When attempting to create a PS Query which uses "OR" Criteria and group the criteria using parenthesis, the following error occurs:
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
4. Run the Query
5. 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
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