3 BRM Adapter Reference

This chapter provides the following information about the Oracle Communications Billing and Revenue Management Adapter for Oracle Communications Data Model (the BRM Adapter):

  • Mapping of Oracle Communications Billing and Revenue Management (BRM) source tables to Oracle Communications Data Model target tables.

  • BRM Adapter Oracle Data Integrator project

  • Schema definitions added by the BRM Adapter

BRM Source and Oracle Communications Data Model Target Tables

Table 3-1 shows the BRM source table and the Oracle Communications Data Model target table mapping.

Table 3-1 BRM Source to Oracle Communications Data Model Target Table Mapping

BRM Source Table Oracle Communications Data Model Target Table

CONFIG_T, CONFIG_BUSINESS_TYPE_T

DWL_CUST_TYP

CONFIG_T,CONFIG_BEID_BALANCES_T

DWL_ACCT_BAL_TYP

CONFIG_T, CONFIG_CUR_CONV_RATES_T

DWB_CRNCY_EXCHNG_RATE

IFW_TIMEZONE

DWL_PK_OFPK_TIME

IFW_CURRENCY

DWL_CRNCY

DD_OBJECTS_T

DWR_SRVC_SPEC

PRODUCT_T

DWR_PROD, DWR_SRVC_SPEC_PROD_RLTN

DISCOUNT_T

DWR_PROD, DWR_SRVC_SPEC_PROD_RLTN

RATE_PLAN_T

DWR_PROD_RTNG_PLN

DEAL_T

DWR_PROD

DEAL_PRODUCTS_T

DWR_PROD_PKG_ASGN

PLAN_T

DWR_PROD_MKT_PLN

PLAN_SERVICES_T

DWR_PROD_MKT_PLN_ASGN

SERVICE_T

DWR_SRVC, DWR_CUST_FCNG_SRVC, DWB_SRVC_STAT_HIST

SERVICE_T, SERVICE_TELCO_GSM_T

DWR_CUST_FCNG_SRVC

SERVICE_T, SERVICE_TELCO_GPRS_T

DWR_CUST_FCNG_SRVC

SERVICE_T, SERVICE_EMAIL_T

DWR_CUST_FCNG_SRVC

SERVICE_TELCO_FEATURES_T

DWR_SRVC_CHTRSTC

ACCOUNT_T, ACCOUNT_NAMEINFO_T

DWR_GEO_CNTRY, DWR_GEO_STATE, DWR_GEO_CITY, DWR_POSTCD, DWR_ADDR_LOC DWR_PRTY, DWR_PRTY_CNCT_INFO, DWR_CUST, DWR_ACCT, DWR_ACCT_PREF_INVC_DLVRY

BILLINFO_T

DWR_PRTY, DWR_CUST, DWR_ACCT, DWL_PYMT_MTHD_TYP

BAL_GRP_T

DWR_ACCT_BAL_GRP

PURCHASED_PRODUCT_T

DWR_SBRP, DWR_SBRP_PRICE_CHRG

PURCHASED_DISCOUNT_T

DWR_SBRP, DWR_SBRP_PRICE_CHRG

BILL_T

DWB_INVC

INVOICE_T

DWB_EVT_INVC_DLVRY

ITEM_T

DWB_INVC_ITEM

PAYINFO_T, PAYINFO_INV_T

DWR_GEO_CNTRY, DWR_GEO_STATE, DWR_GEO_CITY, DWR_POSTCD, DWR_ADDR_LOC, DWR_PRTY, DWR_ACCT_PREF_PYMT_MTHD

PAYINFO_T, PAYINFO_DD_T

DWR_PRTY, DWR_ACCT_PREF_PYMT_MTHD

PAYINFO_T,PAYINFO_CC_T

DWR_PRTY, DWR_ACCT_PREF_PYMT_MTHD

EVENT_T

used in all "NETWORK Event" type of mapping

EVENT_BAL_IMPACTS_T

used in all "NETWORK Event" type of mapping, DWB_NTWK_EVT_ACCT_BAL_IMPC (any events)

EVENT_SESSION_TLCS_T

used in all Prepaid/session "NETWORK Event" type of mapping

EVENT_SESS_TLCS_SVC_CODES_T

used in all Prepaid/session "NETWORK Event" type of mapping

EVENT_SESSION_TLCO_GSM_T

DWB_WRLS_CALL_EVT (Prepaid)

EVENT_SESSION_TELCO_GPRS_T

DWB_GPRS_USG_EVT (Prepaid)

EVENT_BROADBAND_USAGE_T

DWB_BRDBND_USG_EVT

EVENT_SESSION_DIALUP_T

DWB_DATA_SRVC_EVT

EVENT_DLAY_SESS_TLCS_T

used in all Postpaid/session "NETWORK Event" type of mapping

EVENT_DLAY_SESS_TLCS_SVC_CDS_T

used in all Postpaid/session "NETWORK Event" type of mapping

EVENT_DLYD_SESSION_TLCO_GPRS_T

DWB_GPRS_USG_EVT (Postpaid)

EVENT_DLYD_SESSION_TLCO_GSM_T

DWB_WRLS_CALL_EVT (Postpaid)

EVENT_ACTIVITY_TLCS_T

used in all Prepaid Activity "NETWORK Event" type of mapping

EVENT_ACTV_TLCS_SVC_CODES_T

used in all Prepaid Activity "NETWORK Event" type of mapping

EVENT_DLAY_ACTV_TLCS_SVC_CDS_T

E_DLAY_ACT_TLCS_SVC_CDS_T_D

EVENT_DLAY_ACTV_TLCS_T

EVENT_DLAY_ACTV_TLCS_T_D

EVENT_TAX_JURISDICTIONS_T

EVENT_TAX_JURISDICTIONS_T_D

EVENT_RUM_MAP_T

EVENT_RUM_MAP_T_D

EVENT_BILLING_PAYMENT_T

DWB_ACCT_RCHRG

EVENT_BILLING_PAYMENT_DD_T

DWB_ACCT_RCHRG

EVENT_BILLING_PAYMENT_CASH_T

DWB_ACCT_RCHRG

EVENT_BILLING_PAYMENT_CC_T

DWB_ACCT_RCHRG

EVENT_BILLING_PAYMENT_CHECK_T

DWB_ACCT_RCHRG

EVENT_BILLING_PAYMENT_FAILED_T

DWB_ACCT_RCHRG

EVENT_BILLING_PAYMENT_PAYORD_T

DWB_ACCT_RCHRG

EVENT_BILLING_PAYMENT_POST_T

DWB_ACCT_RCHRG

EVENT_BILLING_PAYMENT_WTRAN_T

DWB_ACCT_RCHRG

NOTE_T

DWB_EVT_PRTY_INTRACN

BAL_GRP_T_D, BAL_GRP_BALS_T_D, BAL_GRP_SUB_BALS_T_D

DWB_ACCT_BAL

EVENT_BAL_IMPACTS_T_D, EVENT_T_D, EVENT_BILLING_MISC_T_D

DWB_ACCT_BAL_IMPC

DWL_COLLCTN_TYP, COLLECTIONS_SCENARIO_T_D, DWR_ACCT

DWB_ACCT_DEBT

DWR_ADDR_LOC, DWR_CUST, DWB_INVC_ITEM

DWB_ACCT_PYMT

EVENT_ITEM_TRANSFER_T_D, EVENT_T_D, EVENT_BILLING_MISC_T_D,EVENT_BILLING_MISC_T_D,DWB_INVC_ITEM,

DWB_INVC_ADJ

EVENT_BAL_IMPACTS_T_D, EVENT_T_D

DWB_INVC_DISC

BRM_PYMT_ASGN_V

DWB_INVC_PYMT_ASGN

Postpaid:

EVENT_T_D, E_DLYD_SES_TLCO_GSM_T_D, EVENT_DLAY_SESS_TLCS_T_D, EVENT_BAL_IMPACT_COLL_VW, DWR_VAL_ADD_SRVC, DWR_PROD_SBRP, DWR_CUST,DWR_SRVC,DWB_INVC_ITEMPrepaid:

EVENT_BAL_IMPACT_COLL_VW, EVENT_T_D,EVENT_SESSION_TLCS_T_D, EVENT_SESSION_TLCO_GSM_T_D, DWR_PROD_SBRP, DWR_CUST, DWR_VAL_ADD_SRVC

DWB_SMS_EVT

IFW_USAGETYPE_D

DWL_CALL_SRVC_TYP

CFG_COLLECTIONS_SCENARIO_T_D

DWL_COLLCTN_TYP

IFW_CURRENCY_D

DWL_CRNCY_MAP

DD_OBJECTS_T_D

DWL_PROD_SPEC_TYP

PAYINFO_T_D, PAYINFO_CC_T_D, PAYINFO_DD_T_D, PAYINFO_INV_T_D,DWR_ACCT

DWR_ACCT_PYMT_MTHD

CONFIG_BILLING_SEGMENT_T_D

DWR_ACCT_SGMNT

BAL_GRP_T_D, BAL_GRP_SUB_BALS_T_D,DWR_ACCT,DWR_PROD_SBRP

DWR_AGRMNT

DWR_PROD_SBRP, DWR_AGRMNT, PURCHASED_PRODUCT_T_D

DWR_AGRMNT_ITEM

DWR_ACCT, BAL_GRP_T_D, BAL_GRP_SUB_BALS_T_D, DWR_PROD_SBRP,DWR_PROD_SPEC

DWR_BRM_BAL_GRP

DWR_CUST, DWR_ADDR_LOC, ACCOUNT_T_D

DWR_CUST_ADDR

PLAN_T_D

DWR_PROD_CTLG

PLAN_SERVICES_T_D, PLAN_T_D, DWR_PROD_CTLG, DWR_PROD_OFR,

DWR_PROD_CTLG_PROD_OFR_ASGN

DEAL_T_D,

DWR_PROD_OFR

RATE_PLAN_T_D, DWR_PROD_SPEC

DWR_PROD_OFR_PRICE

DEAL_T_D, DEAL_DISCOUNTS_T_D, DWR_SRVC_SPEC, DWR_PROD_OFR, DEAL_PRODUCTS_T_D, DWR_PROD_SPEC,

DWR_PROD_OFR_PROD_SPEC_ASGN

DWR_CUST_FCNG_SRVC, DWR_SRVC, DWR_ACCT,PURCHASED_PRODUCT_T_D,DWR_PROD_OFR, DWR_PROD_SPEC

DWR_PROD_SBRP

DWR_PROD_SBRP, PURCHASED_DISCOUNT_T_D, ACCOUNT_T_D_H, DWR_ACCT, DWR_PROD_SBRP, PURCHASED_PRODUCT_T_D,

DWR_PROD_SBRP_PRICE

DISCOUNT_T_D, PRODUCT_T_D

DWR_PROD_SPEC

ACCOUNT_NAMEINFO_T_D, ACCOUNT_T_D, DWR_PRTY,

DWR_PRTY_CNTCT_INFO

SERVICE_TELCO_FEATURES_T_D

DWR_SRVC_SPEC_CHAR

PRODUCT_T_D, DWR_PROD_SPEC

DWR_VAL_ADD_SRVC


Oracle Data Integrator BRM_OCDM Project

The Oracle Data Integrator BRM_OCDM project is created when you install the BRM Adapter. The BRM_OCDM project contains the following folders:

  • SRC_STG_NONGG

  • STG_OCDM

Objects in SRC_STG_NONGG Folder of the BRM_OCDM Project

The SRC_STG_NONGG folder of the BRM_OCDM project contains packages to populate the staging layer of the Oracle Communications Data Model warehouse (the tables in the BRM_STG schema) with data from the BRM source system.

The four main packages load different types of BRM source data:

Additionally, the packages load the BRM source data based on the data dependencies to maintain the data integrity in the warehouse.

#1_USAGE_EVENTS_PKG

The #1_USAGE_EVENTS_PKG package loads the usage-related data from the BRM source system into the staging layer of the Oracle Communications Data Model warehouse. This package loads any new subscriber information (from the last update) and then loads the subscriber usage data.

This package runs the following interfaces to populate the BRM_STG schema tables with the data from the BRM source system:

  • ACCOUNT_NAMEINFO_T_NONGG_IU

  • ACCOUNT_T_NONGG_IU

  • BAL_GRP_BALS_T_NONGG_IU

  • BAL_GRP_SUB_BALS_T_NONGG_IU

  • BAL_GRP_T_NONGG_IU

  • BILLINFO_T_NONGG_IU

  • BILL_T_NONGG_IU

  • CFG_CREDIT_PROFILE_T_NONGG_IU

  • CONFIG_BEID_BALANCES_T_NONGG_IU

  • CONFIG_BILLING_SEGMENT_T_NONGG_IU

  • CONFIG_BUSINESS_TYPE_T_NONGG_IU

  • CONFIG_COLLECTIONS_SCENARIO_T_NONGG_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_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

  • 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

  • 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

#2_BILLING_INVOICING_PKG

The #2_BILLING_INVOICING_PKG package loads the billing-related data from the BRM source system into the staging layer of the Oracle Communications Data Model warehouse. This package loads any new subscriber information and subscriber usage data (from the last update) and then loads the subscriber billing data.

This package runs the following interfaces to populate the BRM_STG schema tables with the data from the BRM source system:

  • 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

#3_PAYMENTS_PKG

The #3_PAYMENTS_PKG package loads the payment-related data from the BRM source system into the staging layer of the Oracle Communications Data Model warehouse. This package loads any new subscriber information, subscriber usage data, and subscriber billing data (from the last update) and then loads the subscriber payment data.

This package runs the following interfaces to populate the BRM_STG schema tables with the data from the BRM source system:

  • PAYINFO_T_NONGG_IU

  • PAYINFO_INV_T_NONGG_IU

  • PAYINFO_DD_T_NONGG_IU

  • PAYINFO_CC_T_NONGG_IU

#4_COLLECTIONS_PKG

The #4_COLLECTIONS_PKG package loads the collection-related data from the BRM source system into the staging layer of the Oracle Communications Data Model warehouse. This package loads any new subscriber information, subscriber usage data, subscriber billing data, and subscriber payment data (from the last update) and then loads the subscriber collection data.

This package runs the following interfaces to populate the BRM_STG schema tables with the data from the BRM source system:

  • COLLECTIONS_SCENARIO_T_NONOGG_IU

  • COLLECTIONS_ACTION_T_NONOGG_IU

Objects in the STG_OCDM Folder of the BRM_OCDM Project

The STG_OCDM folder of the BRM_OCDM project contains packages to populate the foundation layer of the Oracle Communications Data Model warehouse. The main packages are the BULKLOAD packages for the initial loading of the Oracle Communications Data Model warehouse and the END-TO-END packages for refreshing the data in the warehouse.

  • USAGE_EVENTS_BULKLOAD

  • BILLING_INVOICE_BULKLOAD

  • PAYMENT_DATA_BULKLOAD

  • COLLECTION_DATA_BULKLOAD

  • END_TO_END_LOAD_PLAN_USAGE_EVENTS

  • END_TO_END_LOAD_PLAN_BILLING_INVOICE

  • END_TO_END_LOAD_PLAN_PAYMENT_DATA

  • END_TO_END_LOAD_PLAN_COLLECTION_DATA

These packages populate the staging layer (the tables in the BRM_STG schema) and, also the foundation layer (the tables in the OCDM_SYS schema) with the data from the BRM source system.

The BULKLOAD packages are optimized for loading huge amounts of data during the initial load of the warehouse.

The END-TO-END packages provide the flexibility to refresh the data in the warehouse, as needed. The packages also track the date of the last refresh and automatically loads data from the date of the last refresh.

For example, you can run END_TO_END_LOAD_PLAN_BILLING_INVOICE during off-peak hours to refresh the billing-related data in the warehouse but run the END_TO_END_LOAD_PLAN_USAGE_EVENTS package more frequently to refresh the usage-related data.

USAGE_EVENTS_BULKLOAD and END_TO_END_LOAD_PLAN_USAGE_EVENTS Packages

The USAGE_EVENTS_BULKLOAD and END_TO_END_LOAD_PLAN_USAGE_EVENTS packages load usage-related data from the BRM source system into the Oracle Communications Data Model warehouse.

The packages run the #1_USAGE_EVENTS_PKG package to populate the usage-related tables in the BRM_STG schema with the data from the BRM source system and then runs the STG_OCDM_LOAD package to populate the related tables in the OCDM_SYS schema with the data from the BRM_STG schema delta tables.

BILLING_INVOICE_BULKLOAD and END_TO_END_LOAD_PLAN_BILLING_INVOICE Packages

The BILLING_INVOICE_BULKLOAD and END_TO_END_LOAD_PLAN_BILLING_INVOICE packages load billing-related data from the BRM source system into the Oracle Communications Data Model warehouse.

The packages run the #2_BILLING_INVOICING_PKG package to populate the billing-related tables in the BRM_STG schema with the data from the BRM source system and then runs the STG_OCDM_LOAD package to populate the related tables in the OCDM_SYS schema with the data from the BRM_STG schema delta tables.

PAYMENT_DATA_BULKLOAD and END_TO_END_LOAD_PLAN_PAYMENT_DATA Packages

The PAYMENT_DATA_BULKLOAD and END_TO_END_LOAD_PLAN_PAYMENT_DATA packages load payment-related data from the BRM source system into the Oracle Communications Data Model warehouse.

The packages run the #3_PAYMENTS_PKG package to populate the payment-related tables in the BRM_STG schema with the data from the BRM source system and then runs the STG_OCDM_LOAD package to populate the related tables in the OCDM_SYS schema with the data from the BRM_STG schema delta tables.

COLLECTION_DATA_BULKLOAD and END_TO_END_LOAD_PLAN_COLLECTION_DATA Packages

The COLLECTION_DATA_BULKLOAD and END_TO_END_LOAD_PLAN_COLLECTION_DATA packages load collection-related data from the BRM source system into the Oracle Communications Data Model warehouse.

The packages run the #4_COLLECTIONS_PKG package to populate the collection-related tables in the BRM_STG schema with the data from the BRM source system and then runs the STG_OCDM_LOAD package to populate the related tables in the OCDM_SYS schema with the data from the BRM_STG schema delta tables.

STG_OCDM_LOAD Package

The STG_OCDM_LOAD package loads the Oracle Communications Data Model foundation layer tables with the data from the staging layer delta tables.

This package runs the following interfaces to populate the OCDM_SYS schema tables with the data from the BRM_STG schema delta tables:

  • 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_BRM_BAL_GRP_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

  • OCDM_SYS_LOGS_ERROR_INTERFACE

Schema Definitions Added by the BRM Adapter

Installing and configuring the BRM Adapter adds the following definitions:

  • A database schema named BRM_STG that defines a staging area for use by the BRM adapter. For information on the definitions in this database schema, see "BRM_STG Schema Objects".

  • Procedure definitions that populate the foundation layer of an Oracle Communications Data Model warehouse. These definitions are added to the OCDM_SYS schema delivered with Oracle Communications Data Model. For more information on these procedures, see "OCDM_SYS Objects for the BRM Adapter".

BRM_STG Schema Objects

The BRM_STG schema includes the tables, views, functions, and procedures shown in Table 3-2.

Table 3-2 Objects in the BRM_STG Schema

Object Type Object Name Description

Table

source_table_name

Standard staging tables. source_table_name is the same as the BRM source table name.

Table

source_table_name_D

Delta tables. Each BRM source table has one table definition.

Table

source_table_name_D_H

Delta history tables. Each BRM source table has one table definition.

Table

BRM_MAPPING_TAB

Oracle GoldenGate input parameter table.

Table

BRM_ETL_PARAMETER

BRM ETL parameter loading table.

View

ADDRESS_VW

Stores the address of 'Billing_address','Payment_invc','Payment_dd', and 'Payment_cc'.

View

EVENT_BAL_IMPACT_COLL_VW

Stores the product related cost, tax, and discount amount.

View

EVENT_BILLING_PAYMENTS_T_MAP_VW

Stores information about bill payment related information.

View

SERVICE_T_MAP_VW

 

Function

BRM_GET_DD_OBJ_MAP

 

Function

FN_LOOKUP_MATRIX

Returns the currency type of different country/customer type/peak-off peak time /Account Balance Type depending upon parameter used to call the function.

Function

UTC_TO_ORACLE

 

Procedure

PRE_STAGING_LOAD

For Oracle GoldenGate.

Procedure

POST_STAGING_LOAD

For Oracle GoldenGate.


OCDM_SYS Objects for the BRM Adapter

Installing and configuring the BRM Adapter adds the following procedure definitions to the OCDM_SYS schema:

  • DEL_OCDM

  • DISB_CONS

  • DISB_CONS_BRM

  • ENAB_CONS

  • GEO_MAP

  • INSERT_REF

  • UPDATE_ACCT_ACCT

  • UPDATE_ACCT_BILLINFO

  • UPDATE_ACCT_PYMT_MTHD

  • UPDATE_ADDR_LOC

  • UPDATE_BASE_PROD_KEY

  • UPDATE_CUST

  • UPDATE_CUST_FCNG_SRVC

  • UPDATE_DWB_INVC

  • UPDATE_DWB_INVC_ITEM

  • UPDATE_PROD_OFR

  • UPDATE_PROD_OFR_PRICE

  • UPDATE_PROD_SBRP

  • UPDATE_PROD_SBRP_CHRGS

  • UPDATE_PROD_SPEC

  • UPDATE_PRTY

  • UPDATE_PRTY_FOR_CUST

  • UPDATE_SRVC_SPEC