Invalid Expressions Using CHOICE Statement With Combination of OR and AND Operators (Doc ID 2572110.1)

Last updated on JANUARY 24, 2023

Applies to:

Goal

On : 11.13.19.01.0 version, Compensation Plans

Question: How to use the Expressions using CHOICE statement with combination of OR and AND operations

Customer scenario:

Expressions using CHOICE statement with combination of OR and AND operations will not validate

The client has several If-THEN-ELSE conditions that are better defined using Logical Operations rather than DECODE. Here is the basic logic of what the client is trying to do:

CHOICE ( OR ( AND (condition 1 , condition 2),
AND (condition 3 , condition 2),
AND (condition 4 , condition 5)
),
RESULT 1,
RESULT 2
)

Actual expression we are trying to validate:

CHOICE (
OR (
AND (IS_EQUAL ( Credit.Product_Group , 'AWS' ) , IS_LESS ( TO_DATE ( Credit.Close_Date , 'MM-DD-YYYY' ) , TO_DATE ( '05-26-2016' , 'MM-DD-YYYY' ) ) ) ,
AND ( IS_EQUAL ( Credit.Product_Group , 'Azure' ) , IS_LESS ( TO_DATE ( Credit.Close_Date , 'MM-DD-YYYY' ) , TO_DATE ( '05-26-2016' , 'MM-DD-YYYY' ) ) ) ,
AND ( IS_EQUAL ( Credit.Product_Group , 'Fanatical Support for Office 365' ) , IS_LESS ( TO_DATE ( Credit.Close_Date , 'MM-DD-YYYY' ) , TO_DATE ( '07-17-2016' , 'MM-DD-YYYY' ) ) )
) ,
Get Tier Event ( Credit.CREDITED_PARTICIPANT_ID , Credit.SOURCE_EVENT_DATE ) ,
'Fanatical Support'
)

Note: Result 1 "Get Tier Event" is a user defined query.

This may be a syntax issue, but this is the expression cannot get it to validate.
 

Solution

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