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

Loading Oracle BRM Master Data to Oracle Billing Insight

You use a dedicated ODI extract and load process to load master data from Oracle BRM to the Oracle Billing Insight database. You load master data when initially integrating Oracle BRM and Oracle Billing Insight, and again as needed if your master data changes.

Master data includes payment types, adjustment types, charge type and sub-charge type, product and sub-product info, tariff info, unit type and currency type. Master data contains DIM code and corresponding name information.

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

You must load Oracle BRM master data before provisioning account information and loading billing data.

This task is a step in Process of Setting Up and Integrating Oracle BRM With Oracle Billing Insight.

To load master data from Oracle BRM into Oracle Billing Insight

1. Log in to the Oracle Data Integrator as the repository owner.
2. On the Designer tab, expand Load Plans and Scenarios, expand BRMProvider, 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:
   • BRMPROVIDER.pStartDate. When set to 'NULL' (in single quotation marks), the FROM_DATE value of EDX_INTG_PROVIDER_LOAD_CTRL table is used. The date format is YYYYMMDDHHMISS.
   • BRMPROVIDER.pEndDate - When set to 'NULL' (in single quotation marks), the sysdate of the Oracle BRM database is used. The date format is YYYYMMDDHHMISS

     To change a value, uncheck the Latest Value check box, and enter the new value. Enclose all string values in single quotation marks.

     Master data created or modified between the BRMPROVIDER.pStartDate variable (inclusive) and BRMPROVIDER.pEndDate variable (exclusive) loads into 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 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 BRM until the current run master data is either published or rejected.