Integration Guide for Oracle Billing Insight > Integrating Oracle Billing Insight With Oracle BRM >

Provisioning Oracle BRM Account Data in Batch to Oracle Billing Insight

This task describes how to load all existing company, account, and service-device data from the Oracle BRM database for initial integration into Oracle Billing Insight using a provided PL/SQL script.

NOTE:  In a live production environment, you use BRM AQAdapter to provision new company, account, and service data in real time. For details, see Provisioning Oracle BRM Account Data in Real-Time to Oracle Billing Insight Using BRM AQAdapter.

CAUTION:  The combination of the "CORPACCNO", "CORPTAXID", "STREET", "CITY", "STATE", and "ZIPCODE" fields must be unique, or the load will fail due to a unique constraints violation. Oracle BRM does not have this restriction.

This task is a step in Process of Setting Up and Integrating Oracle BRM With Oracle Billing Insight.

To export a batch provisioning file from Oracle BRM database to Oracle Billing Insight

1. Connect to the Oracle BRM database.
2. Run the ExportProvisioningFile.sql script, located in the EDX_HOME/integration/db/provider/brm/Scripts/ directory.
3. For the biller ID input parameter, specify the value you configured for the BRM_BILLER_ID parameter in the BRMProvider.properties file, such as BRM_BILLER_ID=BRM. For example:

   sqlplus pin_1/BRM_schema_password@PINDB @ExportProvisioningFile BRM

4. The script generates a file named PROV_BILLING_XXXXXXXXXXXXXX.DAT in the same directory. Change XXXXXXXXXXXXXX in the file name to the timestamp, such as 20150610080000.
5. Process this DAT file using the ProvisioningData job in the Oracle Billing Insight Command Center to load accounts and services into Oracle Billing Insight. For details, see Administration Guide for Oracle Billing Insight.