Integration Guide for Oracle Billing Insight > Integrating Oracle Billing Insight With Oracle BRM >

Configuring Mapping Tables

You must configure the following mapping tables before you can load data from Oracle BRM to Oracle Billing Insight:

• PRESTG_BRM_ITEM_MASTER_MAP (Item mapping)
• EDX_INTG_PROVIDER_RESOURCE (Resource 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 BRM With Oracle Billing Insight.

To configure the mapping tables for data loading

1. Populate the PRESTG_BRM_ITEM_MASTER_MAP table with the values to map the Oracle BRM bill items for your implementation to the usage types and charge types in Oracle Billing Insight. For details, see About the Item Mapping Table.
2. Populate the EDX_INTG_PROVIDER_RESOURCE table with the code-name pairs for master data in Oracle Billing Insight. For details, see About the Resource Mapping Table.
3. If you set the OUTPUT_TYPE property in the BRMProvider.properties file to FILE when configuring BRM Provider, 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