Bookshelf Home | Contents | Index | PDF     

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

Reference for Mapping of Oracle BRM and Oracle Billing Insight Data Objects

The following topics contain reference information about how Oracle BRM data objects map to major Oracle Billing Insight data objects, and how the data is handled during the extraction and synchronization:

Mapping of Oracle BRM Billing Data Objects With Oracle Billing Insight

The process of integrating Oracle BRM data requires provisioning of billing objects, such as company, account, service or device, and payment account, into Oracle Billing Insight. You can provision this data in either real-time or in batch.

In real-time provisioning, BRM Adapter processes the AQ events and creates objects in Oracle Billing Insight using RESTful Web Services. Table 6 lists the Oracle Billing Insight objects and the Oracle AQ events that BRM Adapter processes, the RESTful Web Service API, and the Oracle Billing Insight production tables that store these provisioning objects.

Table 6. Synchronization of Oracle Billing Insight Provisioning Objects
Oracle Billing Insight Object
Oracle AQ Event Name
Oracle Billing Insight RESTful API
Oracle Billing Insight Production Table Name
Notes
Company
/event/notification
/account/create
/accounts
EDX_OMF_COMPANY
CANON_
COMPANY maps to company ID
Account
/event/notification/account/create
/event/customer/billinfo/create
/accounts
EDX_OMF_ACCOUNT
A/R responsive accounts only
ACCOUNT_NO maps to account number
Service Agreement
/event/notification/service/create
/event/notification/service/modify
/event/device/associate
/event/billing/product/action/purchase
/serviceAgreements
EDX_OMF_SERVICEAGREEMENT
DEVICE_ID of number device maps to service agreement number
Billing Contact
/event/customer/nameinfo
/accounts
EDX_OMF_CONTACT_INFO
None
Payment Account
/event/audit/customer/payinfo/cc
/payment/pmtAccounts
PAYMENT_ACCOUNTS
Credit card only
Payment Transaction
/event/billing/payment/cc
/payment/transactions/external
EDX_PMT_EXT_PAYMENT
External payments to Oracle Billing Insight

Mapping of Oracle BRM Database Extraction Tables With Oracle Billing Insight

A subset of Oracle BRM data in 40 database tables are read, extracted, and mapped to Oracle Billing Insight. BRM Provider creates 37 tables in its schema as pre-staging tables. These pre-staging tables contain data with mirrored rows but columns that are simplified relative to the corresponding BRM tables. All 40 Oracle BRM tables, 37 Oracle Billing Insight pre-staging tables created by BRM Provider, and their mapping relationships are shown in Table 7. (It is recommended that you add indexes to existing Oracle BRM tables to improve extraction performance. For details on recommended indexes, see Table 8.)

Table 7. Mapping of Oracle BRM Database Tables With Pre-Staging Tables
Number
Oracle BRM Table
Oracle Billing Insight Pre-Staging Table
BRM Provider Procedure
1
ACCOUNT_NAMEINFO_T
BRM_ACCOUNT_NAMEINFO_T
pkg_intg_load_prestg_billing.pr_load_account_nameinfo
2
ACCOUNT_T
BRM_ACCOUNT_T
pkg_intg_load_prestg_billing.pr_load_account
3
BAL_GRP_SUB_BALS_T
BRM_BAL_GRP_SUB_BALS_T
pkg_intg_load_prestg_billing.pr_load_bal_grp_sub_bals
4
BAL_GRP_T
BRM_BAL_GRP_T
pkg_intg_load_prestg_billing.pr_load_bal_grp
5
BILL_T
BRM_BILL_T
pkg_intg_load_prestg_billing.pr_load_bill
6
BILLINFO_T
BRM_BILLINFO_T
pkg_intg_load_prestg_billing.pr_load_bill_info
7
CONFIG_BEID_BALANCES_T
BRM_CFG_BEID_BAL_T
pkg_intg_load_prestg_master.pr_load_cfg_beid_bal
8
CONFIG_BUS_PROFILE
_KEY_VALUE_T
BRM_CFG_BUS_PROF_KEY_VALUE_T
pkg_intg_load_prestg_master.pr_load_cfg_bus_prof
9
CONFIG_CANDIDATE_RUMS_T
BRM_CFG_CANDI_RUMS_T
pkg_intg_load_prestg_master.pr_load_cfg_rums
10
CONFIG_IMPACT_CATEGORIES_T
BRM_CFG_IMPACT_CAT_T
pkg_intg_load_prestg_master.pr_load_cfg_impact_ca
11
CONFIG_ITEM_TAG_T
BRM_CFG_ITEM_TAGS_T
pkg_intg_load_prestg_master.pr_load_cfg_item_tag
12
CONFIG_ITEM_TYPES_T
BRM_CFG_ITEM_TYPES_T
pkg_intg_load_prestg_master.pr_load_cfg_item_types
13
CONFIG_RUM_MAP_T
BRM_CFG_CANDI_RUMS_T
pkg_intg_load_prestg_master.pr_load_cfg_rums
14
CONFIG_T
BRM_CFG_T
pkg_intg_load_prestg_master.pr_load_cfg
15
DD_OBJECTS_T
BRM_DD_OBJECTS_T
pkg_intg_load_prestg_master.pr_load_dd_objects
16
DEAL_PRODUCTS_T
BRM_DEAL_PROD_T
pkg_intg_load_prestg_master.pr_load_deal_prod
17
DEAL_T
BRM_DEAL_T
pkg_intg_load_prestg_master.pr_load_deal
18
DEVICE_SERVICES_T
BRM_SERVICE_T
pkg_intg_load_prestg_billing.pr_load_service
19
DEVICE_T
BRM_SERVICE_T
pkg_intg_load_prestg_billing.pr_load_service
20
DISCOUNT_T
BRM_DISCOUNT_T
pkg_intg_load_prestg_master.pr_load_discount
21
DISCOUNT_USAGE_MAP_T
BRM_DISCOUNT_UGE_MAP_T
pkg_intg_load_prestg_master.pr_load_discount_usage
_map
22
EVENT_BAL_IMPACTS_T
BRM_EVT_BAL_IMPACTS_T
pkg_intg_load_prestg_billing.pr_load_event_bal_impact
23
EVENT_BILLING_PAYMENT_T
BRM_EVT_BILLING_PMT_T
pkg_intg_load_prestg_billing.pr_load_event_bill_pmt
24
EVENT_DLAY_SESS_TLCS_T
BRM_EVT_DL_SESS_TL_T
pkg_intg_load_prestg_billing.pr_load_evt_dl_sess_tlc
25
EVENT_DLYD_SESSION_TLCO
_GSM_T
BRM_EVT_DL_SESS_TL_GSM_T
pkg_intg_load_prestg_billing.pr_load_evt_dl_sess_tlc
_gsm
26
EVENT_PRODUCT_FEE_CYCLE_T
BRM_EVT_T
pkg_intg_load_prestg_billing.pr_load_event
27
EVENT_SESSION_TLCO_GSM_T
BRM_EVT_SESS_TL_GSM_T
pkg_intg_load_prestg_billing.pr_load_evt_sess_tlc_gsm
28
EVENT_SESSION_TLCS_T
BRM_EVT_SESS_TL_T
pkg_intg_load_prestg_billing.pr_load_evt_sess_tlc
29
EVENT_T
BRM_EVT_T
pkg_intg_load_prestg_billing.pr_load_event
30
EVENT_TAX_JURISDICTIONS_T
BRM_EVT_TAX_JURI_T
pkg_intg_load_prestg_billing.pr_load_event_tax_juris
31
GROUP_PRICELIST_MEMBERS_T
BRM_GROUP_PLANLIST_MEM_T
pkg_intg_load_prestg_master.pr_load_group_plan_mem
32
GROUP_T
BRM_GROUP_T
pkg_intg_load_prestg_master.pr_load_groups
33
ITEM_T
BRM_ITEM_T
pkg_intg_load_prestg_billing.pr_load_bill_item
34
PLAN_SERVICES_DETAILS_T
BRM_PLAN_SERV_DEALS_T
pkg_intg_load_prestg_master.pr_load_plan_serv_deal
35
PLAN_SERVICES_T
BRM_PLAN_SERV_T
pkg_intg_load_prestg_master.pr_load_plan_serv
36
PLAN_T
BRM_PLAN_T
pkg_intg_load_prestg_master.pr_load_plan
37
PRODUCT_T
BRM_PRODUCT_T
pkg_intg_load_prestg_master.pr_load_product
38
PRODUCT_USAGE_MAP_T
BRM_PRODUCT_UGE_MAP_T
pkg_intg_load_prestg_master.pr_load_product_usage
_map
39
PURCHASED_PRODUCT_T
BRM_PURCH_PRODUCT_T
pkg_intg_load_prestg_billing.pr_load_purchased
_product
40
SERVICE_T
BRM_SERVICE_T
pkg_intg_load_prestg_billing.pr_load_service

Recommended Indexes on Oracle BRM Database Tables

When BRM Provider extracts Oracle BRM data, the query uses a date and time range parameter. To improve the performance of the query, it is recommended that you create indexes on the Oracle BRM database tables listed in Table 8.

Table 8. Indexes Recommended on Oracle BRM Database Tables
Number
Oracle BRM Table Name
Index Column Name
1
ACCOUNT_T
CREATED_T
2
SERVICE_T
CREATED_T
3
SERVICE_T
MOD_T
4
PURCHASED_PRODUCT_T
CREATED_T
5
PURCHASED_PRODUCT_T
MOD_T
6
BILLINFO_T
CREATED_T
7
BILLINFO_T
MOD_T
8
BILLINFO_T
POID_ID0, BUSINESS_PROFILE_OBJ_ID0
9
BAL_GRP_T
CREATED_T
10
BAL_GRP_T
MOD_T
11
BILL_T
CREATED_T, MOD_T, END_T
12
BILL_T
END_T, BILLINFO_OBJ_ID0, ACCOUNT_OBJ_ID0, POID_ID0
13
ITEM_T
CREATED_T, MOD_T
14
ITEM_T
POID_ID0, BILL_OBJ_ID0
15
ITEM_T
POID_ID0, POID_TYPE, CREATED_T, ACCOUNT_OBJ_ID0
16
EVENT_T (Local partitioned index)
END_T
17
EVENT_PRODUCT_FEE_CYCLE_T
(Local partitioned index)
OBJ_ID0, CYCLE_START_T, CYCLE_END_

Mapping of Pre-Staged Oracle BRM Master Data With Oracle Billing Insight

The Oracle Billing Insight data loading process accepts two types of input data: master data and billing data. BRM Provider loads data from Oracle BRM tables into pre-staging tables, and then transforms this data and loads it into flat files or staging tables for Oracle Billing Insight data loading. Table 9 shows how master data from Oracle Billing Insight pre-staging tables maps to production tables and to file record types. (Mappings for billing transaction data are shown in Table 10.)

Table 9. Mapping of Pre-Staged Master Data With Oracle Billing Insight
BRM Provider Pre-Staging Table
Transformation Procedure
Oracle Billing Insight Production Table
Oracle Billing Insight File Input Record Type
BRM_DD_OBJECTS_T
pkg_intg_load_stage_master.pr_load_100_pmt_type
EDX_RPT_PAYMENT_TYPE_DIM
100 - Payment type
BRM_DD_OBJECTS_T
pkg_intg_load_stage_master.pr_load_110_adjust_type
EDX_RPT_ADJUSTMENT_TYPE_DIM
110 - Adjustment type
BRM_CFG_ITEM_TYPES_T
BRM_DISCOUNT_T

Tax
pkg_intg_load_stage_master.pr_load_120_charge_type
pr_populate_master_records
EDX_RPT_CHARGE_TYPE_DIM
120 - Charge type
BRM_CFG_ITEM_TYPES_T

Tax jurisdiction
pkg_intg_load_stage_master.pr_load_130_subcharge_type
pr_populate_master_records
EDX_RPT_SUB_CHARGE_TYPE_DIM
130 - Sub charge type
BRM_PLAN_T
BRM_PLAN_SERV_T
BRM_PLAN_SERV_DEALS_T
BRM_DEAL_T
BRM_DEAL_PROD_T
BRM_PRODUCT_T
BRM_GROUP_T
BRM_GROUP_PLANLIST_MEM_T
pkg_intg_load_stage_master.pr_load_150_prod_subprod
EDX_RPT_PRODUCT_DIM
EDX_RPT_SUB_PRODUCT_DIM
150 - Product, sub product
BRM_CFG_IMPACT_CAT_T
pkg_intg_load_stage_master.pr_load_170_tariff_code
EDX_RPT_TARIFF_DIM
170 - Tariff
BRM_CFG_CANDI_RUMS_T
pkg_intg_load_stage_master.pr_load_220_unit_type
EDX_RPT_UNIT_DIM
220 - Unit
Direction
pkg_intg_load_stage_master.pr_populate
_master_records
EDX_RPT_DIRECTION_DIM
240 - Direction
BRM_CFG_BEID_BAL_T
pkg_intg_load_stage_master.pr_load_270_currency
EDX_RPT_CURRENCY_DIM
270 - Currency

Mapping of Pre-Staged Oracle BRM Billing Transaction Data With Oracle Billing Insight

Table 10 shows how billing transaction data from Oracle Billing Insight pre-staging tables maps to production tables and to file record types. Only critical pre-staging tables are listed for each record type.

Table 10. Mapping of Pre-Staged Billing Transaction Data With Oracle Billing Insight
BRM Provider Pre-Staging Table
Transformation Procedure
Oracle Billing Insight Table
Oracle Billing Insight File Input Record Type
BRM_BILL_T
BRM_EVT_BAL_IMPACTS_T
BRM_EVT_BILLING_PMT_T
pkg_intg_load_stage_billing.
pr_load_1000_stmt
EDX_RPT_STATEMENT_FACT
1000 - Statement
BRM_BILL_T
BRM_ITEM_T
BRM_EVT_BILLING_PMT_T
pkg_intg_load_stage_billing.
pr_load_1100_stmtpmt
EDX_RPT_STATEMENT_PAYMENT_FACT
1100 - Statement Payment
BRM_BILL_T
BRM_ITEM_T
BRM_EVT_T
BRM_EVT_BAL_IMPACTS_T
pkg_intg_load_stage_billing.
pr_load_1200_stmtadj
EDX_RPT_STATEMENT_ADJUSTMENT_FACT
1200 - Statement Adjustment
BRM_BILL_T
BRM_ACCOUNT_NAMEINFO_T
pkg_intg_load_stage_billing.
pr_load_1300_address
EDX_RPT_ADDRESS_DIM
1300 - Mail-to Address
BRM_BILL_T
BRM_ITEM_T
BRM_EVT_BAL_IMPACTS_T
pkg_intg_load_stage_billing.
pr_load_2000_account_a
pr_load_2000_account_s
EDX_RPT_ACCOUNT_FACT
2000 - Account charges
BRM_BILL_T
BRM_ITEM_T
BRM_EVT_BAL_IMPACTS_T
pkg_intg_load_stage_billing.
pr_load_2100_acctcharge
EDX_RPT_ACCOUNT_CHARGE_FACT
2100 - Account charges at charge type level
BRM_BILL_T
BRM_ITEM_T
BRM_EVT_BAL_IMPACTS_T
pkg_intg_load_stage_billing.
pr_load_3000_service
EDX_RPT_SERVICE_FACT
3000 - Service charges
BRM_BILL_T
BRM_ITEM_T
BRM_EVT_BAL_IMPACTS_T
pkg_intg_load_stage_billing.
pr_load_3100_servcharge
EDX_RPT_SERVICE_CHARGE_FACT
3100 - Service charge at charge type level
BRM_BILL_T
BRM_ITEM_T
BRM_EVT_BAL_IMPACTS_T
BRM_PURCH_PRODUCT_T
pkg_intg_load_stage_billing.
pr_load_3200_servprod
EDX_RPT_SERVICE_PRODUCT_FACT
3200 - Service charge at product level
BRM_BILL_T
BRM_ITEM_T
BRM_EVT_BAL_IMPACTS_T
pkg_intg_load_stage_billing.
pr_load_3300_servusage
EDX_RPT_SERVICE_USAGE_FACT
3300 - Service charge at usage level
BRM_BILL_T
BRM_ITEM_T
BRM_EVT_BAL_IMPACTS_T
pkg_intg_load_stage_billing.
pr_load_3400_servtariff
EDX_RPT_SERVICE_TARIFF_FACT
3400 - Service charge at tariff level
BRM_BILL_T
BRM_ITEM_T
BRM_EVT_BAL_IMPACTS_T
BRM_EVT_DL_SESS_TL_T
BRM_EVT_DL_SESS_TL_GSM_T
pkg_intg_load_stage_billing.
pr_load_4000_cdr
EDX_RPT_SERVICE_DETAIL_FACT
4000 - Service detail
BRM_EVT_BAL_IMPACTS_T
BRM_EVT_DL_SESS_TL_T
BRM_EVT_DL_SESS_TL_GSM_T
pkg_intg_load_stage_billing.
pr_load_4000_cdr
EDX_RPT_UNBILLED_DETAIL_FACT
4900 - Unbilled detail
BRM_EVT_BAL_IMPACTS_T
BRM_EVT_BILLING_PMT_T
BRM_BAL_GRP_T
BRM_BAL_GRP_SUB_BALS_T
pkg_intg_load_stage_billing.
pr_load_9000_pp_account
EDX_RPT_PREPAY_ACCOUNT_FACT
9000- Prepaid charges
BRM_ITEM_T
BRM_EVT_BAL_IMPACTS_T
BRM_PURCH_PRODUCT_T
pkg_intg_load_stage_billing.
pr_load_9200_pp_product
EDX_RPT_PREPAY_PRODUCT_FACT
9200 - Prepaid charges at product level
BRM_ITEM_T
BRM_EVT_T
BRM_EVT_ BAL_IMPACTS_T
BRM_EVT_SESS_TL_T
BRM_EVT_SESS_TL_GSM_T
pkg_intg_load_stage_billing.
pr_load_9500_pp_cdr
EDX_RPT_PREPAY_DETAIL_FACT
9500 - Prepaid details

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