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

Process of Integrating Oracle Billing Insight With Oracle Utilities Customer Care And Billing


The process of initial integration of Oracle Billing Insight with Oracle Utilities CC&B requires that you install and configure required software and load data in bulk.

To integrate Oracle Utilities CC&B with Oracle Billing Insight, perform the following tasks:

  1. Identify the integration solution you need to integrate Oracle Utilities CC&B data with Oracle Billing Insight for your deployment:
    • Loading Oracle Utilities CC&B data directly to Oracle Billing Insight database tables. Use this option if your Oracle Billing Insight database can access the Oracle Utilities CC&B database directly. This method uses CC&B Provider, which you configure to output Oracle Utilities CC&B billing data to a pre-staging schema installed on the Oracle Billing Insight database, and load the data directly to the Oracle Billing Insight database production tables. CC&B Provider makes use of specialized ODI processes described in this chapter.
    • Extracting Oracle Utilities CC&B data to flat text files. Use this option if your Oracle Billing Insight database does not have direct access to the Oracle Utilities CC&B database, such as if you have an On-Demand (cloud service) deployment of Oracle Billing Insight and Oracle Utilities CC&B is On-Premise. This integration solution uses CC&B Provider, which you configure to extract Oracle Utilities CC&B billing data into billing text files. CC&B Provider makes use of specialized ODI processes described in this chapter.

      You must then FTP the files to Oracle where the hosting team will use the standard Oracle Billing Insight ODI processes to load the billing text file into the Oracle Billing Insight database production tables. The standard Oracle Billing Insight ODI processes are described in Administration Guide for Oracle Billing Insight.

  2. Verify that your Oracle Utilities CC&B data conforms to the requirements of Oracle Billing Insight described in Assumptions About Oracle Utilities CC&B Data. For information about how Oracle Utilities CC&B data maps with Oracle Billing Insight, see Reference for Mapping of Oracle Utilities CC&B and Oracle Billing Insight Data Objects.
  3. Follow the steps in Process of Installing and Configuring Oracle Utilities CC&B Integration Components. (It is in the configuration of CC&B Provider that you specify Oracle Utilities CC&B data loading output to either files or tables.)

    For more information about CC&B Provider, see About CC&B Provider.

  4. Configuring Mapping Tables
  5. Loading CC&B Master Data to Oracle Billing Insight

    If you output Oracle Utilities CC&B master data to a flat file (you set the OUTPUT_TYPE property in the CCBProvider.properties file to FILE when configuring CC&B Provider), then also copy the generated master text files to the appropriate load input directory on your Oracle Billing Insight installation, and load the master data files using the standard ODI load processes described in Administration Guide for Oracle Billing Insight.

  6. Provisioning Oracle Utilities CC&B Account Data in Batch to Oracle Billing Insight
  7. Loading Oracle Utilities CC&B Postpay Data to Oracle Billing Insight

    If you output Oracle Utilities CC&B billing data to a flat file (you set the OUTPUT_TYPE property in the CCBProvider.properties file to FILE when configuring CC&B Provider), then FTP the generated billing files to the appropriate load input directory on your Oracle Billing Insight installation. The Oracle Service Cloud hosting team will load the billing data files using the standard ODI load processes described in Administration Guide for Oracle Billing Insight.

Integration Guide for Oracle Billing Insight Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Legal Notices.