My Oracle Support Banner

Rate Table Values And Interception Of The Dimensions (Doc ID 2442962.1)

Last updated on NOVEMBER 18, 2019

Applies to:

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


On : version, Compensation Plans

Rate table values and interception of the dimensions

We want to make a join for a spesific report requirement.

From the documentation we reach tables and columns of incentive compensations.








With this tables we can findout relations between rate tables- dimension, tiers, rate table values.
But rate table values are stored sequentally for all values. ( rate_table_values_all table) . But there is no information about which dimension values get the rate . For example

In the UI we see that if dimension A - tier 1 is 3 to 5 and dimension B tier 1 is 2 to 4 , we get rate 0.08.
There are only information about Dimension and tiers and their values. And also rate table rate values for each dimension.But there is'nt any relation stored in the table.

I can not reach this information using this tables. 


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.