Skip Headers
Oracle® Communications Data Model Reference
Release 11.3.1

Part Number E28440-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

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

14 Oracle Communications Data Model BRM Application Adapter

This chapter describes the Oracle Communications Billing and Revenue Management Adapter for Oracle Communications Data Model (BRM Adapter).

This chapter includes the following sections:

For more information on the BRM Adapter for Oracle Communications Data Model, see Oracle Communications Data Model Implementation and Operations Guide.

BRM Adapter for Oracle Communications Data Model

The BRM Adapter loads data from an Oracle Communications Billing and Revenue Management source system into Oracle Communications Data Model. You can load data in both an initial and an incremental manner. The data from Oracle Communications Billing and Revenue Management populates the Oracle Communications Data Model derived and aggregate tables, reports, and mining models.

BRM Adapter Architecture Overview

BRM Adapter for Oracle Communications Data Model is designed to use the Extract Load and Transform (EL-T) principle. The adapter uses both Oracle GoldenGate and Oracle Data Integrator (ODI). Oracle GoldenGate is used when the user want to provide real-time feed to the staging area, and ODI is used for batch loading (to the staging area) and for transformation in the staging to the Oracle Communications Data Model foundation layer. The BRM Adapter for Oracle Communications Data Model enables the staging layer to be used as an operational data store for near real-time reporting.

Oracle GoldenGate is an option, if you do not require or do not want true real-time feeds, they can you can use the standard bulk load with ODI-only (default). Using ODI Knowledge Module (KM) for Oracle GoldenGate enables a single User Interface (UI) to be used to configure Oracle GoldenGate and ODI on its own.

Oracle Data Integrator is combined with Oracle GoldenGate. This provides a cross-platform data replication and changed data capture for Oracle Communications Billing and Revenue Management with Oracle Communications Data Model.

Figure 14-1 shows the BRM Adapter for Oracle Communications Data Model architecture.

Figure 14-1 BRM Adapter Architecture

Description of Figure 14-1 follows
Description of "Figure 14-1 BRM Adapter Architecture"

BRM Adapter to Oracle Communications Data Model Table Mapping

Table 14-1 lists the mapping overview for BRM Adapter source tables to Oracle Communications Data Model target tables.

Table 14-1 BRM Adapter Source to Target Table Mapping

ID Source Table Target Table

1 & 2

CONFIG_T, CONFIG_BUSINESS_TYPE_T

DWL_CUST_TYP

1 & 3

CONFIG_T,CONFIG_BEID_BALANCES_T

DWL_ACCT_BAL_TYP

1 & 4

CONFIG_T, CONFIG_CUR_CONV_RATES_T

DWB_CRNCY_EXCHNG_RATE

5

IFW_USAGETYPE

Not yet used but needed to distinguish various usage types

6

IFW_TIMEZONE

DWL_PK_OFPK_TIME

7

IFW_CURRENCY

DWL_CRNCY

8

DD_OBJECTS_T

DWR_SRVC_SPEC

9

PRODUCT_T

DWR_PROD, DWR_SRVC_SPEC_PROD_RLTN

10

DISCOUNT_T

DWR_PROD, DWR_SRVC_SPEC_PROD_RLTN

11

RATE_PLAN_T

DWR_PROD_RTNG_PLN

12

DEAL_T

DWR_PROD

13

DEAL_PRODUCTS_T

DWR_PROD_PKG_ASGN

14

PLAN_T

DWR_PROD_MKT_PLN

15

PLAN_SERVICES_T

DWR_PROD_MKT_PLN_ASGN

16

SERVICE_T

DWR_SRVC, DWR_CUST_FCNG_SRVC, DWB_SRVC_STAT_HIST

16 & 17

SERVICE_T, SERVICE_TELCO_GSM_T

DWR_CUST_FCNG_SRVC

16 & 18

SERVICE_T, SERVICE_TELCO_GPRS_T

DWR_CUST_FCNG_SRVC

16 & 19

SERVICE_T, SERVICE_EMAIL_T

DWR_CUST_FCNG_SRVC

20

SERVICE_TELCO_FEATURES_T

DWR_SRVC_CHTRSTC

21 & 22

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

23

BILLINFO_T

DWR_PRTY, DWR_CUST, DWR_ACCT, DWL_PYMT_MTHD_TYP

24

BAL_GRP_T

DWR_ACCT_BAL_GRP

25

PURCHASED_PRODUCT_T

DWR_SBRP, DWR_SBRP_PRICE_CHRG

26

PURCHASED_DISCOUNT_T

DWR_SBRP, DWR_SBRP_PRICE_CHRG

27

BILL_T

DWB_INVC

28

INVOICE_T

DWB_EVT_INVC_DLVRY

29

ITEM_T

DWB_INVC_ITEM

30 & 31

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

30 & 32

PAYINFO_T, PAYINFO_DD_T

DWR_PRTY, DWR_ACCT_PREF_PYMT_MTHD

30 & 33

PAYINFO_T,PAYINFO_CC_T

DWR_PRTY, DWR_ACCT_PREF_PYMT_MTHD

34

EVENT_T

used in all "NETWORK Event" type of mapping

35

EVENT_BAL_IMPACTS_T

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

36

EVENT_SESSION_TLCS_T

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

37

EVENT_SESS_TLCS_SVC_CODES_T

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

38

EVENT_SESSION_TLCO_GSM_T

DWB_WRLS_CALL_EVT (Prepaid)

39

EVENT_SESSION_TELCO_GPRS_T

DWB_GPRS_USG_EVT (Prepaid)

40

EVENT_BROADBAND_USAGE_T

DWB_BRDBND_USG_EVT

41

EVENT_SESSION_DIALUP_T

DWB_DATA_SRVC_EVT

42

EVENT_DLAY_SESS_TLCS_T

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

43

EVENT_DLAY_SESS_TLCS_SVC_CDS_T

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

44

EVENT_DLYD_SESSION_TLCO_GPRS_T

DWB_GPRS_USG_EVT (Postpaid)

45

EVENT_DLYD_SESSION_TLCO_GSM_T

DWB_WRLS_CALL_EVT (Postpaid)

46

EVENT_ACTIVITY_TLCS_T

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

47

EVENT_ACTV_TLCS_SVC_CODES_T

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

48

EVENT_DLAY_ACTV_TLCS_SVC_CDS_T

 

49

EVENT_DLAY_ACTV_TLCS_T

 

50

EVENT_TAX_JURISDICTIONS_T

 

51

EVENT_RUM_MAP_T

 

52

EVENT_BILLING_PAYMENT_T

DWB_ACCT_RCHRG

53

EVENT_BILLING_PAYMENT_DD_T

DWB_ACCT_RCHRG

54

EVENT_BILLING_PAYMENT_CASH_T

DWB_ACCT_RCHRG

55

EVENT_BILLING_PAYMENT_CC_T

DWB_ACCT_RCHRG

56

EVENT_BILLING_PAYMENT_CHECK_T

DWB_ACCT_RCHRG

57

EVENT_BILLING_PAYMENT_FAILED_T

DWB_ACCT_RCHRG

58

EVENT_BILLING_PAYMENT_PAYORD_T

DWB_ACCT_RCHRG

59

EVENT_BILLING_PAYMENT_POST_T

DWB_ACCT_RCHRG

60

EVENT_BILLING_PAYMENT_WTRAN_T

DWB_ACCT_RCHRG

61

NOTE_T

DWB_EVT_PRTY_INTRACN