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

Total Cost by Plan


The user can use this use case to view the total cost of all plans for all billing accounts associated with the user. Table 45 lists and describes the use case functions.

Table 45. Total Cost by Plan
Function
Description

Name

Total Cost by Plan

Chart

Type: Pie, Slices: Plan

Trigger

  • List of Billing Reports
  • Report drop-down

Business Rule

If the grand Total for the report is equal to 0, then the chart is suppressed.

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.

Notes

  • The slices on the pie chart denote Plan.
  • If any chart slice is less than 5%, the data is aggregated to make a bigger slice labeled Other.

Main Path for Total Cost by Plan

The following path describes the Total Cost by Plan use case:

1 The user selects the Total Cost by Plan 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 Total Cost by Plan

Alternate paths can occur in this use case.

The user modifies the query parameters
1 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.
  1. Oracle Self-Service E-Billing regenerates the report for the scope of selected reporting period and hierarchy context position.
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, PDF, or XML)

Oracle Self-Service E-Billing downloads the report in the selected format.

Exceptions for Total Cost by Plan

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.

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