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

Viewing the Account Billing Trend Report


This report tracks the monthly charges for an account over a user-defined reporting period.

Table 26 lists and describes the Viewing the Account Billing Trend Report use case functions.

Table 26. Viewing the Account Billing Trend Report
Function
Description

Name

Viewing the Account Billing Trend Report

Description

This report tracks the monthly charges for an account 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 Account Billing Trend link or selects Account Billing Trend from the list.

Chart

Bar Chart (Default):

  • X-axis: Reporting Period
  • Y-axis: Dollars

Standard Features

  • Printer-Friendly view
  • Download CSV or XML

Report Content

Header:

  • Report Details
  • Number of Items

Columns:

  • Period (Sort Most Recent First, hyperlink to Service Billing Overview for selected period)
  • Number of Contracts
  • Monthly Charges
  • Usage Charges
  • Credits
  • Other Charges
  • Taxes
  • Total

Footer (Total Row):

  • Total - Literal
  • Monthly Charges
  • Usage Charges
  • Credits
  • Other Charges
  • Taxes
  • Total

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 Account Billing Trend Report

The main path to view the Account Billing Trend report is as follows:

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

Alternate Paths for Viewing the Account Billing Trend 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 Viewing the Account Billing Trend Report

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 (Consumer Edition) Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.