Installing BRM Reports

2 Installing BRM Reports

This document explains how to install Oracle Communications Billing and Revenue Management (BRM) reports that are implemented with Oracle Business Intelligence (BI) Publisher 12c.

Note:

Running reports and generating invoices with BI Publisher 12c running on Windows is not supported.

Topics in this document:

Installation Overview

To set up your system to run BRM reports with BI Publisher, perform the following tasks:

Installing and Configuring BI Publisher

To set up BI Publisher software, you need a BI Publisher Enterprise license.

Stop Oracle WebLogic Server

For BI Publisher 12c only: stop the server on which Oracle WebLogic server is running before installing BI Publisher 12c.

Installing BI Publisher

To install BI Publisher, follow the instructions in the BI Publisher documentation.

Note:

For BI Publisher 12c, after installing BRM Reports, verify that the BIP_home/file_location/BIPExtension.jar file is installed, where BIP_home is the directory in which BI Publisher is installed. If the BIPExtension.jar file is installed, you must manually move the file to a directory that is not included in the CLASSPATH. This is necessary because the required version of the BIPExtension.jar file is installed when you install BRM Reports.

Configuring a JDBC Data Source

By default, the reports are configured to run against a JDBC data source named BRM_DATA_SOURCE. See “Setting up Data Sources" in the BI Publisher documentation for information about configuring a JDBC data source on your system.

Configuring Run-Time Properties

You need to configure run-time properties to allow BI Publisher to refer to external references such as plug-ins.

To configure run-time properties:

Follow the instructions in "Accessing BI Publisher".
Click the Admin tab.
Under Runtime Configuration, click the Properties link.
From the Disable external references list, select False.
Click Apply.

Installing and Configuring BRM Reports

To install BRM Reports, perform the following tasks:

Installing BRM Base Reports. See "Installing Individual BRM Components" in BRM Installation Guide for more information.

Caution:

Ensure that you install BRM base reports before you can install any other reports.
Restart Oracle WebLogic Server.
Log in to BI Publisher 12c.

If BRM reports are not visible, your report repository is pointing to an incorrect location. See the BI Publisher documentation for more information.
If you are using a custom BI Publisher server setup, do the following:
1. Copy the BIP_home/user_projects/domains/bifoundation_domain/servers/AdminServer/tmp/WebLogic_user/bipublisher_11.1.1/6uc731/lib/BIPExtension.jar file to your domain lib directory.
2. Stop and restart the Oracle WebLogic Server, which adds the BIPExtension.jar file to the Oracle WebLogic server classpath and enables the BI Publisher extension library.
If you are using custom paths, copy the BRM-BI Publisher template files from BIP_home/user_projects/domains/bifoundation_domain/components/bipublisher/repository/Reports/BRM_Reports to your custom directories.
Load the BI Publisher utility file. See "Loading the BI Publisher Utility File" for more information.
Installing BRM Reports for Optional Managers. See "Installing Individual BRM Components" in BRM Installation Guide for more information.
Run the source files by using SQL*Plus in the BRM environment before using reports in BI Publisher. For BI Publisher 12c, the source files are located in: BIP_home/user_projects/domains/bifoundation_domain/components/bipublisher/repository/Reports/BRM_Reports/Base_BRM_Reports/StoredProcedures.
If you are using a custom BI Publisher server setup, do the following:
1. Copy the BIP_home/user_projects/domains/bifoundation_domain/servers/AdminServer/tmp/WebLogic_user/bipublisher_11.1.1/6uc731/lib/BIPExtension.jar file to your domain lib directory.
2. Stop and restart the Oracle WebLogic Server, which adds the BIPExtension.jar file to the Oracle WebLogic server classpath and enables the BI Publisher extension library.
If you are using custom paths, copy the BRM-BI Publisher template files from BIP_home/user_projects/domains/bifoundation_domain/components/bipublisher/repository/Reports/BRM_Reports to your custom directories.

Loading the BI Publisher Utility File

Open a command window and enter the following command:

cd local_drive:\BIP_home\BRM Reports\Utils\StoredProcedures

where BIP_home is the directory in which BI Publisher is installed.
At the prompt, enter the following command, which opens SQL*Plus:
```
sqlplus/@database_name
```
where database_name is the service name or database alias of the Oracle database.
At the SQL prompt, enter the following command:
```
@BIPExtension.plb
```
The BIPExtension.plb file is loaded into Database_Name.

The BI Publisher utility file includes functions that you can use to customize reports.
Quit SQL*Plus, and close the command window.

Uninstalling BRM Reports

Caution:

If you are uninstalling reports, you must uninstall all the BRM reports (BRM base reports and other reports for optional managers) installed. You cannot choose and uninstall any individual report from the list.

When you uninstall BRM base reports, the SubTemplates folder is deleted and all the reports that use the sub-template-parameters.rtf file will not display the correct data.

Complete the procedure for the appropriate operating system.

Uninstalling BRM Reports

To uninstall BRM Reports on Solaris and Linux:

Go to the BRM_home/oui/bin directory.
Run the following command:
```
./deinstall.sh
```
The Distribution to Uninstall screen appears.
Select all the BRM reports.
Click Next.

The Welcome screen appears.
Click Next.

The Uninstallation Summary screen appears.
Click Uninstall.

The Uninstallation Progress screen appears.
Click Next.

The Uninstallation Complete screen appears.
Click Finish.