Item and Tax Rounding - During Taxation,Rating and Items Are Rounded to Different Values (Doc ID 467249.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.1 to 7.3.1.0.0 [Release 7.3.0 to 7.3.1]
Information in this document applies to any platform.
Checked for relevance on 22-Sep-2010
**Checked for relevance on 25-Feb-2012**
Checked for relevance on 02-Dec-2013.
***Checked for relevance on 29-June-2015***

Symptoms

During taxation, items and rating are rounded to incorrect values.

The requirement is:
- rating/discount to 4 decimal places
- taxation to 4 decimal places
- items to 2 decimal places

Reproduction Steps:

1. The beid file will need to have the following rounding settings:

# Euro and EMU currencies
#
978 0 4 0.010000 0.050000 0.040000 EUR E * 0 0 1 Euro
978 0 4 0.010000 0.050000 0.040000 EUR E * 1 0 1 Euro
978 0 4 0.010000 0.050000 0.040000 EUR E * 2 0 1 Euro
978 0 2 0.010000 0.050000 0.040000 EUR E * 3 0 1 Euro

    Load the pin_beid and restart all services.

2. Next, set the value of "generate_journal_epsilon" parameter in /config/business_params.
    The value of this parameter should be 1 (enabled). This parameter is used during bill time rounding.

3. Restart services.

4. Purchase the product and observe that the tax and rating values in event_t is upto 4 decimal places and item values in Customer Center is upto 2 decimal places.
    However, in item_t it will still show upto 4 decimal places.

SQL> select item_total from item_t where account_obj_id0=701988;

ITEM_TOTAL
----------
0
0
22.9134

SQL> select DUE from item_t where account_obj_id0=701988;

DUE
----------
0
0
22.9134

SQL> select DELTA_DUE from item_t where account_obj_id0=701988;

DELTA_DUE
----------
0
0
0


5. Next, Run pin_bill_day

6. NOTE: On setting the entry to "1", restarting the cm and running pin_bill_day, following are the results:

SQL> select DUE, DELTA_DUE from item_t where account_obj_id0=701988;

DUE        DELTA_DUE
---------- ----------
  0        0
  0        0
22.91      .0034
  0        0

Cause

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