This chapter explains how to install Oracle Communications Billing and Revenue Management (BRM) reports that are implemented with Oracle Business Intelligence (BI) Publisher 11g and 10g.
Note:
Running reports and generating invoices with BI Publisher 11g running on Windows is not supported.For an overview of BRM reports, see "About BRM Reports".
To set up your system to run BRM reports with BI Publisher, perform the following tasks:
To set up BI Publisher software, you need the following:
For Windows operating systems, Windows administrator privileges on the computer where you install BI Publisher. Administrators can assign user rights. Depending on the rights administrators give to themselves and to others, users can design and customize reports or schedule reports to run.
A BI Publisher Enterprise license
For BI Publisher 11g only: stop the server on which Oracle WebLogic server is running before installing BI Publisher 11g.
To install BI Publisher, follow the instructions in the BI Publisher documentation.
Note:
For BI Publisher 11g, before installing BRM Reports, verify if 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 because the required version of the BIPExtension.jar file is installed when you install BRM Reports.The following information describes how to set the BI Publisher home environment variable.
For BI Publisher 10g only: set the BI Publisher 10g home environment variable in Windows:
Right-click My Computer, and select Properties.
On the Advanced tab, click Environment Variable.
In the System Variable section, click New.
In the Variable name field, enter BIP_Home.
In the Variable value field, enter the path where the BI Publisher server is installed.
Click OK.
In the Environment Variables dialog box, click OK.
In System Properties dialog box, click OK.
To set the BI Publisher Home environment variable on Solaris, Linux, and AIX, run the following command:
setenv BIP_Home BIP_server_path
where BIP_server_path is the directory in which the BI Publisher software is installed.
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.
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.
To install BRM Reports, perform the following tasks:
Caution:
You need to install BRM base reports before you can install any other reports.For BI Publisher 10g only: to install BRM base reports:
Create a temporary directory (temp_dir).
Go to the My Oracle Support Web site:
Sign in with your user name and password.
Click the Patches & Updates tab.
From the list, select Patch Name or Number.
In the text field, enter 16429299 and click Search.
The Patch Search Results page appears.
Click the patch name.
The patch details appear.
From the Platform list, select the platform and click Download.
The File Download dialog box appears.
Download the appropriate p16429299_750_platform.zip software pack to temp_dir, where platform is WINNT.
Unzip the p16429299_750_platform.zip file.
Go to temp_dir and run the following command:
7.5PS4_BIP_BRM_Base_Reports_10g_platform_32_opt.exe
The Installation Wizard appears.
Click Next.
In the next screen do one of the following:
If you are installing BRM base reports for the first time:
Select Full Installation.
This installs the .rtf, .xdo, and .source files, and the BI Publisher utility file, BIPExtension.plb.
Follow the instructions in "Loading the BI Publisher Utility File".
If you are not installing BRM base reports for the first time, do one of the following:
To install only BRM base reports, select Reports only.
This installs the .rtf, .xdo, and .source files.
To install libraries without overwriting customized reports, select Libraries only.
This installs the BI Publisher utility file, BIPExtension.plb.
Note:
You must upload the .source files that are in the StoredProcedures folder to the database after the base reports are installed. For more information about loading stored procedures see "Loading Stored Procedures".Execute the source files with SQL*Plus before you use reports in BI Publisher.
To install BRM base reports:
Create a temporary directory (temp_dir).
Go to the My Oracle Support Web site:
Sign in with your user name and password.
Click the Patches & Updates tab.
From the list, select Patch Name or Number.
In the text field, enter 16429299 and click Search.
The Patch Search Results page appears.
Click the patch name.
The patch details appear.
From the Platform list, select the platform and click Download.
The File Download dialog box appears.
Download the appropriate p16429299_750_platform.zip software pack to temp_dir, where platform is linux, aix, hpux_ia64, or solaris.
Unzip the p16429299_750_platform.zip file.
Go to temp_dir and enter one of the following command:
For BI Publisher 10g:
7.5PS4_BIP_BRM_Base_Reports_10g_platform_32_opt.bin -console
For BI Publisher 11g:
7.5PS4_BIP_BRM_Base_Reports_platform_32_opt.bin -console
Follow the instructions displayed during installation.
BRM base reports and BRM base libraries are installed.
Execute the source files by using SQL*Plus in the BRM environment before using reports in BI Publisher. For BI Publisher 11g, the source files are located in: BIP_HOME/user_projects/domains/bifoundation_domain/config/bipublisher/repository/Reports/BRM_Reports/Base_BRM_Reports/StoredProcedures.
The following post-installation tasks are only applicable to BI Publisher 11g:
Restart Oracle WebLogic Server.
Log in to BI Publisher 11g.
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:
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.
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/config/bipublisher/repository/Reports to your custom directories.
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 user_name/password@Database_Name
where:
user_name is your user name.
password is your password.
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.
The following information describes how to install BRM reports for optional managers.
To install BRM reports for optional managers:
Back up any BI Publisher Reports .rtf, .xdo, and .source files that you customized. If you do not, your customized report files will be overwritten.
Create a temporary directory (temp_dir).
Go to the My Oracle Support Web site:
Sign in with your user name and password.
Click the Patches & Updates tab.
From the list, select Patch Name or Number.
In the text field, enter 16429299 and click Search.
The Patch Search Results page appears.
Click the patch name.
The patch details appear.
From the Platform list, select the platform and click Download.
The File Download dialog box appears.
Download the appropriate p16429299_750_platform.zip software pack to temp_dir, where platform is WINNT.
Unzip the p16429299_750_platform.zip file.
Go to temp_dir and run the following command:
7.5PS4_BIP_BRM_Base_Reports_10g_platform_32_opt.exe
The Installation Wizard appears.
During installation, you must select Reports only.
This installs the.rtf, xdo, and source files.
Execute the source files with SQL*Plus before you use reports in BI Publisher.
To install BRM reports for optional managers:
Create a temporary directory (temp_dir).
Go to the My Oracle Support Web site:
Sign in with your user name and password.
Click the Patches & Updates tab.
From the list, select Patch Name or Number.
In the text field, enter 16429299 and click Search.
The Patch Search Results page appears.
Click the patch name.
The patch details appear.
From the Platform list, select the platform and click Download.
The File Download dialog box appears.
Download the appropriate p16429299_750_platform.zip software pack to temp_dir, where platform is linux, aix, hpux_ia64, or solaris.
Unzip the p16429299_750_platform.zip file.
Go to temp_dir and enter one of the following command:
For BI Publisher 10g:
7.5PS4_BIP_BRM_Base_Reports_10g_platform_32_opt.bin -console
For BI Publisher 11g:
7.5PS4_BIP_BRM_Base_Reports_platform_32_opt.bin -console
Follow the instructions displayed during installation.
Execute the source files by using SQL*Plus in the BRM environment before using reports in BI Publisher. For BI Publisher 11g, the source files are located in: BIP_home/user_projects/domains/bifoundation_domain/config/bipublisher/repository/Reports/BRM_Reports/Base_BRM_Reports/StoredProcedures.
If you are using a custom BI Publisher server setup, do the following:
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.
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/config/bipublisher/repository/Reports to your custom directories.
Caution:
Do not uninstall BRM base reports before uninstalling all other reports.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.
To uninstall BRM reports:
Do one of the following to start the uninstaller:
(Windows 8.1) Use the Windows uninstall feature.
(Other Windows versions) From the start options, select Uninstall Portal Report_name, which is under Portal or use the Windows uninstall feature, where Report_name is the report you want to uninstall.
Do one of the following:
To uninstall a complete report:
Click Report_name.
Select View Components only.
Click Uninstall.
To uninstall individual components of a report:
Click Report_name.
Select View Components and Features.
Select the individual component.
Click Uninstall.
Click Finish.
To uninstall BRM reports for optional managers:
To uninstall BRM optional reports with BI Publisher 11g, enter the following command:
BIP_Home/uninstaller/BIP_BRM_OptionalMgr_Reports/uninstaller.bin
To install BRM optional reports with BI Publisher 10g, enter the following command:
BIP_BRM_OptionalMgr_Reports/uninstaller.bin -console
To uninstall BRM base reports with BI Publisher 11g, enter the following command:
BIP_Home/uninstaller/BIP_BRM_Base_Reports/uninstaller.bin
To uninstall BRM base reports with BI Publisher 10g, enter the following command:
BIP_BRM_Base_Reports/uninstaller.bin -console