Calculation Commission is Zero Due to Expression Not Matching on Key Word Containing SELECT
Last updated on JUNE 21, 2016
Applies to:Oracle Fusion Incentive Compensation Cloud Service - Version 126.96.36.199.0 and later
Oracle Fusion Incentive Compensation - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
Calculation commission result = 0 for particular credit category/product.
1. Create Performance Measure with the following :
a. Input Expression = DECODE (NVL (Credit.ATTRIBUTE91 , NONE), PAYROLL_PLUS, PAYROLL_PLUS , PAYROLL_SELECT , PAYROLL_SELECT , .... etc ... )
b. Rate Table with string dimension.
Example: If PAYROLL_SELECT then 4000.00
c. Measure Formula = Rate Table Rate * 0.35
2. Create transaction with ATTRIBUTE91 = PAYROLL_SELECT
3. Run Classification, Crediting and Rollup, then Calculation
4. Review the transaction and it shows the commission is zero.
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