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 1 through BRM 7.5 Maintenance Patch Set 1.

New Utilities

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

Table 6-1 New Utilities

New Utility	Description
pin_close_items	(Patch Set 12) Closes open item objects processed in past billing cycles. See the discussion about closing open item objects processed in past billing cycles in BRM System Administrator's Guide.
pin_cc_migrate	(Patch Set 10) Migrates the credit and debit card numbers into unique tokens and stores the tokens in the BRM database.See the discussion about the pin_cc_migrate utility in BRM Configuring and Collecting Payments for more information.
pin_sepa	(Patch Set 9) Generates request XML files for SEPA Direct Debit payments, SEPA Credit Transfer payments, and SEPA Direct Debit reversals. Also, processes the response XML files for SEPA Direct Debit transactions and SEPA Credit Transfer transactions. See the discussion about SEPA payment processing in BRM Configuring and Collecting Payments.
load_edr_field_mapping	(Patch Set 8) Loads the suspense EDR field mapping into the /config/suspense_edr_fld_map object in the BRM database. See the discussion about the load_edr_field_mapping utility in BRM Configuring Pipeline Rating and Discounting for more information.
pin_opspec_to_schema_v2	(Patch Set 8) Generates the opcode schema (XSD files) for Web services that take payload as an XML element data type. See the discussion about the pin_opspec_to_schema_v2 utility in BRM JCA Resource Adapter for more information.
RoamingConfigGen64	(Patch Set 4) Retrieves the roaming partner information in the Pipeline Manager database and creates the roaming configuration data file that is used by the Instances module to instantiate roaming registry sections or entries. See the discussion about the RoamingConfigGen64 utility in BRM Configuring Pipeline Rating and Discounting for more information.
pin_virtual_gen	(Patch Set 3) Generates virtual columns on various tables in the EVENT_T table of the BRM database. See the discussion about enabling virtual columns in the BRM database in BRM System Administrator's Guide.
pin_amt_tt	(Patch Set 2) Migrates accounts from one data store to another data store located within the same Oracle In-Memory Database (IMDB) Cache grid. See the discussion about migrating accounts within an Oracle IMDB cache grid in BRM System Administrator's Guide.
StopRapGen	(Patch Set 2) Searches the database to collect information required by the Stop RAP Generator pipeline to create Stop Return RAP files. See the discussion about the StopRapGen utility in BRM Configuring Pipeline Rating and Discounting for more information.
load_config	(Patch Set 1) Loads the contents of XML configuration files into configuration (/config/*) objects in the BRM database.
pin_state_change	(Patch Set 1) Performs bulk service state transitions based on the state expiration time (PIN_FLD_SERVICE_STATE_EXPIRATION_T) in /service objects. See the discussion about managing service life cycles in BRM Managing Customers.

Changed Utilities

Table 6-2 lists the utilities that were changed in BRM 7.5 Patch Set 1 through BRM 7.5 Maintenance Patch Set 1.

Table 6-2 Changed Utilities

Changed Utility	Description
loadpricelist	(Patch Set 11) Modified to load decimal values for fixed credit threshold from the input pricelist XML file.
load_config	(Patch Set 9) Modified to load and retrieve creditor information from the BRM database. This utility reads creditor information from the XML input file, validates the content using the XSD, and loads the data into the /config/creditor object. This utility retrieves creditor information from the /config/creditor object and generates an XML output file. See the discussion about loading creditor information in BRM Configuring and Collecting Payments.
partition_utils	(Patch Set 9) Modified the -purge parameter to remove data from /invoice/trial objects that contain partitioning. See the discussion about removing older trial invoices in BRM Designing and Generating Invoices.
pin_collect	(Patch Set 9) Modified to support the SEPA payment method. This utility calls opcodes to create the SEPA Direct Debit payment requests and apply the payments to the account balances. See the discussion about SEPA payments processing in BRM Configuring and Collecting Payments.
pin_collections_process	(Patch Set 9) Modified to support the SEPA payment method. This utility retrieves the bill units (/billinfo objects) whose payment type is SEPA.
pin_inv_export	(Patch Set 9) Modified to add the prefix SUBORD_ to the file names of subordinate trial invoices. See the discussion about the pin_inv_export utility in BRM Designing and Generating Invoices.
pin_mass_refund	(Patch Set 9) Modified to support the SEPA payment method. This utility calls opcodes to create refund items for accounts eligible for a SEPA Credit Transfer refund.
pin_refund	(Patch Set 9) Modified to support the SEPA payments method. This utility retrieves the refund items for a SEPA Credit Transfer.
pin_trial_bill_accts	(Patch Set 9) Modified by adding parameters that generate trial invoices with Oracle Business Intelligence Publisher (BI Publisher) 11g: -pay_type, which generates trial invoices separately for parent and subordinate accounts depending on the -pay_type payment method ID value. -retry, which runs billing on accounts that contained errors during the last trial billing run. See the discussion about the pin_trial_bill_accts utility in BRM Configuring and Running Billing.
pin_wsdl_generator	(Patch Set 8) Modified to generate the opcode schema (XSD files) for Web services that take payload as an XML element data type. See the discussion about the pin_wsdl_generator utility in BRM JCA Resource Adapter for more information.
RoamingConfigGen64	(Patch Set 7) Modified to include decimal places and country codes for both TAP and NRTRDE while creating the roaming configuration data file that is used by the Instances module to instantiate roaming registry sections or entries. See the discussion about the RoamingConfigGen64 utility in BRM Configuring Pipeline Rating and Discounting for more information.
pin_crypt_app	(Patch Set 6) Modified to support the new Oracle ZT PKI encryption algorithm options. See BRM Developer's Guide for more information on the new parameters.
pin_inv_doc_gen	(Patch Set 4) Modified to generate invoice documents and reports by integrating BRM with BI Publisher 11g. The changes that accompany the BI Publisher 11g integration are the following: The pin_inv_doc_gen utility is now installed when you install BRM; it is no longer a part of the BI Publisher invoicing integration package. The pin_inv_doc_gen utility uses Oracle WebLogic Server instead of the OC4J application server. The docgen.sh script has replaced BipEnv.bat as the file that runs pin_inv_doc_gen. The pin_inv_doc_gen utility is still supported with BI Publisher 10g. The pin_inv_doc_gen utility is installed with the BI Publisher 10g invoicing integration package, and it uses the OC4J application server. See the discussion about generating BI Publisher invoice documents in BRM Designing and Generating Invoices.
pin_amt	(Patch Set 3) Modified to publish the AccountInfoChange business event to the Oracle Advanced Queue (AQ) database queue by configuring the publish_migrated_objects entry in the BRM_Home/sys/amt/Infranet.properties file. See the discussion about integrating account migrations with your external application in a multischema environment in BRM Concepts.
pin_collections_process	(Patch Set 3) Modified to publish the CollectionsInfoChange business event to the AQ queue. See the discussion about creating CollectionsInfoChange business events in BRM Collections Manager.
load_config	(Patch Set 2) Modified to load the collections parameter information from the input XML file into the /config/collections/scenario_params object in the BRM database. See the discussion about collections scenarios in BRM Collections Manager.
pin_amt	(Patch Set 2) When this utility migrates accounts from a source BRM database schema to a destination BRM database schema, it now also migrates those account objects from the source Oracle IMDB Cache grid (associated with the source BRM database schema) to the destination Oracle IMDB Cache grid (associated with the destination BRM database schema). See the discussion about understanding Account Migration Manager in BRM System Administrator's Guide.
pin_collections_process	(Patch Set 2) Modified to support collections sharing groups. In addition, the utility now allows you to run collections for a specified bill unit by using the utility's new -billinfo BillInfoPOID parameter. See the discussion about collections scenarios in BRM Collections Manager.