My Oracle Support Banner

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

Last updated on AUGUST 01, 2019

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.13.19.01.0 and later
Information in this document applies to any platform.

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

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
Goal
Solution
References


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