Setting Up Billing in a Multischema Environment

20 Setting Up Billing in a Multischema Environment

Learn how to set up billing in an Oracle Communications Billing and Revenue Management (BRM) multischema environment.

Topics in this document:

Setting Up Billing to Run in a Multischema Environment

You can run billing in a multischema BRM environment on one database schema at a time by using one instance of the billing utilities or on multiple schemas simultaneously by using multiple instances of the billing utilities. In other words, to bill accounts on a specific database schema, you must run the billing utilities from that database schema.

For instance, to bill accounts that reside on the primary and secondary database schemas, you can run the billing utilities from the primary schema to bill the accounts that reside on the primary database schema and run another instance of the billing utilities from the secondary schema to bill the accounts that reside on the secondary database schema.

Note:

When running the pin_bill_day script with the -file option, ensure that the accounts specified in the billing run configuration file reside on the same database schema where pin_bill_day is run. If the file contains accounts from different database schemas, pin_bill_day reports an error.

Running Billing on One Schema at a Time

Running billing utilities on multiple database schemas one at a time requires that you edit the billing utility configuration file before each time you run the billing utilities. Perform the following steps before each time you run billing:

Open the billing utility configuration file (BRM_home/apps/pin_billd/pin.conf) in a text editor.
Change the value of the userid entry to the database schema against which you want to run billing. For example, to run billing on the 0.0.0.2 schema, change the userid entry as follows:
```
- - userid 0.0.0.2 /service/pcm_client 1
```
Change the value of the login_name entry to an account that resides in the schema against which you want to run billing. For example, to run billing using the account root.0.0.0.2, change the login_name entry as follows:
```
- nap login_name root.0.0.0.2
```
Save the file.
Run the billing utilities.

Running Billing on Multiple Schemas Simultaneously

Running billing on multiple database schemas simultaneously requires that you create parallel instances of the billing utility configuration files, each of which is configured for a particular schema. Then you run all instances of your billing utilities.

For each schema that you want to run billing on, create a subdirectory under BRM_home/apps/pin_billd.

For example, BRM_home/apps/pin_billd/db1 for database 1, BRM_home/apps/pin_billd/db2 for database2, and so on.
Copy the BRM_home/apps/pin_billd/pin.conf file into each new subdirectory.
In each billing subdirectory, do the following:
1. Open the pin.conf file.
2. Change the database number in the login_name entry to a database account that resides in the schema against which you want to run billing. For example, to run billing against schema 0.0.0.2, change the login_name entry as follows:
```
- nap login_name root.0.0.0.2
```
3. Save the file.
Run the billing utilities from the new subdirectories.