My Oracle Support Banner

Flexibility Of Roaming Product Offering Configuration (Doc ID 1558844.1)

Last updated on MARCH 27, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version to [Release 7.4.0 to 7.5.0]
Information in this document applies to any platform.


Use Case Scenario

We have a requirement where we want customer to be charged at domestic rate even when roaming. Our current configuration is like below:

In USC_MAP, we have configured all the national, international and roaming scenario.
Say, we have 100 National, 100 International and 6 roaming scenario.
In roaming, based on 6 zones (we have divided countries into 6 zones), we are assigning the impact categories.

Now, we want to offer a product (example: USA roaming offer), say, if customer is roaming in USA, he will be charged at domestic rate.
This offer has to be made flexible in configuration. Say, provider can introduce any new offer, like India roaming offer, Germany roaming offer, Asia roaming offer, etc.
We want to make this this configuration flexible.

We think of possible configuration scenarios like, in USC_MAP, we will create a duplicate scenario of all the national scenario and in Usage type, we will assign the offer name (higher priority of this).
In usage type, we will assign the offer name by using an iScript.

But, then if any new offer is introduced, we will have to follow same procedure for configuration.

We want some flexible configuration, like if we make an entry in one table, it will be configured.


1. If the script could be written in such a way that the configuration of new propositions could be done in a database table(s) e.g. adding a weekly version of offer or adding a new country to world offer propulsions by adding/updating rows in this table(s). The configuration would then be loaded into memory by the iscript on startup/refresh so that performance should not be impacted significantly. The iscript would then only need to query the cached configuration when rating (probably stored in a hash table for quick access). Can we do in this way?

2. The second option is to create new rate plan for each proposition instead,also want to know what the impact is on the maintainability of existing rate plans e.g. if we change the price of one domestic scenario, will we need to update all of the roaming offer tariffs independently? Also what would be the impact on new/existing bundles that are consumable under roaming offer  propositions?

3. Another option may be to write a macro enable excel that will be able to generate the iscript based on the values entered in specific sheets. This would allow them a less risky way to update the script.

Please suggest the feasibility of these solutions and also suggest ways to configure this?


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
 Use Case Scenario

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