Skip Headers
Oracle® Communications Data Model Adapters and Analytics User's Guide
Release 11.3.2

E37699-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

3 BRM Adapter Reference

This chapter contains the following BRM Adapter reference information:

BRM Source and Oracle Communications Data Model Target Tables

Table 3-1 shows the Oracle Communications Data Model target tables and the associated source tables for the BRM Adapter.

Table 3-1 Target Oracle Communications Data Model Tables for BRM Adapter

BRM Source Table Oracle Communications Data Model Target Table
 

DWB_ACCT_BAL

 

DWB_ACCT_BAL_IMPC

 

DWB_ACCT_DEBT

 

DWB_ACCT_PYMT

 

DWB_BRDBND_USG_EVT

 

DWB_CRNCY_EXCHNG_RATE

 

DWB_DATA_SRVC_EVT

 

DWB_GPRS_USG_EVT

 

DWB_INVC

 

DWB_INVC_ADJ

 

DWB_INVC_DISC

 

DWB_INVC_ITEM

 

DWB_INVC_PYMT_ASGN

 

DWB_SMS_EVT

 

DWB_SRVC_STAT_HIST

 

DWB_WRLS_CALL_EVT

 

DWL_ACCT_BAL_TYP

 

DWL_CALL_SRVC_TYP

 

DWL_COLLCTN_TYP

 

DWL_CRNCY

 

DWL_CUST_TYP

 

DWL_PK_OFPK_TIME

 

DWL_PROD_SPEC_TYP

 

DWR_ACCT

 

DWR_ACCT_BAL_GRP

 

DWR_ACCT_PREF_INVC_DLVRY

 

DWR_ACCT_PYMT_MTHD

 

DWR_ACCT_SGMNT

 

DWR_AGRMNT

 

DWR_AGRMNT_ITEM

 

DWR_CUST

 

DWR_CUST_ADDR

 

DWR_CUST_FCNG_SRVC

 

DWR_PROD_CTLG

 

DWR_PROD_CTLG_PROD_OFR_ASGN

 

DWR_PROD_OFR

 

DWR_PROD_OFR_PRICE

 

DWR_PROD_OFR_PROD_SPEC_ASGN

 

DWR_PROD_SBRP

 

DWR_PROD_SBRP_PRICE

 

DWR_PROD_SPEC

 

DWR_PRTY

 

DWR_PRTY_CNCT_INFO

 

DWR_SRVC

 

DWR_SRVC_SPEC

 

DWR_SRVC_SPEC_CHAR

 

DWR_SRVC_SPEC_PROD_SPEC_RLTN

 

DWR_VAL_ADD_SRVC


BRM Adapter ODI BRM_OCDM Project

This section describes the internal operations performed by each executable object mentioned in "Performing an Initial Load with the BRM Adapter for Oracle Communications Data Model" and "Performing Data Refresh with the BRM Adapter for Oracle Communications Data Model (Change Data Capture: CDC)".

Objects in SRC_STG_NONOGG Folder of BRM_OCDM Project

SRC_STG_LOAD_NON_OGG_PKG Package

The SRC_STG_LOAD_NON_OGG_PKG package in SRC_STG_NONOGG folder of BRM_OCDM project is using to load data into BRM staging database from BRM source database. Following steps were included in this process of loading staging database.

  1. Execute PRE_STAGING_LOAD procedure to load previous day tables (XXX_LD). This procedure performs following operations:

    1. Drop Previous Day Tables (XXX_LD)

    2. Rename normal staging tables (XXX) to previous day tables (XXX_LD)

    3. Create normal staging tables (XXX) structure from previous day tables (XXX_LD)

    (Drop XXX_LD -> rename XXX to XXX_LD ->Create XXX from XXX_LD).

  2. Execute Non Golden Gate Interfaces (XXX_NONGG) one by one to load normal staging tables (XXX).

    There are 101 Non Golden Gate Interfaces out of which 51 have the naming convention (XXX_NONGG) and the other 51 use the naming convention (XXX_NONGG_IU); these are executed in sequence to load Staging tables form Source tables (src.XXX to stg.XXX).

    SRC_STG_NONGG Interfaces:

    ACCOUNT_NAMEINFO_T_NONGG_IU
    ACCOUNT_T_NONGG_IU
    BAL_GRP_BALS_T_NONOGG_IU
    BAL_GRP_SUB_BALS_T_NONOGG_IU
    BAL_GRP_T_NONGG_IU
    BILLINFO_T_NONGG_IU
    BILL_T_NONGG_IU
    CFG_CREDIT_PROFILE_T_NONOGG_IU
    COLLECTIONS_ACTION_T_NONOGG_IU
    COLLECTIONS_SCENARIO_T_NONOGG_IU
    CONFIG_BEID_BALANCES_T_NONGG_IU
    CONFIG_BILLING_SEGMENT_T_NOOGG_IU
    CONFIG_BUSINESS_TYPE_T_NONGG_IU
    CONFIG_COLLECTIONS_SCENARIO_T_NONOGG_IU
    CONFIG_CUR_CONV_RATES_T_NONGG_IU
    CONFIG_PAYMENT_PAY_TYPES_T_NONGG_IU
    CONFIG_T_NONGG_IU
    DD_OBJECTS_T_NONGG_IU
    DEAL_DISCOUNTS_T_D_NONGG_IU
    DEAL_PRODUCTS_T_NONGG_IU
    DEAL_T_NONGG_IU
    DISCOUNT_T_NONGG_IU
    EVENT_ACTIVITY_TLCS_T_NONGG_IU
    EVENT_ACTV_TLCS_SVC_CODES_T_NONGG_IU
    EVENT_BAL_IMPACTS_T_NONGG_IU
    EVENT_BILLING_MISC_T_NONGG_IU
    EVENT_BILLING_PAYMENT_CASH_T_NONGG_IU
    EVENT_BILLING_PAYMENT_CC_T_NONGG_IU
    EVENT_BILLING_PAYMENT_CHECK_T_NONGG_IU
    EVENT_BILLING_PAYMENT_DD_T_NONGG_IU
    EVENT_BILLING_PAYMENT_FAILED_T_NONGG_IU
    EVENT_BILLING_PAYMENT_PAYORD_T_NONGG_IU
    EVENT_BILLING_PAYMENT_POST_T_NONGG_IU
    EVENT_BILLING_PAYMENT_T_NONGG_IU
    EVENT_BILLING_PAYMENT_WTRAN_T_NONGG_IU
    EVENT_BROADBAND_USAGE_T_NONGG_IU
    EVENT_DLAY_ACTV_TLCS_SVC_CDS_T_NONGG_IU
    EVENT_DLAY_ACTV_TLCS_T_NONGG_IU
    EVENT_DLAY_SESS_TLCS_SVC_CDS_T_NONGG_IU
    EVENT_DLAY_SESS_TLCS_T_NONGG_IU
    EVENT_DLYD_SESSION_TLCO_GPRS_T_NONGG_IU
    EVENT_DLYD_SESSION_TLCO_GSM_T_NONGG_IU
    EVENT_ITEM_TRANSFER_T_NONGG_IU
    EVENT_RUM_MAP_T_NONGG_IU
    EVENT_SESSION_DIALUP_T_NONGG_IU
    EVENT_SESSION_TELCO_GPRS_T_NONGG_IU
    EVENT_SESSION_TLCO_GSM_T_NONGG_IU
    EVENT_SESSION_TLCS_T_NONGG_IU
    EVENT_SESS_TLCS_SVC_CODES_T_NONGG_IU
    EVENT_TAX_JURISDICTIONS_T_NONGG_IU
    EVENT_T_NONGG_IU
    ajkukuma: HISTORY_BILLS_INVOICES_T_NONGG_IU
    HISTORY_BILLS_ITEMS_T_NONGG_IU
    HISTORY_BILLS_T_NONGG_IU
    IFW_CURRENCY_NONGG_IU
    IFW_TIMEZONE_NONGG_IU
    IFW_USAGETYPE_NONGG_IU
    INVOICE_STATUSES_T_NONGG_IU
    INVOICE_T_NONGG_IU
    ITEM_T_NONGG_IU
    NOTE_T_NONGG_IU
    PAYINFO_CC_T_NONGG_IU
    PAYINFO_DD_T_NONGG_IU
    PAYINFO_INV_T_NONGG_IU
    PAYINFO_T_NONGG_IU
    PLAN_SERVICES_T_NONGG_IU
    PLAN_T_NONGG_IU
    PRODUCT_T_NONGG_IU
    PURCHASED_DISCOUNT_T_NONGG_IU
    PURCHASED_PRODUCT_T_NONGG_IU
    RATE_PLAN_T_NONGG_IU
    SERVICE_EMAIL_T_NONGG_IU
    SERVICE_TELCO_FEATURES_T_NONGG_IU
    SERVICE_TELCO_GPRS_T_NONGG_IU
    SERVICE_TELCO_GSM_T_NONGG_IU
    SERVICE_T_NONGG_IU
    
  3. Execute POST_STAGING_LOAD procedure to load the data into Delta Tables (XXX _DELTA) and Delta History Tables (XXX_DELTA_H).

    1. Truncate delta tables (XXX _DELTA)

    2. Insert data into delta tables (XXX _DELTA) from normal staging tables (XXX) and previous day tables (XXX_LD).

    3. Update delta tables (XXX _DELTA) columns according to the source changes (OPTYPE, LAST_UPDATE_TIME & CHANGE_DATE)

    4. Insert data into delta history tables(XXX_DELTA_H) from delta tables (XXX _DELTA)

    (Truncate XXX_DELTA -> Insert into XXX_DELTA from (XXX minus XXX_LD) -> Insert into XXX_DELTA_H from XXX_DELTA)

SRC_STG_LOAD_NON_OGG_PKG Package

The SRC_STG_LOAD_NON_OGG_PKG package in SRC_STG_NONOGG folder of BRM_OCDM project is using to load the staging delta and delta history tables. This package will call the PRE_OCDM_LOAD procedure and execute in an infinite loop. In each loop of iteration, it performs the following steps and loads the data into Delta Tables (XXX _DELTA) and Delta History Tables (XXX_DELTA_H).

  1. Insert data into delta history tables(XXX_DELTA_H) from delta tables (XXX _DELTA)

  2. Truncate delta tables (XXX _DELTA)

  3. Insert data into delta tables (XXX _DELTA) from normal staging tables (XXX)

  4. Wait for new data in any XXX _DELTA tables, ODI uses an tool called ODI WAIT FOR DATA which will be in the waiting state; the job of this Tool (ODI WAIT FOR DATA) will be waiting for any data changes in staging layer delta tables (XXX _DELTA).Once it finds any changes it will execute the concerned interface where the data will be populated into related OCDM foundation layer tables

(Insert into XXX_DELTA_H from XXX_DELTA and Truncate XXX_DELTA and Insert into XXX_DELTA from XXX)

Objects in STG_OCDM Folder of BRM_OCDM

STG_OCDM_INITIAL_LOAD_PKG Package

The STG_OCDM_INITIAL_LOAD_PKG package in STG_OCDM folder of BRM_OCDM project loads the OCDM foundation layer tables from BRM Staging Database delta tables (XXX _DELTA). The package STG_OCDM_INITIAL_LOAD_PKG executes 46 STG-OCDM interfaces (XXX_MAP) which are executed in sequence, where the data is populated into related OCDM foundation layer tables form staging delta tables (XXX _DELTA).

STG-OCDM Interfaces:

DWB_ACCT_BAL_IMPC_MAP
DWB_ACCT_BAL_MAP
DWB_ACCT_DEBT_MAP
DWB_ACCT_PYMT_MAP
DWB_BRDBND_USG_EVT_MAP
DWB_CRNCY_EXCHNG_RATE_MAP
DWB_DATA_SRVC_EVT_MAP (DIALUP)
DWB_DATA_SRVC_EVT_MAP (GSM POSTPAID)
DWB_DATA_SRVC_EVT_MAP (GSM PREPAID)
DWB_GPRS_USG_EVT_MAP (PostPaid)
DWB_GPRS_USG_EVT_MAP (PrePaid)
DWB_INVC_ADJ_MAP
DWB_INVC_DISC_MAP
DWB_INVC_ITEM_MAP
DWB_INVC_MAP
DWB_INVC_PYMT_ASGN_MAP
DWB_SMS_EVT_MAP (PostPaid)
DWB_SMS_EVT_MAP (PrePaid)
DWB_SRVC_STAT_HIST_MAP
DWB_WRLS_CALL_EVT_MAP (PrePaid)
DWB_WRLS_CALL_EVT_MAP(PostPaid)
DWL_ACCT_BAL_TYP_MAP
DWL_CALL_SRVC_TYP_MAP
DWL_COLLCTN_TYP_MAP
DWL_CRNCY_MAP
DWL_CUST_TYP_MAP
DWL_PK_OFPK_TIME_MAP
DWL_PROD_SPEC_TYP_MAP
DWR_ACCT_BAL_GRP_MAP
DWR_ACCT_MAP
DWR_ACCT_PREF_INVC_DLVRY_MAP
DWR_ACCT_PYMT_MTHD_MAP
DWR_ACCT_SGMNT
DWR_AGRMNT_ITEM_MAP
DWR_AGRMNT_MAP
DWR_CUST_ADDR_MAP
DWR_CUST_FCNG_SRVC_MAP
DWR_CUST_MAP
DWR_PROD_CTLG_MAP
DWR_PROD_CTLG_PROD_OFR_ASGN_MAP
DWR_PROD_OFR_MAP
DWR_PROD_OFR_PRICE_MAP
DWR_PROD_OFR_PROD_SPEC_ASGN_MAP
DWR_PROD_SBRP_MAP
DWR_PROD_SBRP_PRICE_MAP
DWR_PROD_SPEC_MAP (PRODUCT_T)
DWR_PRTY_CNCT_INFO_MAP
DWR_PRTY_MAP
DWR_PRTY_MAP (Payinfo_CC)
DWR_PRTY_MAP (Payinfo_DD)
DWR_PRTY_MAP (Payinfo_INV)
DWR_SRVC_MAP
DWR_SRVC_SPEC_CHAR_MAP
DWR_SRVC_SPEC_MAP
DWR_SRVC_SPEC_PROD_SPEC_RLTN_MAP
DWR_VAL_ADD_SRVC_MAP

STG_OCDM_OGG_CDC_LOAD_SCENARIO_PKG Package

The following mentioned STG_OCDM_OGG_CDC_LOAD_SCENARIO_PKG package in STG_OCDM folder of BRM_OCDM project executes the OCDM foundation layer tables population interfaces and these packages must be executed and should be in running mode.

Note:

STG_OCDM_OGG_CDC_LOAD_SCENARIO_PKG is a package which is having a package STG_OCDM_OGG_CDC_LOAD_PKG and a SCD2_UPDATE procedure, the scenario package is based on STG_OCDM_OGG_CDC_LOAD_PKG which consist of 46 interfaces and a procedure PRE_OCDM_LOAD. The STG_OCDM_OGG_CDC_LOAD_SCENARIO_PKG will be in an Infinite loop process which will wait for data to perform data load from stage(BRM_STG) to target (OCDM_SYS.)

BRM Adapter Staging Schema Objects (BRM_STG)

The BRM Adapter staging schema BRM_STG includes the following tables, views, functions, and procedures:

Staging Schema Tables

Corresponding to each Oracle Communications Billing and Revenue Management source table to be loaded, each of the following tables are created or updated in the staging schema:

  • Normal Staging Tables (XXX) (the table name is same as source table name)

  • Previous Day Tables (XXX_LD)

  • Delta Tables (XXX_D)

  • Delta History Tables (XXX_D_H)

  • Golden Gate Option Input Parameter Table (BRM_MAPPING_TAB)

  • Loading Parameter Table BRM_ETL_PARAMETER (having mainly From Date, To Date and Loading date)

Staging Schema Views

For each Oracle Communications Billing and Revenue Management source system view used in the BRM Adapter for Oracle Communications Data Model, two views are created in staging schema (BRM_STG), (XXX_ vw), with the names:

  • EVENT_BILLING_PAYMENT_T_MAP_VW

  • SERVICE_T_MAP_VW

Staging Schema Functions

For each Oracle Communications Billing and Revenue Management source system function used in the BRM Adapter for Oracle Communications Data Model (having name UTC_TO_ORACLE) is created in staging schema (BRM_STG).

Staging Schema Procedures

To maintain the everyday source data changes and history of the data changes three procedures are created in staging schema (BRM_STG) for both Golden Gate and Non-Golden Gate options:

  • PRE_STAGING_LOAD (For Oracle Golden Gate Option)

  • PRE_OCDM_LOAD (For Non - Oracle Golden Gate Option)

  • POST_STAGING_LOAD (For Oracle Golden Gate Option)