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.
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)
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