This chapter describes the Oracle Communications Billing and Revenue Management (BRM) reports that support Collections Manager, an optional component that you use to manage in-house debt collections.
Important:
Collections is an optional feature that requires a separate license.You can use these reports to manage collections information for accounts that are in collections and those that are exempt from collections.
For information about Collections, see "Understanding Collections Manager" in BRM Collections Manager.
For general information on how to run reports, see "Running BRM Reports".
The Collection report (Collection.rtf) shows information about all accounts that BRM has identified as being in collections for the specified time period. It groups information by a collections profile. These profiles are used only for collections and are not the same as the customer profiles that can be displayed in Customer Center.
You can generate two versions of the Collection report. The value you select in the Report Type parameter determines which subreport is used to generate the report.
If you set Report Type to SUMMARY, the report shows billinfo status, number of accounts, delinquent amount, and total account balance without disclosing specific account information. For more information, see "Collection Summary Report".
If you set Report Type to DETAIL, the report shows account number, account name, billinfo status, date the action is due, delinquent amount, and balance for each account. For more information, see "Collection Detail Report".
You can find the SQL query for this report in the following file:
Local_drive:\BIP_Home\xmlp\XMLP\Reports\BRM Reports\Collections Reports\Collection\Collection.xdo
This report groups accounts in collections by Scenario Name, Resource, and Action.
The report shows the following information:
BillInfo Status: The current bill unit status, such as active.
Number of Accounts: The number of accounts in each BillInfo status category.
Delinquent Amount: The amount that is overdue.
Balance: The total account balance, including the delinquent amount.
Scenario Name: The scenario name.
Resource: The currency resource, such as US Dollar.
Action: The collection action name.
Profile Name: The collection profile name.
Bill Unit: The name of the bill unit, such as US Dollar.
No charts are available for this report.
Note:
The Collection summary report displays all the data even if you set a filter on any of the parameters.You can change the following parameters to modify the output of the Collection summary report:
Report Type
Resource
Billinfo Status
Scenario
Start Date (date only, not date-time)
End Date (date only, not date-time)
For information on parameters not described in Table 6-1, see "Understanding the Standard Parameters".
Table 6-1 Collections Summary Parameters
| Parameter | Description | Valid values | Default value |
|---|---|---|---|
|
Report Type |
The type of information you want to show in the report: SUMMARY shows the total number of accounts and the amount in the specified collections scenario without disclosing specific account information. DETAIL specifies the account number, customer name, other account details, and the amount in the specified collections action. |
SUMMARY or DETAIL. |
SUMMARY. |
|
Resource |
The account currency. |
Any valid ISO currency code in the CONFIG_BEID_BALANCES_T table or ALL. The parameter list might not include all the currency codes in your BRM database. To add currency codes to the list, see "Adding Parameters in BI Publisher". |
ALL |
|
Scenario |
The collection state or risk that the customer is assigned to. |
Select ALL or enter the name of any valid scenario. To check the spelling of a scenario, see the NAME field in the CONFIG_COLLECTIONS_SCENARIO_T table. |
ALL |
|
Bill Unit Status |
The bill status. |
Select ALL or enter the name of any valid status. |
ALL |
|
Bill Unit |
The bill unit name. |
Select ALL or enter the name of any valid bill unit. To check the spelling of the bill unit, see the BILL_INFO_ID field in the BILLINFO_T table. |
ALL |
|
Bill Day |
Range of bill day. |
Select the range from 1 to 28 and also the selected days only. |
None |
|
Days Overdue |
Range of days overdue. |
Select the range of days due or selected number of days overdue. |
None |
|
Profile |
Profile name associated with the bill. |
Select ALL or enter the name of any valid profile. To check the spelling of a scenario, see the PROFILE_NAME field in the CONFIG_COLLECTIONS_PROFILE_T table. |
ALL |
|
Amount Due |
The amount due to the bill. |
Select the range of amount or selected amount overdue. |
None |
This report groups accounts in collections by Scenario Name, Resource, and Action.
The report shows the following information:
Account Number: The customer's account number.
Account Name: The customer's name on the account.
BillInfo Status: The current BillInfo status, such as active. (If the BillInfo status parameter is not set to ALL, this information is not displayed.)
Date Action Due: The date that the action is due.
Delinquent Amount: The amount that is overdue.
Balance: The total account balance, including the delinquent amount.
Resource: The currency resource, such as US Dollar.
Action: The collection action name.
Profile Name: The collection profile name.
Bill Unit: The name of the bill unit, such as US Dollar.
Days Overdue: The number of days the bill is overdue.
No charts are available for this report.
You can change the following parameters to modify the output of the Collection detail report:
Report Type
Resource
BillInfo Status
Scenario
Start Date (date only, not date-time)
End Date (date only, not date-time)
For information on parameters not described in Table 6-2, see "Understanding the Standard Parameters".
Table 6-2 Collection Detail Parameters
| Parameter | Description | Valid values | Default value |
|---|---|---|---|
|
Report Type |
The type of information you want to show in the report: SUMMARY shows the total number of accounts and the amount in the specified collections scenario without disclosing specific account information. DETAIL specifies the account number, customer name, other account details, and the amount in the specified collections action. |
SUMMARY or DETAIL |
SUMMARY |
|
Resource |
The account currency. |
Any valid ISO currency code in the CONFIG_BEID_BALANCES_T table or ALL The parameter list might not include all the currency codes in your BRM database. To add currency codes to the list, see "Adding Parameters in BI Publisher". |
ALL |
|
Scenario |
The collection state or risk that the customer is assigned to. |
Select ALL or enter the name of any valid scenario. To check the spelling of a scenario, see the NAME field in CONFIG_COLLECTIONS_SCENARIO_T table. |
ALL |
|
Bill Unit Status |
The bill status. |
Select ALL or enter the name of any valid status. |
ALL |
|
Bill Unit |
The bill unit name. |
Select ALL or enter the name of any valid bill unit. To check the spelling of the bill unit, see the BILL_INFO_ID field in the BILLINFO_T table. |
ALL |
|
Bill Day |
Range of bill day. |
Select the range from 1 to 28 and also the selected days only. |
None |
|
Days Overdue |
Range of days overdue. |
Select the range of days due or selected number of days overdue. |
None |
|
Profile |
Profile name associated with the bill. |
Select ALL or enter the name of any valid profile. To check the spelling of a scenario, see the PROFILE_NAME field in the CONFIG_COLLECTIONS_PROFILE_T table. |
ALL |
|
Amount Due |
The amount due to the bill. |
Select the range of amount or selected amount overdue. |
None |
The CollectionExemptBillinfo report (CollectionExemptBillinfo.rtf) shows the accounts that are exempt from collections, such as accounts for employees. The report includes the current balance due for exempt accounts.
You can generate two versions of the CollectionExemptBillinfo report. The value you select in the Report Type parameter determines which subreport is used to generate the report.
If you set Report Type to SUMMARY, the report shows the total number of accounts and the amount for accounts that have the specified status without disclosing account information. For more information, see "CollectionExemptBillinfo Summary Report".
If you set Report Type to DETAIL, the report shows details such as the customer's name and account number. For more information, see "CollectionExemptBillinfo Detail Report".
You can find the SQL query for this report in the following file:
Local_drive:\BIP_Home\xmlp\XMLP\Reports\BRM Reports\Collections Reports\CollectionExemptBillinfo\CollectionExemptBillinfo.xdo
This report groups billinfo status by resource.
For each account, the report shows the following information:
BillInfo Status: The current bill unit, such as active.
Number of Accounts: The number of exempt accounts in each billinfo status category.
Balance: The total account balance.
No charts are available for this report.
You can change the following parameters to modify the output of the CollectionExemptBillinfo summary report:
Report Type
Resource
BillInfo Status
For information on parameters not described in Table 6-3, see "Understanding the Standard Parameters".
Table 6-3 CollectionExemptBillinfo Summary Parameters
| Parameter | Description | Valid values | Default value |
|---|---|---|---|
|
Report Type |
The type of information you want to show in the report: SUMMARY shows the total number of accounts and the amount in the specified collections scenario without disclosing specific account information. DETAIL specifies the account number, customer name, other account details, and the amount in the specified collections action. |
SUMMARY or DETAIL |
SUMMARY |
|
Resource |
The account currency. |
Any valid ISO currency code in the CONFIG_BEID_BALANCES_T table or ALL The parameter list might not include all the currency codes in your BRM database. To add currency codes to the list, see "Adding Parameters in BI Publisher". |
ALL |
|
Bill Unit Status |
The Bill Status |
Select All or enter the name of any valid Status. |
ALL |
This report groups accounts by resource and billinfo status.
For each account, the report shows the following information:
Account Number: The customer's account number.
Account Name: The customer's name on the account.
Balance: The total account balance.
No charts are available for this report.
You can change the following parameters to modify the output of the CollectionExemptBillinfo detail report:
Report Type
Resource
Billinfo Status
For information on parameters not described in Table 6-4, see "Understanding the Standard Parameters".
Table 6-4 CollectionExemptBillinfo Detail Parameters
| Parameter | Description | Valid values | Default value |
|---|---|---|---|
|
Report Type |
The type of information you want to show in the report: SUMMARY shows the total number of accounts and the amount in the specified collections scenario without disclosing specific account information. DETAIL specifies the account number, customer name, other account details, and the amount in the specified collections action. |
SUMMARY or DETAIL |
SUMMARY |
|
Resource |
The account currency. |
Any valid ISO currency code in the CONFIG_BEID_BALANCES_T table or ALL The parameter list might not include all the currency codes in your BRM database. To add currency codes to the list, see "Adding Parameters in BI Publisher". |
ALL |
|
Bill Unit Status |
The Bill Status |
Select All or enter the name of any valid Status. |
ALL |