How Can You Create New Commission Line Derived By Previously Calculated Commission Lines?
(Doc ID 2524938.1)
Last updated on DECEMBER 03, 2019
Applies to:Oracle Incentive Compensation - Version 12.1.2 and later
Information in this document applies to any platform.
You need to summarize the result of commission amount "SUM(CN_COMMISSION_LINES.COMMISSION_AMOUNT)", but first you need to calculate all the formulas that will compose this math sentence above. You want to know if it is possible to create another line commission from the previous calculated lines (formulas) ? For example:
TABLE : CN_COMMISSION_LINES
LINE 1(formula 1): 10
LINE 2(formula 2): 20
LINE 3(formula 3): 30
NEW LINE (new formula derived by sum of lines above): SUM(10+20+30)
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