How To Calculate & Display Commission Rate & Amount In Commission Lines & In Adjust Screen With Significant Decimals ( Extended Precision ) (Doc ID 417457.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Incentive Compensation - Version 11.5.10 to 12.1.0 [Release 11.5 to 12.0]
Information in this document applies to any platform.
Checked for relevance on 16-May-2013

Goal

 

How to display commission amount and commission rates in agjustment screen with all significant decimals ?

 

Commission rates have  8 positions to right of decimal by using profile option :
OSC: Commission Rate Precision with value 8

Transactions calculate correctly but in the commission_lines table the commission rate that is
stored is truncated.

In table cn_commision_lines the amont are checked by doing as below :

SELECT processed_period_id, rate_tier_id, commission_rate, commission_amount
FROM CN_COMMISSION_LINES
WHERE CREDITED_SALESREP_ID = (
select  salesrep_id
from jtf_rs_salesreps
where name like ‘&you_salesrep_name');

CREDITED_SALESREP_ID RATE_TIER_ID COMMISSION_RATE COMMISSION_AMOUNT
100002802                            1000                    0,00014                         1,43963

But the actual commision rate is :

.0001439632

This can be checked by entering commission rates

Incentive Compensation Super User
> Plan Element
> Formula
> Commission Rates
Rates are well displayed with 8 decimals in this screen in accordance with profile :
OSC: Commission Rate Precision = 8

Furthermore checking calculation log confirms this :

AFTER get_input 10000
rate scheduled_id is 1002 rt_quota_asgn_id 10124
BEFORE EXITING GET_RATES
AFTER get_rates .0001439632
AFTER get_commission 1.439632
AFTER get_perf10000

But the commission rates in adjust screen are not displayed with 8 significant decimals

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms