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

Process of Loading Data from Oracle BRM in a Live Production Environment


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

  • Synchronize new or updated Oracle BRM account data in real-time using RESTful Web services with BRM AQAdapter. You can provision account contact information, payment accounts for credit card cards, and payment transactions in real-time using RESTful Web services. For more information, see Provisioning Oracle BRM Account Data in Real-Time to Oracle Billing Insight Using BRM AQAdapter.
  • Run the HierarchyCopy job at beginning of the each new billing period. For details, see Administration Guide for Oracle Billing Insight.
  • Schedule BRM Provider to initiate loading postpaid data from Oracle BRM to Oracle Billing Insight whenever the bill utility is run in Oracle BRM. Once configured, the pin_bill_day utility triggers the custom billRun event, and BRM AQAdapter processes the loading of postpay billing data from Oracle BRM to Oracle Billing Insight. (You can schedule BRM Provider to automatically initiate the postpaid data load while configuring BRM Provider. For details, see Installing and Configuring BRM Provider.)
  • Schedule unbilled (CDR) and prepay data (including last top up, current balance, expiry data, CDR data, and so on) to be loaded by BRM Provider in configurable time periods. The default time interval is every 15 minutes. For details, see Scheduling Unbilled and Prepaid Data Loading.
  • If there are changes to the Oracle BRM bill item configuration, then you must reconfigure the mapping tables in the pre-staging schema to reflect the changes. For details, seeConfiguring Mapping Tables.
  • If there are changes to master data in Oracle BRM, then you must load the new data using the master data load ODI process. Master data includes payment types, adjustment types, charge type and sub charge type, product and sub-product information, tariff information, unit type and currency type. For details, see Loading Oracle BRM Master Data to Oracle Billing Insight.

Integration Guide for Oracle Billing Insight Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices.