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

Configuring Mapping Tables

You must configure the following mapping tables before you can load data from Oracle Utilities CC&B to Oracle Billing Insight:

• EDX_INTG_SVS_MAP (Service type mapping)
• EDX_INTG_PARTN_COMP_MAP (Company mapping)
• EDX_INTG_PARTN_ACCT_MAP (Account mapping)
• EDX_INTG_PERIOD_DIM (Billing period mapping)

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

To configure the mapping tables for data loading

1. Populate the EDX_INTG_SVS_MAP table with values for service type, either:
   • One-off charge service (O), or
   • Recurring charge service (R).

     For details, see About the Service Type Mapping Table.

2. If you set the OUTPUT_TYPE property in the CCBProvider.properties file to FILE when configuring CC&B Provider, then synchronize the data from the following Oracle Billing Insight tables to the specified mapping table.

   Oracle Billing Insight OLAP Database Table	Mapping Table
   EDX_RPT_PARTN_COMP_MAP	EDX_INTG_PARTN_COMP_MAP
   EDX_RPT_PARTN_ACCT_MAP	EDX_INTG_PARTN_ACCT_MAP
   EDX_RPT_PERIOD_DIM	EDX_INTG_PERIOD_DIM