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.
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.
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