My Oracle Support Banner

How to Create Fixed TierRate Table With 0-1000 As A Threshold For Calculation? (Doc ID 2803282.1)

Last updated on AUGUST 30, 2021

Applies to:

Oracle Fusion Incentive Compensation Cloud Service - Version 11.13.21.04.0 and later
Information in this document applies to any platform.

Goal

How to create a performance measure for a fixed tier calculation where the rate table tier 0-1000 is a threshold ?

Sample Expected Rate Table is:
      $1000 -    $300,000   5%
  $300,000 -   $800,000   3%
  $800,000 - $1,000,000   2%
$1,00,000  - $4,000,000   1%

The expectation is that if the output is $30,000, the output should be 1500. If the output is 850000, the calculation is $300,000*5%+($800,000-$300,000)*3%+($850,000-$800,000)*2%

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.