Skip Headers
Oracle® Communications Billing and Revenue Management Reports
Release 7.5

E16718-05
Go to Documentation Home
Home
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

10 SIM Manager Reports

This chapter describes the Oracle Communications Billing and Revenue Management (BRM) reports that support SIM Manager, an optional component that you use to create and manage SIM cards. SIM Manager supports Global System for Mobile communications (GSM) wireless telephony services. See "About Managing SIM Card Inventory" in BRM Telco Integration.

Important:

SIM Manager is an optional component, not part of base BRM.

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

SIM Order Management Report

The SIM Order Management report (SIMOrderMgmt.rtf) shows the order status for a batch of SIM cards. It tracks each order from the time the order is placed until it is received.

No charts are available for this report.

For each SIM card order, the report shows the following information:

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

Local_drive:\BIP_Home\xmlp\XMLP\Reports\BRM Reports\SIM Card Manager Reports\SIMOrderMgmt\SIMOrderMgmt.xdo

SIMOrderMgmt Parameters

You can change the following parameters to modify the output of the SIMOrderMgmt report:

  • Order Number

  • Order Status

  • Brand

  • Start Date

  • End Date

For information on parameters not described in Table 10-1, see "Understanding the Standard Parameters".

Table 10-1 SIMOrderMgmt Parameters

Parameter Description Valid values Default value

Order Number

The number assigned to a particular order.

Enter ALL or a specific order number.

ALL

Order Status

The status of the order.

Any valid order status name or ALL.

For a list of valid order status names, see "About Managing Orders" in BRM Telco Integration.

ALL


SIM Card Inventory Management Report

The SIM Card Inventory Management report (SIMCardInventoryMgmt.rtf) tracks the state of the SIM cards currently in inventory. This report groups the SIM cards by the following:

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

Local_drive:\BIP_Home\xmlp\XMLP\Reports\BRM Reports\SIM Card Manager Reports\SIMCardInventoryMgmt\SIMCardInventoryMgmt.xdo

No charts are available for this report.

SIMCardInventoryMgmt Parameters

You can change the following parameters to modify the output of the SIMCardInventoryMgmt report:

  • Order Number

  • Order Status

  • Start Date

  • End Date

For information on parameters not described in Table 10-2, see "Understanding the Standard Parameters".

Table 10-2 SIMCardInventoryMgmt Parameters

Parameter Description Valid values Default value

Order Number

The number assigned to a batch of SIM cards when the order was placed.

Enter ALL or a specific order number.

ALL

SIM Device State

The state of the SIM card, such as provisioning.

Any valid SIM card state or ALL.

The parameter value list might not include all the status names stored in your BRM database. To add to this list, see "Adding Parameters in BI Publisher".

ALL