9 Revenue Assurance Manager Reports

This chapter describes the Oracle Communications Billing and Revenue Management (BRM) reports that support Revenue Assurance Manager, which you use to collect revenue assurance data generated by running billing or the processing event data records (EDRs) through the pipeline.

For general information on how to run reports, see "Running BRM Reports".

For information about Revenue Assurance Manager, see "Understanding Revenue Assurance Manager" in BRM Collecting Revenue Assurance Data.

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. For more information about loading stored procedures, see "Loading Stored Procedures".

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

For information on parameters not described in Table 9-1, see "Understanding the Standard Parameters".

Table 9-1 Revenue Assurance Rating Summary Parameters

Parameter Description Valid Values

Flow

A collection of linked control points in a pipeline.

For details, see "About Flows" in BRM Collecting Revenue Assurance Data.

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 details, see "About Control Points" in BRM Collecting 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. For more information about loading stored procedures, see "Understanding the Standard Parameters".

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

For information on parameters not described in Table 9-2, see "Understanding the Standard Parameters".

Table 9-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


Revenue Assurance Billing Summary Report

Note:

You must upload the RevAssuranceBilling.source file that is in the StoredProcedures folder to the database after the report is installed. For more information about loading stored procedures, see "Loading Stored Procedures".

The Revenue Assurance Billing Summary report (RevAssuranceBillingSummary.rtf) shows summary information on the revenue assurance data collected from billing for a specified time period.

The report shows the number of successfully billed records, the number of records that failed to be billed, and the revenue associated with successfully billed records.

Depending on the parameters you select for the report, the report can also categorize and display revenue data by the billing day of month (DOM) and the billing segment and show the count of bills suppressed, the revenue associated with suppressed bills, and the accounts that failed to be billed and their associated error codes.

Note:

A summary of the revenue assurance data collected from billing by billing segments is available from control points in pin_bill_accts only.

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

No charts are available for this report.

Revenue Assurance Billing Summary Report Parameters

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

  • Start date (date or date-time)

  • End date (date or date-time)

  • Control Point

  • DOM

  • Segment

  • Billing method

  • Split method

For information on parameters not described in Table 9-3, see "Understanding the Standard Parameters".

Table 9-3 Revenue Assurance Billing Summary Parameters

Parameter Description Valid Values

Control Point

The billing utilities that collect the revenue assurance data.

Any one of the following values:

  • Invoice Generated

  • Revenue Collected

  • Scheduled Deferrals Executed

  • Cycle Fees Generated

  • NONE

Note

  • The report header will display Control Point only if the value selected is not NONE.

  • If the value selected is not NONE, the values of Billing Method, Split Method, and DOM are irrelevant.

Default: NONE

DOM

The day of the month on which billing is run.

This parameter is required when you display split revenue assurance data in the report (when the value of the Split method parameter is 1).

Note: If the value of the Split method parameter is 0, the DOM value is ignored because the DOM is always specified as 0 in revenue assurance objects that do not contain split data.

For more information, see "About the Split Method Parameter".

For a specific DOM, from 0 to 31.

Default: 0

SEGMENT

The billing segment for which billing is run.

This parameter is required when you display split revenue assurance data in the report (when the value of the Split method parameter is 1).

Note: If the value of the Split method parameter is 0, the SEGMENT value is ignored because the billing segment is always specified as 0 in revenue assurance objects that do not contain split data.

For more information, see "About the Split Method Parameter".

Any numeric value that represents a specific billing segment.

Default: 0

Billing method

The billing method for which billing is run.

Any one of the following values:

  • Regular

  • Trial

  • Bill Now

  • Bill on demand

  • Auto Triggered

  • All out of cycle bills

  • ALL (includes all billing methods except Trial.)

Default: Regular

Split method

Specifies whether to collect summary data from revenue assurance objects that contain or do not contain split revenue assurance data:

  • If billing method is Bill Now, Bill on demand, Auto Triggered, or All out of cycle bills, specify 1 as the split method. These billing methods all contain split revenue assurance data.

  • If billing method is Regular, Trial, or ALL, you can specify either 1 or 0.

For more information, see "About the Split Method Parameter".

  • 0 - Collects summary data only from revenue assurance objects that do not contain split data.

  • 1 - Collects summary data only from revenue assurance objects that contain split data.

Note: For summary reports from all revenue assurance objects, with and without split data, generate two reports: one for each Split method value.

Default: 1


About the Split Method Parameter

When billing generates revenue assurance data that is split into detailed categories, the split data (along with other revenue assurance data) is stored in the revenue assurance objects (/process_audit/billing objects).

Split revenue details have been stored in revenue assurance objects starting with Revenue Assurance Manager release 3.0. Revenue assurance objects prior to this release do not contain split revenue details.

The Split method parameter specifies whether to collect summary data from revenue assurance objects that contain split revenue assurance data or do not contain split revenue assurance data. BRM uses this parameter to determine whether it needs to filter the split data to report only summary data.

The Split method parameter can take one of these values, which you specify when running the report:

  • Select 1 to collect summary data only from revenue assurance objects that contain split data.

    If you select 1 as the split method, the summary report categorizes and displays the data by the billing day of month (DOM) and billing segment, which you specify as report parameters.

    Note:

    • If you ran billing or trial billing for a limited number of accounts and bill units, the summary report does not categorize the data by segment and DOM and displays 0 for the segment and DOM values. This is because BRM can retrieve the accounts and bill units directly and does not use the segment or DOM for searching the database.

    • You run billing or trial billing for a limited number of accounts by specifying the -file parameter when you run the pin_bill_accts utility or by specifying the -f or -f_control parameter when you run the pin_trial_bill_accts utility. For more information, see "Billing Only Specified Accounts and Bill Units" and "Running Trial Billing" in BRM Configuring and Running Billing.

    When Split method is 1, the following information is included in the summary report:

    • The number of successfully billed accounts.

    • The number of accounts that failed to be billed.

    • The total revenue associated with successfully billed accounts.

    • The count of suppressed bills.

    • The revenue associated with suppressed bills.

    • The accounts and bill units that failed to be billed and their associated error codes.

  • Select 0 to collect summary data only from revenue assurance objects that do not contain split data.

    If you select 0 as the split method, the summary report does not categorize the data by DOM and billing segment. This is because the value of the DOM and billing segment are always 0 in revenue assurance objects that do not contain split data.

    When Split method is 0, the following information is displayed in the report:

    • The number of successfully billed accounts.

    • The number of accounts that failed to be billed.

    • The total revenue associated with successfully billed accounts.

    • The accounts and bill units that failed to be billed and their associated error codes.

The Revenue Assurance Billing Summary report will be blank in the following cases:

  • You select 0 and all revenue assurance objects contain split data.

  • You select 1 and no revenue assurance objects contain split data.

If you have some revenue assurance objects that contain split data and some that do not contain split data, you can generate a summary for all revenue assurance objects by running the summary report twice: once for each Split method value.

Revenue Assurance Billing Detail Report

Note:

You must upload the RevAssuranceBilling.source file that is in the StoredProcedures folder to the database after the report is installed. For more information about loading stored procedures, see "Loading Stored Procedures".

The Revenue Assurance Billing Detail report (RevAssuranceBillingDetail.rtf) shows detail information on the revenue assurance data collected from the billing utilities for a specific or a range of DOMs and segment values for a specified time period.

The report shows the DOM, segment, error accounts, error code associated with error accounts, successfully billed records, failed billed records, revenue associated with successfully billed records split by the item and service type, count of bills suppressed, and revenue associated with suppressed bills.

Note:

Summary of the revenue assurance data collected from billing (for example, number of records billed or number of records failed) by billing segment is available for pin_bill_accts (anticipated revenue) control points only.

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

No charts are available for this report.

Revenue Assurance Billing Detail Report Parameters

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

  • Start Date (date or date-time)

  • End Date (date or date-time)

  • DOM

  • Segment

  • Billing method

For information on parameters not described in Table 9-4, see "Understanding the Standard Parameters".

Table 9-4 Revenue Assurance Billing Detail Parameters

Parameter Description Valid Values

DOM

The date of the month on which billing is run.

From 1 to 31. Default: not specified

Segment

The billing segment for which billing is run.

Any numeric value. Default: not specified

Billing method

The billing method for which billing is run.

Any one of the following values:

  • Regular

  • Trial

  • Bill Now

  • Bill on demand

  • Auto Triggered

  • All out of cycle bills

  • ALL (includes all billing methods except Trial.)

Default: Regular