Integration Guide for Oracle Billing Insight > Integrating Oracle Billing Insight With Oracle Utilities Customer Care And Billing >

Provisioning Oracle Utilities CC&B Account Data in Batch to Oracle Billing Insight

This task describes how to load all existing company, account, and service or meter data from the Oracle Utilities CC&B database for initial integration into Oracle Billing Insight using a provided PL/SQL script.

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 Utilities CC&B does not have this restriction.

This task is a step in Process of Integrating Oracle Billing Insight With Oracle Utilities Customer Care And Billing.

To export a batch provisioning file from Oracle Utilities CC&B database to Oracle Billing Insight

1. Connect to the Oracle Utilities CC&B database.
2. Edit the ExportProvisioningFile.sql script, located in the INTG_HOME/integration/ccb/db/provider/ccb/Scripts/ directory. Edit the script to extract service agreements with recurring charges only (as indicated in the service mapping table EDX_INTG_SVS_MAP). Change line 166 to exclude the service type codes where the mapped value in the SVR_CODE field is set to 'O':

   where svc_type_cd not in ('O', 'M')

   For details, see About the Service Type Mapping Table.

3. Run the ExportProvisioningFile.sql script. Specify the following parameters:
   1. For the biller ID input parameter, specify the value you configured for the BILLER_ID parameter in the CCBProvider.properties file, such as BILLER_ID=CCB.
   2. For the billing data start date, specify the value you configured for the BILLING_DATA_START_DT parameter in the CCBProvider.properties file.

      For example:

   sqlplus CCB_schema_owner/CCB_schema_password@CCBDB @ExportProvisioningFile CCB 01/01/2015

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.