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.
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.
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.
|
The batch type numbers. Default: not specified |
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.
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.
|
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 |
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.
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:
Note
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:
Default: Regular |
Split method |
Specifies whether to collect summary data from revenue assurance objects that contain or do not contain split revenue assurance data:
For more information, see "About the Split Method Parameter". |
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 |
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.
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.
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:
Default: Regular |