Incorrect Commission When Using CN_COMMISSION_HEADERS.TRANSACTION_AMOUNT - CN_SRP_PERIOD_QUOTAS.ITD_TARGET In An Expression
(Doc ID 417111.1)
Last updated on DECEMBER 03, 2019
Applies to:
Oracle Incentive Compensation - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]Information in this document applies to any platform.
Symptoms
A salesrep is paid commission as follows:
From the total of the transaction amount, if he does over $1 to $ 750K more than the quota he gets 4% of the extra amount he did, over 750K to 1.5M he gets 4.25%, over 1.5M to 2.5M he gets 4.5% and so on. So rate table is created accordingly.
| <9,999,00> | 1.00 | 0.000 |
| 1.00 | 750,000.00 | 4.000 |
| 750,000.00 | 1,500,000.00 | 4.250 |
| 1,500,000.00 | 2,500,000.00 | 4.500 |
| 2,500,000.00 | 99,999,999,999.00 | 5.000 |
INPUT expression
CN_COMMISSION_HEADERS.TRANSACTION_AMOUNT - CN_SRP_PERIOD_QUOTAS.ITD_TARGET
OUTPUT expression
Rate Table Result * (CN_COMMISSION_HEADERS.TRANSACTION_AMOUNT - CN_SRP_PERIOD_QUOTAS.ITD_TARGET)
Formula is built with the following settings:
- Apply Transactions: Individually
- No split
- Cumulative flag: checked
- ITD flag: checked
If Quota (target) = 3,850,000 and the transaction_amount = 5,770,000, we expect the commission to be 86,400
e.g: 5,770,000 (TRANSACTION_AMOUNT) - 3,850,000 (ITD_TARGET) = 1,920,000
Rate = 4.5% (Tier 3 commission rate)
Commission = 86400 (1,920,000 * 4.5%)
But the system is calculating at 5% rate and result in wrong commission, this is because in the generated formula package CN_SRP_PERIOD_QUOTAS.ITD_TARGET always equal 1.
Cause
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
| Symptoms |
| Cause |
| Solution |