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 11.13.18.02.0 and later
Information in this document applies to any platform.

Goal

On : 11.13.18.02.0 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.


CN_RATE_DIMENSIONS_ALL_B

CN_RATE_DIMENSIONS_ALL_TL

CN_RATE_DIM_TIERS_ALL

CN_RATE_TABLES_ALL_B

CN_RATE_TABLES_ALL_TL

CN_RATE_TABLE_DIMS_ALL

CN_RATE_TABLE_VALUES_ALL

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. 
 

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.