Tierred Rating Based On Resource Balance Not Working With Negative Resource Bal
Last updated on JUNE 12, 2018
Applies to:Oracle Communications Billing and Revenue Management - Version 184.108.40.206.0 to 220.127.116.11.0 [Release 7.3.0]
Information in this document applies to any platform.
This problem can occur on any platform.
-- Problem Statement:
While using tierred rating based on resource balance with a negative balance for the resource, the
transition between tiers does not happen correctly.
The counter balance is initialized as -3.5, The rate tier for the product rating the event is as
No min - -3 -500,NCR=1
-3 - -2 -400,NCR=1
-2 - -1 -300,NCR=1
-1 - no max -200,NCR=1
And proration is also defined
Since at start the counter is -3.5, only 0.5 of that lies in the No min - -3 tier, so that part
gets charged(-500*0.5 = -250). The second half of the first month, charges the remaining 0.5 from
the -3 to -2 tier(0.5*-400 = -200). That is how on triggering this negative charge, it charges
$450(and not $500)
Going on to the second month, it applies the charge correctly for the first 0.5 with 200$, but it
leaves the other 0.5 quantity as unrated. This should have been charged under the -2 to -1 tier,
giving a amount of -150(which would make the total charge of -350 for the new cycle).
-- Steps To Reproduce:
1. Create a customer on 01/Apr with the "Negative Tier Plan". non-currency 1000099 would be
updated to -3.5
2. Purchase the add on deal "Negative Rate". A charge of -450$ is applied. non-currency 1000099
is updated as -2.5
3. Move date to 01/May, execute billing. The bill amount is -650(-450$ applied on 01/Apr, and
-200$ applied on 01/May) and non-currency 1000099 is set to -2.
Expected result :
Bill amount on 01/May is -800(-450 ( 250 + 200) applied on 01/Apr, and -350 ( 200 + 150) applied
on 01/May) and non-currency 1000099 should be -1.5
The bill amount is -650(-450$ applied on 01/Apr, and -200$ applied on 01/May) and non-currency
1000099 is set to -2.
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