9 SIM Manager Reports
This document 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.
For more information, see "About Managing SIM Card Inventory" in BRM Telco Integration.
Topics in this document:
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.
-
Quantity Ordered - The amount of SIM cards ordered.
-
Quantity Received - The number of SIM cards received.
You can find the SQL query data model for this report in the following directory:
Reports/BRM Reports/SIM Card Manager Reports/SIMOrderMgmt/SIMOrderMgmt.xdm
SIMOrderMgmt Parameters
You can change the following parameters to modify the output of the SIMOrderMgmt report:
-
Order Number
-
Order Status
-
Start Date
-
End Date
For information on parameters not described in Table 9-1, see "Understanding the Standard Parameters".
Table 9-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:
-
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.
Note:
Before running this report, you must load a stored procedure into your BRM database. See "Loading Stored Procedures".
You can find the SQL query data model for this report in the following directory:
Reports/BRM Reports/SIM Card Manager Reports/SIMCardInventoryMgmt/SIMCardInventoryMgmt.xdm
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 9-2, see "Understanding the Standard Parameters".
Table 9-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 |