BIP RA Rating Detailed Report Not Working When Using Multiple Control Points Or Rating Flows As Input

(Doc ID 2123809.1)

Last updated on JANUARY 05, 2017

Applies to:

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

Symptoms

On : 7.5.0.8.0 version, Revenue Assurance Manager

When running the detailed and summary rating reports and as per the specs, Customer can use multiple rating flows and control points. In fact, if User use wildcards like *, it is observed that BIP frontend translates that into ALL, which is used as input for the queries. However, the queries failed in those case. Same thing applies when User use more than one rating flow or control point separated by commas as per the specs.

User only manages to run it when 1 control point and 1 rating flow are set, which means that one would need 22 separated reports to understand what happened to the Usage by using RA reports. Customer has 10 schemas + 1 router and have set up 1 control point in the input and output of the pipelines.

The RA data seems fine and Customer is running queries to check that files are processed and what happens with EDRs throughout the rating chain. Customer is using the template based on status to generate the data, but the reports in RA don’t seem very useful.

As per the specs, RA rating reports would allow using multiple rating flows and control points when invoking the reports, by using comma separated values. But the behavior is different and the queries are failing to behave as expected. This has an operational impact in the client as they would have to schedule 22 reports instead of one and relate the corresponding results, which is not what was expected and desired.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms