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

Longest Calls


The user can use this use case to view a report showing the longest calls. Table 37 lists and describes the use case functions.

Table 37. Longest Calls
Function
Description

Name

Longest Calls

Feature Area

Analytics

Description

The user views a report showing the longest calls.

Primary User

Administrator, manager, and subscriber; CSR administrator and user.

Triggers

  • The user clicks the Analytics tab, and then clicks the Top X Reports subtab. A report list appears and the user clicks the hyperlink for Longest Calls.
  • The user selects Longest Calls from the Top X Report drop-down list.

Prompts

Report Selection Criteria

Period Range (Default: Current period):

  • The user selects a start and end reporting period.

Number of Results:

  • Default: 10
  • The user can select the number of resulting report query rows to view from the following preconfigured values: 10, 25, 50, or 100.

Drop-down List:

  • Highest Spending Services
  • Most Expensive Calls
  • Longest Calls (Default)
  • Most Frequently Called Numbers
  • Most Frequently Called Destinations
  • Most Frequently Called Countries

Page Tabs

  • Report (Active)
  • Batch Request

Active Hyperlinks (Breadcrumbs)

  • Analytics. Displays the list of Standard reports.
  • Top X Reports. Displays the list of Top X reports.

Report Content

Page Title:

  • Longest Calls

Header:

  • Report Details
  • Number of items

Columns:

  • Date
  • Time
  • Service Number
  • Name
  • Number Called
  • Category (With a hyperlink)
  • Type (With a hyperlink)
  • Tariff
  • Destination
  • Volume
  • Total Charges

Total Row:

  • Total

Business Rules

The current bill period range (single period) is used as the default criteria.

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.

Functions

  • If the report result set is less than the number of results selected, the available data set displays.
  • Users can submit a batch request for this report.

Main Path for Viewing the Longest Calls

The main path to view the Longest Calls report is as follows:

The user selects the Longest Calls report from the List of Top X Reports or from the drop-down list of reports.

Oracle Self-Service E-Billing displays the top ten records of the Longest Calls report for the current period.

Alternate Paths for Viewing the Longest Calls

Alternate paths can occur in this use case.

The user specifies query parameters

The user enters start and ending report dates.

Oracle Self-Service E-Billing retrieves the report data based on the selected date range and displays the Longest Calls report.

The user clicks the Printer Friendly action

Oracle Self-Service E-Billing displays the print page.

The user clicks the Download action (CSV or XML)

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

Exceptions for Viewing the Longest Calls

Exceptions can occur in this use case.

The user encounters a 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.