Incorrectly Calculated Taxes For Pipeline Rated Event When There Is a Discount (Doc ID 1446092.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.4.0.0.0 [Release 7.4.0]
Information in this document applies to any platform.

Symptoms


Received Patch 13508181 for an issue reported in <bug 13477934> (event adjustment calculates half tax or 1/3 amount only). After applying this patch, observed below behavior.

There are two kinds of taxes IEPS=3% and IVA=16% for a single event (tax on tax).
Tax codes defined in taxcodes_map as below:

IEIVA : U : 3.00 : 01/01/10 : 01/01/20 : Cou : MX:Mexico : IEPS del 3% : Std
IEIVA : U : 16.00 : 01/01/10 : 01/01/20 : Sta : IVA16 : Iva del 16% : Tax

When doing a credit or debit adjustment for an event rated by pipeline, it calculates the taxed with additional amount on the adjustment original amount.

For example, for an adjustment with $1.00, the tax should be:
$1 * 0.03 = 0.03 (IEPS)
$1.03 * 0.16 = 0.1648 (IVA)
Total tax = 0.03 + 0.1648 = 0.1948

However, the calculated taxes on the event are 0.3818078322:
$1.959999 * 0.03 = 0.058799997
2.01879 * 0.16 = 0.3230078352
Total tax = 0.058799997 + 0.3230078352 = 0.3818078322

The discount is $0.96 in this case.  It looks like the tax calculation is using $1.96 = $(1.00 + 0.96).
Expect it to ignore the discount.

Steps to Reproduce:
1. Configure two different taxes (tax on tax) as mentioned above
2. Configure a product for pipeline rating using this taxes (deferred tax)
3. Rate an event (CDR) and load it to BRM
4. Bill the account
5. Adjust the event

This issue is found on 7.4 PS10 with patch 13508181.

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