My Oracle Support Banner

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



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
select  salesrep_id
from jtf_rs_salesreps
where name like ‘&you_salesrep_name');

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


To view full details, 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 a vibrant support community of peers and Oracle experts.