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 MARCH 05, 2018
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
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
WHERE CREDITED_SALESREP_ID = (
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 :
This can be checked by entering commission rates
Incentive Compensation Super User
> Plan Element
> 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
But the commission rates in adjust screen are not displayed with 8 significant decimals
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!