This chapter describes the Oracle Communications Billing and Revenue Management (BRM) reports that support Number Manager, an optional component that you use to create and manage telephone numbers. Number Manager supports Global System for Mobile communications (GSM) wireless telephony services. See "About Managing Telephone Numbers" in BRM Telco Integration.
Important:
Number Manager is an optional component, not part of base BRM.For general information on how to run reports, see "Running BRM Reports".
Note:
You must upload the NumberInventoryMgmt.source file that is in the StoredProcedures folder to the database after the base reports are installed. For more information about loading stored procedures see "Loading Stored Procedures".The Number Inventory Management report (NumberInventoryMgmt.rtf) tracks number inventory and information relating to tracking telephone numbers. The value you select in the Report Type parameter determines what information about your telephone number inventory is shown.
When Report Type is set to NUMBER CATEGORY, the report shows a summary of the status of telephone numbers within a block of numbers. For more information, see "Report Type set to NUMBER CATEGORY".
If Report Type is set to VANITY NUMBER, the report shows telephone numbers with a vanity type applied to the number. For more information, see "Report Type set to VANITY NUMBER".
The default value for the Report Type parameter is NUMBER CATEGORY.
You can also change the Start Date and End Date parameters to modify the output of the NumberInventoryMgmt report. For information on these parameters, see "Understanding the Standard Parameters".
You can find the SQL query for this report in the following file:
Local_drive:\BIP_Home\xmlp\XMLP\Reports\BRM Reports\Number Manager Reports\StoredProcedures\NumberInventoryMgmt.source
The NumberInventoryMgmt report with Report Type set to NUMBER CATEGORY groups telephone numbers by the following:
Number Block: This is a block of telephone numbers that share the same block name, telephone number attributes, and brand.
Brand: The name of the brand that has the block of telephone numbers. 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.
Status: This is the status of the telephone number.
No charts are available for this report.
The NumberInventoryMgmt report with Report Type set to VANITY NUMBER groups the phone numbers by the following:
Number Block: This is a block of telephone numbers that share the same block name, telephone number attributes, and brand.
Brand: The name of the brand that has the block of telephone numbers. 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.
Vanity Type: This is the vanity type applied to the block of numbers.
Status: This is the status of the telephone number.
No charts are available for this report.