Go to main content
1/19
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
Scripting on this page enhances content navigation, but does not change the content in any way.