1. Reporting Interface Guide
  2. Setting Up the Reporting Interface Environment

2 Setting Up the Reporting Interface Environment

This chapter describes how to configure the Oracle Communications Order and Service Management (OSM) Reporting Interface.

For more information about the OSM Reporting Interface, see "About the OSM Reporting Interface".

Overview

To configure the OSM Reporting Interface:

  • Install required supporting software, such third-party reporting application.

  • Connect the third-party reporting application to the OSM Oracle database.

Note:

To configure a third-party reporting application, you need to have familiarity with database configuration. You need to know information such as the database schema names and passwords, and the OSM Reporting Interface views and procedures.

Prerequisites for Configuring the Reporting Interface

Before installing and configuring the OSM Reporting Interface, perform the following tasks on the target system in the order listed:

  • Install the OSM application.

  • Install a third-party reporting application.

Configuring the Reporting Interface Environment

Configure your third-party reporting application. This task may include creating users and creating database connections, assigning stored procedures, and defining parameters. Specifics depend on which reporting application you use.

Creating Users

Some reporting applications require you to create user accounts for each individual who needs to access the Reporting Interface. How you assign privileges to an individual account depends on the duties the individual performs and the policies of your organization.

Refer to the documentation of the your reporting application for instructions on creating users in that application.

Creating Database Connections

After you create users, you may have to configure your reporting application with the appropriate database connections to the OSM database.

About Stored Procedures

Stored procedures give you access to the following reports:

  • Orders (through the OMS_REPORT_ORDERS stored procedure)

  • Order History (through the OMS_REPORT_ORDERS_HISTORY stored procedure)

  • Pending Order At Task (through the OMS_REPORT_PENDING_AT_TASKS stored procedure)

You may have to assign these stored procedures to individual users or groups of users. Refer to the documentation of your reporting application for instructions on how to use the provided stored procedures.

About Views

Oracle views allow you to create the Processes, Tasks, and Notifications reports.

You may have to configure the views through your reporting application, providing information such as a link to the Oracle client, and specifying the views used for OSM reporting. Views include:

  • OMS_REPORT_NOTIFICATIONS

  • OMS_REPORT_PROCESSES

  • OMS_REPORT_TASKS

You may want to specify a parameter range for some of the table columns. For example, you may configure the Start Date parameter so that the column displays only the work that is scheduled to begin the day after the reporting date. Refer to the documentation of the your reporting application for instructions on specifying parameters for views.