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

Viewing the Service Details Report


This report tracks the service transactional details for one or more service numbers over a user-defined reporting period.

Table 28 lists and describes the Viewing the Service Details Report use case functions.

Table 28. Viewing the Service Details Report
Function
Description

Name

Viewing the Service Details Report

Description

This report tracks the service transactional details 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 Details link or selects Service Details from the list.

Business Rules

None

Standard Features

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

Report Content

Header:

  • Report Details
  • Number of Items
  • Page Elements (Default is 10 transactions listed on each page)

Columns:

  • Date (Sort Most Recent First)
  • Time
  • Service Number
  • Name
  • Number Called
  • Category
  • Memo (Icon)
  • Dispute (Icon)
  • Type
  • Tariff (Hyperlink to Service Transaction Detail)
  • Destination
  • Volume
  • Total Charges

Footer (Total Row):

  • Total - Literal
  • Total Charges

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.

  • All report detail columns are sortable.

Business Rules

None

Functions

The user can customize or submit a batch request for this report.

Main Path for Viewing the Service Details Report

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

The user selects the Service Billing Overview from the List of Billing Reports.

Oracle Self-Service E-Billing determines query parameters according to report context or default values and displays a tabular report.

Alternate Paths for Viewing the Service Details 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 customize or 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 Service Details 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.