My Oracle Support Banner

E-QR: How To Use "=" Operator When Using CASE Statement In Query Expression (Doc ID 2258276.1)

Last updated on FEBRUARY 04, 2019

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 = 'USER' 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. 




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.