My Oracle Support Banner

0.01 Extra Balance Amount & Tax Amount Is Getting Applied During Event Level Credit Adjustment (Doc ID 2595721.1)

Last updated on OCTOBER 09, 2019

Applies to:

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

Symptoms

In Billing Revenue Management (BRM) there is fraction difference issue in Tax adjustment.

Please find below the scenario in detail.

1.Purchase a Package
2.Package price 27 and there is a discount of 30%, ie., 8.1 and tax 0.94 + 1.89
3.Bill's entries: (27-8.10+0.94+1.89= 21.73) -- Payment Success
4. Customer upgraded the package to Plus.
5. Old package Cancellation : -22.65
6. discount : 6.80 ,tax : - 0.79 , -1.58
7. New package rental : 40, prorated 33.55,40% discount : 13.42,Tax : 2 + 1.01
8. Bill Now amount : -22.65 +6.8 -0.79 -1.58 + 33.55 - 13.42 +2 +1.01 -->4.92 payment Success
9. Recurring Billing ,Rental 40 ,discount -16,Taxes 2.39 + 1.20, Bill Amount = 27.59 -- payment success.

After the Payment reversal of 21.73 first bill and pass the Adjustment. The below issue is facing over adjustment in Tax calculation.

Charge (27-8.10, Tax 2.83)
Cancel credit (-22.65 +6.8, Tax -2.37)
Remaining (-3.05, -0.16 tax (-0.47 -0.31) -0.47)
ie., 2.83 - 2.37 -0.47 ==> 0.01

Steps to Reproduce this issue:

Below is the scenario which is generating the additional 0.01 balance amount and 0.01 tax amount while doing 100% event level adjustment of an item which got 90% refund due to cancellation.

Note: 10% tax will be applied on the charges.

1. Created a non-payee customer with a package having 17.5 MRC. [Account Creation Date: 28-JAN-19]
2. Performed three bill cycle run. [Jan-Feb, Feb-Mar, Mar-Apr]
3. After 3 days [1-May] Moved out of the hierarchy which resulted in the cancellation of the previous bill cycle [90%] charges.
3.1. 90% of the charge is 15.75 and tax got calculated as 1.58 [Actual tax amount is 1.575 after rounding it become 1.58]
4. After cancellation, we performed 100% event level adjustment on the above canceled CF.
4.1. The previous billing cycle got already got a refund of 90% which is 15.75
4.2. Now while performing 100% event adjustment with the reason "Pricing Adjustment", system was trying to perform 10% remaining which is 1.75
4.3. Adjustment got applied successfully and resulted in 1.76 as a charge event and 0.18 as a tax charge.

Cause

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
Symptoms
Cause
Solution
References


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