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

Process of Loading Data from Oracle Utilities CC&B in a Live Production Environment

Once you have completed the initial process of integrating Oracle Utilities CC&B with Oracle Billing Insight, you perform the following tasks as needed to continuously load and synchronize data from Oracle Utilities CC&B to Oracle Billing Insight in a live production environment:

1. If there are changes to the Oracle Utilities CC&B service type configuration, then you must reconfigure the mapping tables in the pre-staging schema to reflect the changes. For details, see Configuring Mapping Tables.
2. If there are changes to master data in Oracle Utilities CC&B, then you must load the new data using the master data load ODI process. Master data includes payment types, adjustment types, charge type, usage type, tariff information, service type, unit type, country code, and currency type. For details, see 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, where the Oracle Cloud Service hosting team will load the master data files using the standard ODI load processes described in Administration Guide for Oracle Billing Insight.

3. Run the HierarchyCopy job at beginning of the each new billing period. For details, see Administration Guide for Oracle Billing Insight.
4. Synchronize new or updated Oracle Utilities CC&B account data in batch using the ProvisioningData job in the Oracle Billing Insight Command Center or by calling the RESTful WebService API. For details, see Administration Guide for Oracle Billing Insight.
5. Schedule CC&B Provider to initiate loading postpay data from Oracle Utilities CC&B to Oracle Billing Insight whenever the bill is generated in Oracle Utilities CC&B.

   If you output Oracle Utilities CC&B postpay 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 postpay billing files to the appropriate load input directory on your Oracle Billing Insight installation, where the Oracle Service Cloud hosting team will use the standard Oracle Billing Insight ODI processes to load the postpay billing text file into the Oracle Billing Insight database production tables. For details about the standard Oracle Billing Insight ODI processes, see Administration Guide for Oracle Billing Insight.