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:

  1. Go to BRM_home/sys/data/config.

  2. Create an XML file from the /config/business_params object:

    pin_bus_params -r BusParamsCustomer bus_params_customer.xml
  3. Set the ClosedAcctsRetentionMonths entry to the number of months that you want to retain the closed accounts:

    <ClosedAcctsRetentionMonths>number_of_months</ClosedAcctsRetentionMonths>
  4. Save the file as bus_params_customer.xml.

  5. Load the XML file into the BRM database:

    pin_bus_params bus_params_customer.xml
  6. Stop and restart the CM.

  7. (Multischema systems only) Run the pin_multidb script with the -R CONFIG parameter. See "pin_multidb" in BRM System Administrator’s Guide.

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:

  1. Go to the BRM_home/apps/pin_billd directory.

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

  3. To delete all remaining closed accounts, including the top-level parent account in the hierarchy:

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