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".
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
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 |
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.
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 |