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.

Symptoms

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. 

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