Application Guide for Oracle Self-Service E-Billing (Consumer Edition) > Analytic Reporting Use Cases >

Viewing the Service Billing Overview Report


This report tracks all of the services monthly charges for one or more service numbers over a user-defined reporting period.

Table 25 lists and describes the Viewing the Service Billing Overview Report use case functions.

Table 25. Viewing the Service Billing Overview Report
Function
Description

Name

Viewing the Service Billing Overview Report

Description

This report tracks all of the services monthly charges for one or more service numbers over a user-defined reporting period.

Feature Area

Analytic Reports

Primary User

Consumer user, CSR hosting administrator

Prerequisites

The user has been successfully enrolled and authenticated.

Trigger Points

The user clicks the Analytics tab, and then clicks the Service Billing Overview link or selects Service Billing Overview from the list.

Standard Features

  • Printer-Friendly view
  • Download CSV or XML

Report Content

Header:

  • Service Charges
  • Number of Items

Columns:

  • Service Number
  • Name
  • Monthly Charges
  • Usage Charges
  • Credits
  • Other Charges
  • Taxes
  • Total (Sort Most Expensive First)
  • T (Hyperlinks to Service Billing Trend for the Service Number within the corresponding row)

Footer (Total Row):

  • Total - Literal
  • Monthly Charges
  • Usage Charges
  • Credits
  • Other Charges
  • Taxes
  • Total
  • T (Hyperlinks to Service Billing Trend for all Service Numbers)

Configuration Points

  • Report Threshold Value for Batch Mode. Determines the number of result set lines above which a report must process in batch mode instead of as an online download. You can set values for each type of download file:
    • CSV. The maximum number of output lines.
    • XML. A percentage of the CSV threshold value (default is 20%).

      For example, if the CSV report threshold is set to 3,000 result set lines, then an XML threshold value set at 20% must process in batch mode when it has 600 or more result set lines.

  • All report detail columns are sortable.

Business Rules

None

Functions

The user can submit a batch request for this report.

Main Path for Viewing the Service Billing Overview Report

The main path to view the Service Billing Overview report is as follows:

1 The user selects the report from the List of Billing Reports.
  1. Oracle Self-Service E-Billing determines the query parameters according to report context or default values and displays the report.

Alternate Paths for Viewing the Service Billing Overview Report

Alternate paths can occur in this use case.

The user clicks an active link

Oracle Self-Service E-Billing displays the List of Standard Reports.

The user clicks an active page tab for the active report or to request a batch report

Oracle Self-Service E-Billing displays the selected page.

The user clicks the Download action

Oracle Self-Service E-Billing downloads the report.

The user clicks the Printer-Friendly action

Oracle Self-Service E-Billing invokes Printer-Friendly use case.

The user changes reporting period

Oracle Self-Service E-Billing displays the report for the new period.

The user selects a different report

Oracle Self-Service E-Billing displays the selected report.

Exceptions for Service Billing Overview Report

Exceptions can occur with this use case.

The user encounters an error

Oracle Self-Service E-Billing invokes the Error Message use case.

Application Guide for Oracle Self-Service E-Billing (Consumer Edition) Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.