6 Utility Changes

This chapter provides an overview of the utility changes introduced in Oracle Communications Billing and Revenue Management (BRM) 7.5 Patch Set 14 through BRM 7.5 Patch Set 23.

New Utilities

Table 6-1 lists the utilities introduced in BRM 7.5 Patch Set 14 through BRM 7.5 Patch Set 23.

Table 6-1 New Utilities

New Utility	Description
pin_del_closed_accts	(Patch Set 22) Introduced to delete closed accounts in BRM. This utility calls the PCM_OP_CUST_DELETE_ACCT opcode to delete the closed accounts that are older than the specified retention period. See "Enhanced Data Protection (Patch Set 22)" for more information.
pin_generate_analytics	(Patch Set 15) Generates business metrics data for accounts by status, accounts by subscription, payments, billed revenue, and accounts receivable (A/R) and loads the metrics data into the BRM database. Oracle Communications Billing and Revenue Management Business Operations Center displays graphs based on the business metrics data generated by this utility. See the discussion about collecting metrics to display in Business Operations Center in BRM System Administrator's Guide.
pin_job_executor	(Patch Set 15) Runs BRM applications such as pin_bill_accts, pin_collect, and pin_inv_accts when called by Business Operations Center. This is an internal utility that cannot be run from the command line. See the discussion about running jobs in Business Operations Center in BRM System Administrator's Guide.

New Utility

Description

pin_del_closed_accts

(Patch Set 22) Introduced to delete closed accounts in BRM. This utility calls the PCM_OP_CUST_DELETE_ACCT opcode to delete the closed accounts that are older than the specified retention period.

See "Enhanced Data Protection (Patch Set 22)" for more information.

pin_generate_analytics

(Patch Set 15) Generates business metrics data for accounts by status, accounts by subscription, payments, billed revenue, and accounts receivable (A/R) and loads the metrics data into the BRM database. Oracle Communications Billing and Revenue Management Business Operations Center displays graphs based on the business metrics data generated by this utility.

See the discussion about collecting metrics to display in Business Operations Center in BRM System Administrator's Guide.

pin_job_executor

(Patch Set 15) Runs BRM applications such as pin_bill_accts, pin_collect, and pin_inv_accts when called by Business Operations Center. This is an internal utility that cannot be run from the command line.

See the discussion about running jobs in Business Operations Center in BRM System Administrator's Guide.

Changed Utilities

Table 6-2 lists the utilities changed in BRM 7.5 Patch Set 14 through BRM 7.5 Patch Set 23.

Table 6-2 Changed Utilities

New Utility	Description
pin_cmt	(Patch Set 22) Modified to migrate legacy service and balance data incrementally into the BRM system. You can now run the pin_cmt utility with the following new parameters to migrate data: deploy_db deploy_ece See "Support for Incremental Migration of Legacy Service and Balance Data into BRM and ECE (Patch Set 22)" for more information.
cmt_mta_cycle_fees	(Patch Set 22) Renamed as cmt_mta_deploy and modified to support incremental migration of legacy BRM data. See "Support for Incremental Migration of Legacy Service and Balance Data into BRM and ECE (Patch Set 22)" for more information.

New Utility

Description

pin_cmt

(Patch Set 22) Modified to migrate legacy service and balance data incrementally into the BRM system. You can now run the pin_cmt utility with the following new parameters to migrate data:

deploy_db
deploy_ece

See "Support for Incremental Migration of Legacy Service and Balance Data into BRM and ECE (Patch Set 22)" for more information.

cmt_mta_cycle_fees

(Patch Set 22) Renamed as cmt_mta_deploy and modified to support incremental migration of legacy BRM data.

See "Support for Incremental Migration of Legacy Service and Balance Data into BRM and ECE (Patch Set 22)" for more information.