My Oracle Support Banner

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.

Goal

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

column: COMMISSION_AMOUNT
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)
 

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.