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

Loading CC&B Master Data to Oracle Billing Insight

You use a dedicated extract and load process to load Oracle Utilities CC&B master data directly to Oracle Billing Insight or to load into a master data file, depending on the output type you chose when installing CC&B Provider (TABLE or FILE). You use this process to load master data in bulk when performing the initial integration of Oracle Utilities CC&B and Oracle Billing Insight.

Master data includes payment types, adjustment types, charge type, usage type, tariff info, service type, unit type, country code and currency type. Master data contains DIM code and corresponding name information.

You load master data when initially integrating Oracle Utilities CC&B and Oracle Billing Insight and again as needed if your master data changes.

Master data cannot be rejected once it is loaded. Only one data load process is allowed at a time.

You must load Oracle Utilities CC&B master data before provisioning account information and loading billing data.

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

To load master data from Oracle Utilities CC&B to Oracle Billing Insight (or to a file)

1. Log in to the Oracle Data Integrator as the repository owner.
2. On the Designer tab, expand Load Plans and Scenarios, expand CCBProvider, and expand DATA_LOAD.
3. Right click LOADMASTERDATA Version 001 and click Run.
4. Select ODIAgent from the Logical Agent drop-down list.
5. Specify 'NULL' in the Value field for the following variables in the Variable Values dialog. Enclose all string values in single quotation marks.
   • CCBPROVIDER.pStartDate. Always set to 'NULL'.
   • CCBPROVIDER.pEndDate. Always set to 'NULL'.

     Master data will be included in the output, generated in the format specified in your CC&B Provider configuration:

   • To a Table. When the output type configured in CC&B Provider is TABLE, master data loads directly into an Oracle Billing Insight DIM table.
   • To a File. When the output type configured in CC&B Provider is FILE, master data is generated to a text file in the location you specify in the PROV_BILLFILE_LOCATION parameter. You must upload (FTP) this file to the Oracle Billing Insight database server, where the Oracle Service Cloud 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. For details about standard Oracle Billing Insight ODI processes, see Administration Guide for Oracle Billing Insight.
6. If you want to automatically reject a load when an error occurs, set the global variable 06_Auto_Reject to 'Y' (in single quotation marks).

   If a load fails, automatic rejection clears the data from the associated staging tables and the data load log will show the discrepancy between the number of records inserted in the staging table and production fact tables. If a failure occurs when using this option, then you will no longer be able to reference the data in the staging tables. If you are generating Oracle Utilities CC&B output to files, automatic rejection removes files from the PROV_BILLFILE_LOCATION and PROV_TMPFILE_LOCATION directories if files exist.

   If you specify 'N' to suppress this feature, you can reference the staging table data if a failure occurs. After successfully determining the cause of the failure, you must manually reject the data load. No other master data can be loaded from Oracle Utilities CC&B until the current run master data is either published or rejected.

   In the Oracle Billing Insight OLAP.EDX_RPT_CURRENCY_TYPE_DIM table, be sure to select your default currency and set the CURRENCY_IS_DEFAULT field to Y for the selected default currency code.