Incorrectly Calculated Taxes For Pipeline Rated Event When There Is a Discount
Last updated on SEPTEMBER 26, 2016
Applies to:Oracle Communications Billing and Revenue Management - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 7.4.0]
Information in this document applies to any platform.
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.
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