My Oracle Support Banner

How To Fix The Batch Rating - Discount More Than Possible Rounding Issue (Doc ID 1342354.1)

Last updated on MARCH 18, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version and later
Information in this document applies to any platform.


This scenario occurs whenever there is a '5' as the digit to be rounded off.
This will mostly happen when takes half of any number having the last significant digit as an odd digit:

0.1011 *.0.5 = 0.05055
0.2013 * 0.5 = 0.10065
0.3015 * 0.5 = 0.15075
.... and so on

In all these cases, it is because the '5' is always rounded up on following the normal ROUNDING procedure.

Consider the following two scenarios:
Suppose when follow normal rounding with 2 decimal places.

It has a set of even and odd numbers, say, 0.102 and 0.205.
0.102 becomes 0.10 after rounding.
0.205 becomes 0.21 after rounding.
0.102 + 0.205 = 0.307 which is less than 0.10 + 0.21 = 0.31.

Now, another set of even numbers, say, 0.102 and 0.208.
0.102 becomes 0.10 after rounding.
0.208 becomes 0.21 after rounding.
0.102 + 0.208 = 0.31 = 0.10 + 0.21 (the expected value).

The same can be tried for any set of numbers. If the trailing digit is not '5', the rounding is perfect. When gets a '5', it will have a discrepancy.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.