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

Last updated on AUGUST 07, 2024

Applies to:

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).

Require 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:

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.

Changes

Cause

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