Syntax For AND Operator Inside CASE Statement For Calculated Fields In BI Mobile Applications Designer (Doc ID 2212785.1)

Last updated on DECEMBER 12, 2016

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.1.1.7.x to 11.1.1.7.x [Release 11.1]
Information in this document applies to any platform.

Symptoms

Cannot create a calculated field in BI Mobile Applications Designer (BIMAD) when the CASE statement uses the AND operator.

For example:

CASE WHEN {STATUS} = "ACTIVE" AND {PHASE} = "4" THEN "Conduct" END

Changes

 

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