Application Guide for Oracle Self-Service E-Billing (Business Edition) > Analytic Reports >

Account Billing Overview


A user can use this use case to view an overview of all billing accounts associated with the user.

Table 47 lists and describes the functions.

Table 47. Account Billing Overview Report
Function
Description

Name

Account Billing Overview Report

Trigger

  • Billing Reports List
  • Report Drop-down

Chart

Default Chart Type: Bar (A user might select an alternative chart type.)

  • X axis: Billing Account
  • Y axis: Total Value

Standard Features

  • Printer-friendly view
  • Download CSV, PDF, or XML

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.
  • PDF. A percentage of the CSV threshold value (Default is 10%).
  • 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 a PDF threshold value set at 10% must process in batch mode when it has 300 or more result set lines.

Main Path for Configuring Account Billing Overview

The following path describes the Configuring Account Billing Overview use case:

1 The user selects the Account Billing Overview report from the List of Billing Reports.
  1. Oracle Self-Service E-Billing determines query parameters based on report context or defaults and returns:
    • Tabular Report
    • Chart

Alternate Paths for Configuring Account Billing Overview

Alternate paths can occur in this use case.

The user modifies the query parameters
  1. The user modifies the following parameters:
    • Hierarchy Type and.
    • Hierarchy Name or.
    • Period (Single period or the to and from period for data aggregation
  2. The user changes any of the query parameters on the Report tab or his or her hierarchy context position and selects Display to execute report.
  3. Oracle Self-Service E-Billing regenerates the report for the scope of selected reporting period and hierarchy context position.
The user selects a peer node name from a list

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

The user drills-down and selects a link to get additional details
  • For a Billing account. Oracle Self-Service E-Billing invokes the Contract Billing Overview use case for the selected billing account.
  • A Row Total. Oracle Self-Service E-Billing invokes the Account Billing Details use case for the selected number.
The user drills-down and selects the hyperlink T at the end of a row

The Account Billing Trend report is generated where the hierarchy context position is changed to the object of the row on which the user selected and the report is run with all the same parameters from the report previously ran.

The user selects an alternative chart type

Available chart types are:

    • Vertical Bar Chart
    • Pie Chart (proportional)
The user selects the Printer-Friendly action

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

The user selects the Download action (CSV, XML or PDF)

Oracle Self-Service E-Billing downloads the report.

Exceptions for Configuring Account Billing Overview

The following exceptions can occur with this use case.

The user encounters a server system error

Oracle Self-Service E-Billing invokes the error message use case.

Business Rule

If there are more than 20 Billing Accounts in the result set, the chart is suppressed.

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