1. Configuring Pipeline Rating and Discounting
  2. Pipeline Manager Reference
  3. Revenue Assurance Manager Reports

92 Revenue Assurance Manager Reports

This chapter describes the Oracle Communications Billing and Revenue Management (BRM) reports that support batch rating-related Revenue Assurance Manager features.

Revenue Assurance Rating Summary Report

Note:

You must upload the RevAssuranceRating.source file that is in the StoredProcedures folder to the database after the report is installed.

The Revenue Assurance Rating Summary report (RevAssuranceRatingSummary.rtf) shows revenue assurance data collected from pipeline rating. This report returns information for a specified time period.

There are different subreports created for different rating /process_audit objects.

The SQL query for this report is in the BIP_home\xmlp\XMLP\Reports\BRM Reports\Revenue Assurance Reports\StoredProcedures\RevAssuranceRating.source file, where BIP_home is the directory in which Oracle Business Intelligence (BI) Publisher is installed.

No charts are available for this report.

Revenue Assurance Rating Summary Report Parameters

You can change the following parameters to modify the output of the Revenue Assurance Rating Summary report:

  • Start Date (process start date or date-time)

  • End Date (process end date or date-time)

  • Trans Start Date (transaction start date or date-time)

  • Trans End Date (transaction end date or date-time)

  • Flow

  • Control Point

  • Service Type

    Note:

    If you want to generate a report for the service types that are not in the list of the default service types, add the service type in the list of values in BI Publisher. For more information on adding the list of values, see the BI Publisher documentation.

  • Batch Type

Table 92-1 Revenue Assurance Rating Summary Parameters

Parameter Description Valid Values

Flow

A collection of linked control points in a pipeline.

Any valid flow name. Default: not specified

Control point

An instance of FCT_AggreGate that you configure in your pipeline to collect revenue assurance data.

For example, CP_Afterrating.

Any valid control point names or ALL. Default: ALL

Service Type

A commodity sold by your company and that your customers can purchase and use.

For example, SMS or TEL.

Any valid service type names. Default: not specified

Batch Type

The type of batch that the EDRs belong to.

  • 0 for normal

  • 1 for rerating

  • 2 for recycling

  • 3 for write-off

The batch type numbers. Default: not specified

Revenue Assurance Rating Detail Report

Note:

You must upload the RevAssuranceRating.source file that is in the StoredProcedures folder to the database after the report is installed.

The Revenue Assurance Rating Detail report (RevAssuranceRatingDetail.rtf) shows detailed statistics for the revenue assurance data collected from pipeline rating. By default, the statistics are organized by EDR status. For each status, this report displays the following:

  • Volume sent

  • Volume received

The SQL query for this report is in the BIP_home\xmlp\XMLP\Reports\BRM Reports\Revenue Assurance Reports\StoredProcedures\RevAssuranceRating.source file, where BIP_home is the directory in which BI Publisher is installed.

No charts are available for this report.

Revenue Assurance Rating Detail Parameters

You can change the following parameters to modify the output of the Revenue Assurance Rating Detail report:

  • Start Date (process start date or date-time)

  • End Date (process end date or date-time)

  • Trans Start Date (transaction start date or date-time)

  • Trans End Date (transaction end date or date-time)

  • Flow

  • Control Point

  • Service Type

  • Batch Type

  • Batch ID

  • Successful records

  • Failed records

  • Written Off records

  • Dynamic Data

  • Revenue Assurance Scope

Table 92-2 Revenue Assurance Rating Detail Parameters

Parameter Description Valid Values

Flow

A collection of linked control points in a pipeline. For example, Flow1.

Important: This field is mandatory.

Any valid flow name. Default: not specified

Control point

An instance of FCT_AggreGate that you configure in your pipeline to collect revenue assurance data.

For example, CP_Afterrating.

Important: This field is mandatory.

Any valid control point names or ALL. Default: ALL

Service Type

A commodity sold by your company and that your customers can purchase and use.

For example, SMS or TEL.

Any valid service type names. Default: not specified

Batch Type

The type of batch that the EDRs belong to.

  • 0 for normal

  • 1 for rerating

  • 2 for recycling

  • 3 for write-off

The batch type numbers. Default: not specified

Batch ID

Batch ID of the EDRs.

For example, MED1 or MED2.

Important: This field is mandatory.

Any valid batch ID. Default: not specified

Successful Records

The status of successful EDRs.

The name given to define the successful EDRs in pipeline rating. Default: Successful

Failed Records

The status of failed EDRs.

The name given to define the failed EDRs in pipeline rating. Default: Suspense

Written Off Records

The status of written-off EDRs.

The name given to define the written-off EDRs in pipeline rating. Default: Written-off

Dynamic Data

Determines whether the revenue assurance data is dynamic or static. Select YES to show dynamic data. Select NO to display static data.

The static data displays data on the call data records (CDRs) rated from the mediation batches. The dynamic data displays data on the CDRs that are rejected, recycled, or rerated.

YES or NO. Default: NO

Revenue Assurance Scope

Refers to the Batch Type parameter.

Batch rating or rerating. Default: not specified