Free Minutes Consumption Based on Proration (Doc ID 3000050.1)

Last updated on FEBRUARY 01, 2024

Applies to:

Goal

There is a requirement to consume any free units such as VOICE / SMS / DATA usages, based on proration. Once the user consumes all the FREE units, then Billing and Revenue Management (BRM) starts charging based on the the rate configured.

1) Free Voice Usages - Example: 300 Minutes Free per Month
2) Free SMS Usages - Example: 150 SMS Free per Month
3) Free DATA Usages - Example: 30 GB Free per Month

Example rate for simple understanding purpose:
Voice - 1 USD / Minute
SMS - 2 USD / SMS
DATA - 3 USD / GB
Monthly Recurring Charge(MRC) = 90 USD

Scenario:
=====
01-Sep-2023 - Customer is created and 90 USD as monthly recurring charge is charged.
02-Sep-2023 - Customer makes 200 minutes of Voice call
05-Sep-2023 - Customer makes 150 minutes of Voice call
10-Sep-2023 - Customer is suspended/terminated

In this case, in the event_bal_impacts_t table (after loading it through REL as rating is done in Elastic Charging Engine (ECE):
Expected RC = Need to charge only for 10 days, so 90/30*10 = 30 USD, one can see debit of 90 USD and Credit of 60USD on 10-Sep-2023 - when Customer is suspended/terminated.
Both expected and actual are correct.

Expected Voice Usage Charge:
As first 300 minutes of Voice call per month is free, customer used all the free minutes within first 10 days of the bill period and charged for voice calls excess of free minutes. So in this case, customer is charged for 50 minutes (total 350 minutes customer used out of this 300 minutes is free)
50 * 1 = 50 USD charged for Voice Calls till 10-Sep-2023.

Since customer is suspended/terminated on 10-Sep-2023, the requirement is as follow:  Excess minutes already consumed and rated, post free voice minutes, need to be re-rated. BRM C Rating, expects re-rating but rating/re-rating of any type of usages will be performed in ECE.

How can one fulfill this requirement? One need to do rating/re-rating of excess voice minutes?
 

Solution

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