13 Voucher Manager Reports
This chapter describes the Oracle Communications Billing and Revenue Management (BRM) reports that support Voucher Manager, an optional component you use to create and manage voucher cards.
Important :
Voucher Manager is an optional component, not part of base BRM.For general information on how to run and troubleshoot reports, see "Running BRM Reports".
For information about vouchers, see "About Managing Voucher Inventory" in BRM Telco Integration.
Voucher Management Reports
Voucher Management reports provide reports on your voucher inventory. The Voucher Management reports are:
-
Voucher Device Management report
-
Voucher Inventory report
Voucher Device Management Report
The Voucher Device Management report details the contents and attributes of one or more vouchers.
No charts are available for this report.
You can choose to mask the PIN numbers displayed in the report. Masking the PIN numbers in the report displays only the last four characters of each PIN number.
For each Voucher Device, the report shows the following information:
-
Device ID: The serial number assigned to the particular device.
-
Status: The status of the device.
-
PIN: The PIN associated with the voucher.
-
Expiration Date: The expiration date of the voucher.
-
Dealer Name: The dealer name associated with the voucher.
You can find the SQL query for this report in the following file:
Local_drive:\BIP_Home\xmlp\XMLP\Reports\BRM Reports\Voucher Reports\VoucherDeviceMgmt\VoucherDeviceMgmt.xdo
Figure 13-1 shows output for a VoucherDevMgmt report with Device Number set to ALL:
Figure 13-1 VoucherDevMgmt Report Output
Description of ''Figure 13-1 VoucherDevMgmt Report Output''
Voucher Device Management Parameters
You can change the following parameters to modify the output of the VoucherDevMgmt report:
-
Device ID
-
Start Date
-
End Date
-
Mask PIN Number
For information on parameters not described in Table 13-1, see "Understanding the Standard Parameters".
Table 13-1 VoucherDevMgmt Report Parameters
| Parameter | Description | Valid Values | Default Value |
|---|---|---|---|
|
Device Number |
The number assigned to a particular device. |
Enter ALL or a specific device number. |
ALL. |
|
Mask PIN Numbers |
The display format of PIN numbers. Select YES to show only the last four characters of all credit card numbers. Select NO to display the entire number. |
YES or NO. |
YES. |
Voucher Inventory Management Report
The Voucher Inventory Management report (VoucherInventoryMgmt.rtf) tracks the state of orders currently in inventory. This report groups the Voucher cards by brand- the name of the brand for the Voucher cards. This can be your company or a branded service provider (BSP).
For information on brands, see "About Branding" in BRM Managing Customers.
No charts are available for this report.
The report shows the following information:
-
Order Number: The number assigned to a particular order.
-
Status: The status of the order.
-
Dealer Name: The dealer name associated with the order.
-
Expiration Date: The expiration date of the order.
Figure 13-2 shows output for a VoucherInventoryMgmt report, with Order Number set to ALL:
Figure 13-2 VoucherInventoryMgmt Report Output
Description of ''Figure 13-2 VoucherInventoryMgmt Report Output''
Voucher Inventory Management Parameters
You can change the following parameters to modify the output of the VoucherInventoryMgmt report:
-
Order Number
-
Start Date
-
End Date
For information on parameters not described in Table 13-2, see "Understanding the Standard Parameters".