E-QR: How To Use "=" Operator When Using CASE Statement In Query Expression

(Doc ID 2258276.1)

Last updated on JUNE 12, 2017

Applies to:

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


When using "=" operator in the case statement as shown below, the result is taking the else part even though the condition is true while executing the query.

case when :2 = 'THERESA' then 'match' else 'no match' end

Replication steps
The issue can be reproduced at will with the following steps:

1. Create a new query, add a record, for instance:Record--INSTALLATION

2. check one of the field under Query tab and click on expression tab:--Company 

3. Click on add expression, add a bind variable in expression text with length 10

4. Add another expression with below case statement as shown below 
CASE WHEN :1 ='AU' THEN 'NAME' else 'undefined' END

5. Under the prompts add the table (for instance: COMPANY_TBL) and create a prompt for the table.

6. View the SQL and run the SQL and observe the SQL displaying the ELSE part. 


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