My Oracle Support Banner

Tierred Rating Based On Resource Balance Not Working With Negative Resource Bal (Doc ID 804525.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version to [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

Actual result:
The bill amount is -650(-450$ applied on 01/Apr, and -200$ applied on 01/May) and non-currency
1000099 is set to -2.




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

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