My Oracle Support Banner

Monitor Balance Impact for Zero Rated Events are also Published by REL (Doc ID 1526591.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

On Oracle Communications Billing and Revenue Management (BRM), the Rated Event Loader (REL) publishes any monitored balance impact data to the monitor queue for 0 rated Call Data Records (CDRs).

The customer needs these to load into the events tables but not in the MONITOR_QUEUE_T as the data in the queue becomes huge.  As a result pin_monitor_balance becomes very slow since it does an "order by" on CREATED_T.

Scenario:

1.  Enable the Balance Monitoring
2.  Create a Product with /service/telco/gsm/telephony to rate TEL usage
3.  Create a Discount that will consume all the usage
4.  Create an Account using the above plan, that contains both the product and the discount.
5.  While creating the Account, set up Balance Monitoring in the Account with below setup for example:

Monitor Type: Paying Responsibility
Credit Limit: 10
Credit Floor: 0
Threshold: 5%

6.  Pass a CDR with a duration of usage that will breach the threshold. The CDR is zero rated as all the charges are consumed by the Discount.
7.  Run pin_rel to load the rated output file
8.  The MONITOR_QUEUE_T table gets updated

Expected:

REL should not update the MONITOR_EVENT_T for zero rated CDRs.

Cause

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
Symptoms
Cause
Solution
References


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