1. Reports
  2. About BRM Reports

1 About BRM Reports

This document provides an overview of Oracle Communications Billing and Revenue Management (BRM) Reports implemented with Oracle Business Intelligence (BI) Publisher.

Topics in this document:

About BRM Reports

BRM Reports is a set of report templates that you can use to track customer activity and billing. These templates are designed to be used with a BRM database and BI Publisher.

You can display and print report results in tabular text format, a chart, or both. You can also save reports to disk, convert reports to Portable Document Format (PDF) or Rich Text Format (RTF), and display reports on HTML Web pages, all with BI Publisher. BI Publisher also supports XML data format.

The BRM reports are distributed in the following packages:

  • BRM base reports include reports about accounts receivables, credit card usage, general ledger, and tax calculation. See "BRM Base Reports".

  • MultiDB Manager reports retrieve and display A/R data from more than one BRM database schema in the same report. See "Running Reports against Multiple Schemas".

  • Number Manager reports support Number Manager. You use this report to track number inventory and information relating to tracking telephone numbers. See "Number Manager Reports".

  • Revenue Assurance reports support Revenue Assurance Manager. You use them to track revenue assurance data collected by auditing the results of billing operations.

  • SIM Manager reports support SIM (Subscriber Identity Module) Manager. You use these reports to track the status of SIM cards you have ordered and the state of SIM cards currently in inventory. See "SIM Manager Reports".

  • Suspense Manager reports support the standard recycling and Suspense Manager features. You use them to track suspended call records, processed by Suspense Manager for a specific time period, and those with a status of written-off.

  • Wireless access service reports support GPRS Manager. You use them to track usage and error information for your General Packet Radio Service (GPRS) services. See "Wireless Reports".

  • Collections Manager reports support Collections Manager, which you use to manage in-house debt collections. See "Collections Manager Reports".

  • Voucher inventory management reports support Voucher Manager. You use them to track what vouchers are in the system. See "Voucher Manager Reports".

    Important: Voucher Manager is deprecated and supported only for backward compatibility. Use Oracle Communications Convergent Charging Controller to manage vouchers.

About Customizing BRM Reports

Each report template includes a set of parameters that determines what data is extracted from the BRM database and how that data is displayed in the report output. To tailor the output for your needs, you specify values for the parameters when you run reports.

In addition, if you have BI Publisher design privileges and structured query language (SQL) experience, you can customize the report templates. For example:

  • You can change the values in parameter lists, and you can add parameters to or delete them from the templates.

  • You can convert dates, decrypt credit card numbers, and localize report input and output.

  • You can automatically list output from several BRM database schemas in one report.