TOTALC IS ALWAYS POSITIVE AMOUNT (Doc ID 1057954.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 to 7.3.0.0.0 [Release 7.3.0]
Information in this document applies to any platform.
**Checked for relevance on 25th Feb 2012**


Goal

In case when it is needed to refund discount (for forward arrear fee which is prorated and cancelled during billing cycle) then discount amount is negative, but TotalC as base for discount calculation is not negative, but positive. This causes wrong calculation of discount in certain scenarios.

### Steps to Reproduce ###
Here is the scenario:
Discount 15Eur off is defined for ANY monthly fee. This amount is with VAT VAT is 20%, so without VAT is 12.5). Discount is using resource 3000005 to track discounted amount (without VAT) for current month and grants discount until balance of 3000005 reaches 12.5.Account has monthly fee Plan15(15Eur) and discount 15Eur off. During plan transition, when existing monthly fee Plan15 is refunded and new one is added Plan5 (5Eur) after discount is applied total charge is negative.

Event 1:
Account is created on 10.10.2009. Monthly fee is forward area and it is 15Eur with VAT. Prorationaly charged it is 8.75+1.75 (20% of VAT).

Event 2:
The same date discount 15Eur off for monthly fee is purchased and grantsdiscount on total amount which generates two additional balance impacts -8.75 and -1.75 (this corresponds to VAT) on currency resource (978-Euro),and -8.75 for non currency resources tracking discounts (3000005).

Event 3 and 4:
Migration from plan with MF 15Eur is made to plan with MF 5Eur.
Expected result:
a) previous monthly fee Plan15 is refunded (balance impacts: -8.75 and -1.75 on currency resources)
b) already applied discount on Plan15 is refunded (balance impacts: 8.75+1.75 on currency resources, 8.75 on non currency resources)
c) monthly fee Plan5 is charged (balance impact: 2.9167 on currency resources)
d) discount on monthly fee Plan5 is charged (balance impacts: 2.9167 charge for monthly fee and -2.9167 for discount both applied on currency resource, -2.9167 on non currency resource)

Expected result: 
Total amounts should be: 0 for currency resources and -2.9167 for non currency resources

Actual result:
a) previous monthly fee Plan15 is refunded and at the same time discount is applied (balance impacts: -8.75 (as original monthly fee), 3.75 (for discount 3.75=12.5-8.75) --1 on currency resources; 3.75 on non currency resources)
b) monthly fee Plan5 is charged (balance impact: 2.9167 on currency resources)
c) discount on monthly fee Plan5 is charged (balance impacts: 2.9167 charge for monthly fee and -2.9167 for discount both applied on currency resource, -2.9167 on non currency resource)
Total amounts are: -6 for currency resources and -7.9167 for non currency resources.

Solution

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