11 Suspense Manager Reports

This chapter describes the Oracle Communications Billing and Revenue Management (BRM) reports that support the standard recycling and Suspense Manager features.

For general information about standard recycling, see "About Standard Recycling" in BRM Configuring Pipeline Rating and Discounting.

For general information on how to run, see "About BRM Reports".

Suspended EDR Report

The Suspended EDR report (SuspenseHandling.rtf) shows the totals of suspended call records that were processed by Suspense Manager during a time period you specify. This report displays the status of the suspended call records at the time you ran this report.

You can generate two versions of the Suspended EDR report:

  • A summary report that lists suspended call record totals by brand. For each brand this report lists totals of suspended call records by suspense reason, and suspense state (suspended, recycling, successfully reprocessed, and written off). For more information see "Suspended EDR Detail Report".

  • A detailed report that lists the same information as the summary report and also includes details for each call record. For details, see "Suspended EDR Detail Report".

You can find the SQL query for this report in the following file:

Local_drive:\BIP_Home\xmlp\XMLP\Reports\BRM Reports\Suspense Reports\SuspenseHandling\SuspenseHandling.xdo

Suspended EDR Report Parameters

You can change the following parameters to modify the output of the suspended EDR summary report:

  • Report type

    The type of information you want to show in the report:

    • SUMMARY: For each brand, shows the total number of accounts and the amount in the specified collections scenario without disclosing specific account information.

    • DETAIL: For each brand, specifies the account number, customer name, other account details, and the amount in the specified collections action. See "Suspended EDR Detail Report" for details.

  • Start date

  • End date

For details on the start date and end date parameters, see "Running BRM Reports".

Suspended EDR Summary Report

This report returns the following information:

  • The brand associated with the suspended call records.

  • The suspense reason that caused the call records to fail.

  • For each suspense reason, the total number of suspended call records by suspense status (suspended, recycling, successfully reprocessed, and written off) for the brand.

  • The total number of suspended call records for all statuses for the brand.

Suspended EDR Detail Report

This report is a more verbose version of the Suspended EDR summary report. It returns the same information as summary version, and includes additional details from the individual call records. This report returns the following:

  • The brand associated with the suspended call records.

  • The suspense reason that caused the call records to fail.

  • For each suspense reason, a list of all the suspended call records.

  • Details for each call record, including:

    • The number of times the call has been recycled.

    • The date the call was made.

    • The call duration (in minutes).

    • The calling number.

    • The called number.

  • The total number of suspended call records by suspense status (suspended, recycling, successfully reprocessed, and written off) for the brand.

Written-Off EDR Report

The written-off EDR report (SuspenseHandlingWriteoff.rtf) shows the total number of suspended call records with a status of written-off, for each brand.

You can generate two versions of the SuspenseHandlingWriteoff report:

  • A summary report that lists totals of suspended call records with a written-off call status for each brand. For each brand, this reports shows suspended call totals by suspense reason. For details, see "Written-Off EDR Summary Report".

  • A detail report that lists the same information as the summary report and also includes details for each call records. For details, see "Written-Off EDR Detail Report".

You can find the SQL query for this report in the following file:

Local_drive:\BIP_Home\xmlp\XMLP\Reports\BRM Reports\Suspense Reports\SuspenseHandlingWriteoff\SuspenseHandlingWriteoff.xdo

Written-Off EDR Report Parameters

You can change the following parameters to modify the output of the written-off EDR report:

  • Report type

    The type of information you want to show in the report:

    • Enter SUMMARY to show the number of suspended calls in your BRM system, arranged by brand and suspense reason.

    • You can also enter DETAIL to specify a more detailed version of this report. See "Suspended EDR Detail Report" for details.

  • Start date

  • End date

For details on the start date and end date parameters, see "Running BRM Reports".

Written-Off EDR Summary Report

This report returns the following information for each brand in your BRM system:

  • For each brand in your BRM system:

    • The name of the brand.

    • The total number of suspended call records listed by suspense reason.

  • The total number of suspended call records for all brands.

Written-Off EDR Detail Report

This report returns the following information by brand:

  • Name of the brand.

  • All the suspended call records associated with that brand, listed by suspense reason. For each call record, the following details are listed:

    • Suspense reason that caused the call to fail.

    • Call record name.

    • Number of times the call was recycled.

    • Date the call was initiated.

    • Call duration (in minutes).

    • Calling number.

    • Called number.

    • The total number of suspended call records by suspense reason for the brand.

    • The total number of all calls written off for each brands.