My Oracle Support Banner

Cannot use CASE WHEN statement in output expression (Doc ID 314427.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Incentive Compensation - Version 11.5.9 and later
Information in this document applies to any platform.

Goal

Have to create the following Output Expression :


If the (NUMBER_OF_MONTHS of CUSTOMER_CONTRACT) is Greater Than 5 years,
then multiply the Commissions by a factor of 1.1, else multiply the Commissions by a factor of 1.1

If we could use "CASE WHEN", we could use :


Rate Table Result*Commission Lines.TRANSACTION_AMOUNT*
(Case when to_number(attribute14) > 60
then 1.1 else 1.0 end)

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


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