23 Managing Closed Accounts
Learn how to manage closed accounts in your Oracle Communications Billing and Revenue Management (BRM) system.
Topics in this document:
Specifying Retention Period for Closed Accounts
You can specify the number of months to retain closed accounts in BRM by setting the ClosedAcctsRetentionMonths parameter in the customer instance of the /config/business_params object.
To specify the retention period for closed accounts:
-
Go to BRM_home/sys/data/config.
-
Create an XML file from the /config/business_params object:
pin_bus_params -r BusParamsCustomer bus_params_customer.xml
-
Set the ClosedAcctsRetentionMonths entry to the number of months that you want to retain the closed accounts:
<ClosedAcctsRetentionMonths>number_of_months</ClosedAcctsRetentionMonths>
-
Save the file as bus_params_customer.xml.
-
Load the XML file into the BRM database:
pin_bus_params bus_params_customer.xml
-
Stop and restart the CM.
-
(Multischema systems only) Run the pin_multidb script with the -R CONFIG parameter. See "pin_multidb" for more information.
Deleting Closed Accounts
After a closed account passes the specified retention period, you can delete it from BRM by using the pin_del_closed_accts utility.
To delete closed accounts:
-
Go to the BRM_home/apps/pin_billd directory.
-
Do the following as appropriate:
Note:
To delete all closed child accounts in a hierarchy and sharing groups, run all of these commands in this order.
-
To delete all closed nonpaying child accounts at different levels in a hierarchy:
pin_del_closed_accts -subord -leaf pin_del_closed_accts -subord
-
To delete member accounts from sharing groups:
pin_del_closed_accts -members_sharing
-
To delete paying child accounts at different levels in a hierarchy:
pin_del_closed_accts -members_billing
Note:
Run this command for each paying account in a hierarchy. For example, if there are two paying accounts in a hierarchy, run this command twice to delete both paying accounts.
-
-
To delete all remaining closed accounts, including the top-level parent account in the hierarchy:
pin_del_closed_accts
-
To delete specific closed accounts by using a file:
Note:
Run the pin_del_closed_accts -file command only if you want to delete specific accounts, but ensure that you use this command with care.
pin_del_closed_accts -file file_name
For example:
pin_del_closed_accts -file closed_accts_list.txt
The utility deletes the accounts specified in the input file. You must provide the account details in flist format. For example:
0 PIN_FLD_RESULTS ARRAY [0] allocated 20, used 1 1 PIN_FLD_POID POID [0] 0.0.0.1 /account 123 0 0 PIN_FLD_RESULTS ARRAY [1] allocated 20, used 1 1 PIN_FLD_POID POID [0] 0.0.0.1 /account 234 0
For more information about the pin_del_closed_accts utility and parameters, see "pin_del_closed_accts".