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

Most Frequently Called Country by Service Agreement Details


The user can use this use case to view a report showing a list of service details for the most frequently called country. Table 46 lists and describes the use case functions.

Table 46. Most Frequently Called Country by Service Agreement Details
Function
Description

Name

Most Frequently Called Country by Service Agreement Details

Feature Area

Analytics

Description

The user views a list of service details for an individual service agreement.

Preconditions

The user has successfully enrolled and authenticated in Oracle Self-Service E-Billing.

Primary User

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

Triggers

The user clicks a service number hyperlink on the Most Frequently Called Country by Service Agreement report.

Page Tabs

Report (Active)

Active Hyperlinks (Breadcrumbs)

  • Analytics. Displays the list of Standard reports.
  • Top X Reports. Displays the list of Top X reports.
  • Most Frequently Called Countries. Displays the Most Frequently Called Countries report.
  • Service Agreement. Displays the Most Frequently Called Country by Service Agreement report.

Report Content

Page Title:

  • Most Frequently Called Country by Service Agreement

Paging Elements (If needed)

  • Page X of Total
  • Paging arrow buttons

Header:

  • Report Details
  • Number of items

Columns:

  • Country
  • Service Number
  • Date
  • Time
  • Number Called
  • Volume
  • Tariff
  • Destination
  • Total Charges

Total Row:

  • Total (Literal)
  • Volume
  • Total charges

Business Rules

The period range selected on the Most Frequently Called Countries report applies on this drill-down report.

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.

  • All report detail table columns are sortable (except for the country and service number columns) and display in descending order (highest to lowest); you can change the default sort order to ascending.

Functions

Drill-down links are for the country and the selected service agreement.

Main Path for Viewing the Most Frequently Called Country by Service Agreement Details

The main path to view the Most Frequently Called Country by Service Agreement Details report is as follows:

The user clicks the Service Number hyperlink on the Most Frequently Called Country by Service Agreement report.

Oracle Self-Service E-Billing displays the Most Frequently Called Country by Service Agreement Details report for the selected service number.

Alternate Paths for Viewing the Most Frequently Called Country by Service Agreement

Alternate paths can occur in this use case.

The user clicks the Download action (CSV or XML)

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

The user clicks the Printer Friendly action

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

Exceptions for Most Frequently Called Country by Service Agreement Details

An exception 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.