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

E16718-07
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:

  • Order Number: The number assigned to a particular order.

  • Order Status: The status of the order.

  • Order Date: The date the order was placed.

  • Brand: The name of the brand that ordered the SIM cards. This can be your company or a branded service provider. Brand Manager is an optional component, not part of base BRM.

    For information on brands, see "About Branding" in BRM Managing Customers.

  • Quantity Ordered: The amount of SIM cards ordered.

  • Quantity Received: The number of SIM cards received.

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:

  • Brand: The name of the brand that has the SIM cards. This can be your company or a branded service provider. Brand Manager is an optional component, not part of base BRM.

    For information on brands, see "About Branding" in BRM Managing Customers.

  • Order Number: The number assigned to a batch of SIM cards when the order was placed.

  • SIM Device State: The state of the SIM card.

    Important:

    Before running this report, you must load a stored procedure into your BRM database. See "Loading Stored Procedures".

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