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

Statement Billing Overview


Users can use this use case to view the charge types summarized by invoice. Table 40 lists and describes the functions.

Table 40. Statement Billing Overview
Function
Description

Trigger

  • Billing Reports List
  • Report Drop-down
  • Account Billing Details

Query Parameters

Report Selection Criteria and Custom Tab

  • Hierarchy Name and Position
  • Period Range

Report Selection Criteria Only

Report.

Report Content

The Statement Billing Overview report contains the following fields:

  • Invoice
  • Invoice Charges
  • Usage Charges
  • Adjustments
  • Discounts
  • Other Charges and Credits
  • Taxes
  • Total Value

Except for the first column, totals for all pages, including those not displayed, are displayed in the footer at the bottom of each page.

Chart

None

Business Rules

None

Standard Features

  • Printer-friendly view
  • Download CSV 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.
  • 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.

Main Path for Statement Billing Overview

The following path describes the Statement Billing Overview use case:

1 The user selects the Invoice Billing Details report from the List of Billing Reports.
  1. Oracle Self-Service E-Billing determines query parameters based on report context or defaults and returns a tabular report.

Alternate Paths for Statement Billing Overview

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 run the report.
  1. Oracle Self-Service E-Billing regenerates the report for the scope of selected reporting period and hierarchy context position.
The user drills-down and selects an invoice

Oracle Self-Service E-Billing invokes the Contract Billing Overview use case for the selected invoice number.

The user selects the Printer-Friendly action

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

The user selects the Download action.

Oracle Self-Service E-Billing downloads the report.

Exceptions for Statement 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.

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