Contents

Title and Copyright Information

Preface

• Audience
• Downloading Oracle Communications Documentation
• Documentation Accessibility
• Document Revision History

1 About BRM Reports

• Introducing BRM Reports
• About the BRM Reports Packages
• About Customizing BRM Reports

2 Installing BRM Reports

• Installation Overview
• Installing and Configuring BI Publisher
  • Stop Oracle WebLogic Server
  • Installing BI Publisher
  • Setting the BI Publisher Home Environment Variable
    • Setting the BI Publisher Home Environment Variable on Windows
    • Setting the BI Publisher Home Environment Variable on Solaris, Linux, and AIX
  • Configuring a JDBC Data Source
  • Configuring Run-Time Properties
• Installing BRM Reports
  • Installing BRM Base Reports
    • Installing the BRM Base Reports on Windows
    • Installing the BRM Base Reports on Linux, Solaris, and AIX
  • Configuring Post-Installation Tasks
  • Loading the BI Publisher Utility File
  • Installing BRM Reports for Optional Managers
    • Installing BRM Reports for Optional Managers on Windows
    • Installing BRM Reports on Linux, Solaris, and AIX
• Uninstalling BRM Reports
  • Uninstalling BRM Reports on Windows
  • Uninstalling BRM Reports for Linux, Solaris, and AIX

3 Running BRM Reports

• Selecting BI Publisher
• Understanding the Standard Parameters
• Specifying Time Ranges
  • Minute Ranges
  • Hour Ranges
  • Day Ranges
• Specifying Dates
  • Year Specifications
  • Start and End Date Specifications
  • Current Date Specifications
• Using the SQL Queries
• Identifying Report Versions
• Loading Stored Procedures
• Loading a List of Values

4 Customizing BRM Reports in Business Intelligence Publisher

• Redefining Report Parameters
  • Accessing BI Publisher
  • Adding Parameters in BI Publisher
    • Adding Promotion Code and Software Package Parameters
    • When to Modify Formulas for New Values
  • Adding Parameters to the Report Template
    • Preprocessing Parameters Whose Data Type Changes
    • Using Parameters Whose Data Type Does Not Change
    • Adding Parameters to the Report Layout
  • Uploading the Template
    • Editing a Formula
  • Removing Parameters in BI Publisher
  • Removing Parameters from the Report Layout
• Using the BIPExtension Class
  • Date Functions
    • infStrToTimet (java.lang.String DateString, int nFlag)
    • infTimetToStr (int lTimeIn, int nFlag)
  • Currency Functions
    • infPutBeidBalanceStr (int, string)
    • infGetBeidBalanceStr (int)
  • Decryption Functions
    • void cryptInit (String aesKeys, String md5Key)
    • String decryptData (String cipherData)
  • Converting Dates
    • Converting BI Publisher Date Format to BRM Date Format
    • Converting BRM Date Format to BI Publisher Date Format
  • Reading Different Resources
  • Decrypting Data
    • Decrypting and Displaying AES and MD5-Encrypted Data
    • Decrypting and Displaying MD5-Encrypted Data Only
• Designing a Report Layout
• Localizing BRM Reports
• Running Reports against Multiple Schemas
  • Configuring JDBC Data Sources for Multiple Schemas
  • Modifying Reports to Run against Multiple Schemas

5 BRM Base Reports

• Accounts Receivable Reports
  • Accounts Receivable Summary Report
    • ARSummary Parameters
  • Accounts Receivable Detail Report
    • ARDetail Parameters
  • Payments Summary Report
    • PaymentsSummary Parameters
  • Payments Detail Report
    • PaymentsDetail Parameters
  • Reversals Summary Report
    • ReversalsSummary Parameters
  • Reversals Detail Report
    • ReversalsDetail Parameters
  • Refunds Summary Report
    • RefundsSummary Parameters
  • Refunds Detail Report
    • RefundsDetail Parameters
  • Bad Debt Write-Offs Report
    • BadDebtWriteOff Parameters
• Credit Card Reports
  • Credit Card Charges or Declines Report
    • CCChgDecl Parameters
  • Credit Cards Due to Expire Report
    • CCExpire Parameters
  • Credit Card Transactions Report
    • CCTransactions Parameters
• Customer Account Reports
  • Account Changes - Single Time Period Report
    • NCSinglePeriod Parameters
  • Account Changes – Multiple Time Periods Report
    • NCMultiplePeriods Parameters
  • New Account Lifetime Report
    • NewLifetime Parameters
  • Closed Account Lifetime Report
    • ClosedLifetime Parameters
  • Product Subscriptions Report
    • ProductSubscriptions Parameters
  • Product Cancellations Report
    • ProductCancellations Parameters
• Device Management Framework Reports
  • Device Status Report
    • DeviceStatus Parameters
  • Device History Report
    • DeviceHistory Parameters
• Dialup Usage Reports
  • POP Usage Report
    • SessionPOP Parameters
  • Current Sessions by Session Length Report
    • UsageTimeCurrent Parameters
  • Historic Sessions by Session Length Report
    • UsageTimeHistoric Parameters
  • Dropped Sessions Report
    • DroppedSessions Parameters
• General Ledger Reports
  • General Ledger Chart of Accounts Report
  • General Ledger Summary Report
    • GLSummary Parameters
  • General Ledger Detail Report
    • GLDetail Parameters
  • Product Revenue Report
    • ProductRevenue Parameters
• Miscellaneous Adjustments Reports
  • Miscellaneous Adjustments Summary Report
    • MASummary Parameters
  • Miscellaneous Adjustments Detail Report
    • MADetail Parameters
• Tax Reports
  • Tax Jurisdiction Summary Report
    • TaxJurSummary Parameters
  • Tax Jurisdiction Detail Report
    • TaxJurDetail Parameters
  • Summary of All Taxes Report
    • TaxAllSummary Parameters
  • Tax Exempt Accounts Report
    • TaxExempt Parameters
• Other Reports
  • Price List Report
  • Remittance Report
    • Remittance Parameters

6 Collections Manager Reports

• Collection Report
  • Collection Summary Report
    • Collection Summary Parameters
  • Collection Detail Report
    • Collection Detail Parameters
• CollectionExemptBillinfo Report
  • CollectionExemptBillinfo Summary Report
    • CollectionExemptBillinfo Summary Parameters
  • CollectionExemptBillinfo Detail Report
    • CollectionExemptBillinfo Detail Parameters

7 Content Manager Reports

• Billing Provider Report
  • BillingProvider Parameters
• Content Provider Report
  • ContentProvider Parameters

8 Number Manager Reports

• Number Inventory Management Report
  • Report Type set to NUMBER CATEGORY
  • Report Type set to VANITY NUMBER

9 Revenue Assurance Manager Reports

• Revenue Assurance Rating Summary Report
  • Revenue Assurance Rating Summary Report Parameters
• Revenue Assurance Rating Detail Report
  • Revenue Assurance Rating Detail Parameters
• Revenue Assurance Billing Summary Report
  • Revenue Assurance Billing Summary Report Parameters
    • About the Split Method Parameter
• Revenue Assurance Billing Detail Report
  • Revenue Assurance Billing Detail Report Parameters

10 SIM Manager Reports

• SIM Order Management Report
  • SIMOrderMgmt Parameters
• SIM Card Inventory Management Report
  • SIMCardInventoryMgmt Parameters

11 Suspense Manager Reports

• Suspended EDR Report
  • Suspended EDR Report Parameters
  • Suspended EDR Summary Report
  • Suspended EDR Detail Report
• Written-Off EDR Report
  • Written-Off EDR Report Parameters
  • Written-Off EDR Summary Report
  • Written-Off EDR Detail Report

12 Roaming Manager Reports

• About TAP Roaming Manager Reports
  • About Roaming High-Usage Reports
    • About Roaming High-Usage Summary Report
    • About Roaming High-Usage Detail Report
    • About Roaming High-Usage Notification Report
  • SMS Interworking High-Usage Reports
    • About SMS Interworking High-Usage Summary Report
    • SMS Interworking High-Usage Detail Report
    • About SMS Interworking High-Usage Notification Report
  • Combined Roaming and SMS Interworking High-Usage Reports
    • About Combined Roaming and SMS Interworking High-Usage Summary Report
    • Combined Roaming and SMS Interworking High-Usage Detail Report
    • About Combined Roaming and SMS Interworking High-Usage Notification Report
• Setting Up TAP Roaming Manager Reports
• Running Roaming Manager Reports

13 Voucher Manager Reports

• Voucher Management Reports
  • Voucher Device Management Report
    • Voucher Device Management Parameters
  • Voucher Inventory Management Report
    • Voucher Inventory Management Parameters

14 Wireless Reports

• About General Packet Radio Service Reports
  • GPRS APN Usage Report
    • GPRSAPNUsage Parameters
  • GPRS Product Usage Report
    • GPRSProductUsage Parameters
  • GPRS Error Summary Report
    • GPRSErrorSummary Parameters
  • GPRS Error Detail Report
    • GPRSErrorDetail Parameters
• Understanding Column Totals
  • Accounts with Errors Column
  • Accounts with Usage Column
  • Average Bytes per Session or Event Column
  • Average Session or Event Duration Column
  • Error Duration Column
  • Megabytes Column
  • Total Duration Column

15 SMS Settlement Reports

• SMS Interworking Bulk Data Report
  • SMSinterworkingbulk Parameters

16 Reporting by Brand

• About Reporting by Brand
• Configuring BI Publisher to Support Reporting by Brand
  • Creating a Brand User
  • Viewing Brand-Specific Versions of BRM Reports
• Brand Manager Reports