Integration Guide for Oracle Billing Insight > Integrating Oracle Billing Insight With Oracle Utilities Customer Care And Billing >

Reference for Mapping of Oracle Utilities CC&B and Oracle Billing Insight Data Objects


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

Mapping of Oracle Utilities CC&B Data Objects With Oracle Billing Insight

The process of integrating Oracle Utilities CC&B data requires provisioning of billing objects, such as company, account, and service or meter into Oracle Billing Insight. You can provision this data in either real-time using RESTful WebService APIs or in batch.

Table 12 shows how the required Oracle Billing Insight provisioning objects map to Oracle Utilities CC&B tables, and which Oracle Billing Insight production tables store these provisioning objects, and the RESTful Web Service APIs used to provision the data.

Table 12. Mapping of Oracle Utilities CC&B Data Data With Oracle Billing Insight Provisioning Objects
Oracle Billing Insight Object
Oracle Utilities CC&B Table
Oracle Billing Insight RESTful API
Oracle Billing Insight Production Table Name
Notes
Company
CI_PER
CI_PER_NAME
CI_PER_PER
/accounts
/companies
EDX_OMF_COMPANY
The top level PER_ID of the person hierarchy maps to the company ID.
The ENTITY_NAME column maps to the company name.
Account
CI_ACCT
/accounts
EDX_OMF_ACCOUNT
None
Service Agreement
CI_SA
CI_MTR
/serviceAgreement
EDX_OMF_SERVICEAGREEMENT
The BADGE_NBR or SA_ID maps to the service agreement number.
Billing Contact
CI_PREM
/accounts
EDX_OMF_CONTACT_INFO
None

Mapping of Oracle Utilities CC&B Extraction Database Tables With Oracle Billing Insight

Table 13 shows how the Oracle Utilities CC&B database tables used for extraction map to Oracle Billing Insight pre-staging tables used by CC&B Provider, and the CC&B Provider procedures used for each extraction.

Table 13. Mapping of Oracle Utilities CC&B Database Tables With Pre-Staging Tables
Number
Oracle Utilities CC&B Table
Oracle Billing Insight Pre-Staging Table for CC&B Provider
CC&B Provider Procedure
1
CI_TENDER_TYPE_L
CCB_TENDER_TYPE_L
pkg_intg_load_prestg_master.pr_load_tender_type
2
CI_ADJ_TYPE_L
CCB_ADJ_TYPE_L
pkg_intg_load_prestg_master.pr_load_adj_type
3
CI_SA_TYPE
CCB_SA_TYPE
pkg_intg_load_prestg_master.pr_load_sa_type
4
CI_SA_TYPE_L
CCB_SA_TYPE
pkg_intg_load_prestg_master.pr_load_sa_type
5
CI_UOM_L
CCB_UOM_L
pkg_intg_load_prestg_master.pr_load_uom
6
CI_TOU_L
CCB_TOU_L
pkg_intg_load_prestg_master.pr_load_tou
7
CI_COUNTRY_L
CCB_COUNTRY_L
pkg_intg_load_prestg_master.pr_load_country
8
CI_CURRENCY_CD
CCB_CURRENCY_CD
pkg_intg_load_prestg_master.pr_load_currency
9
CI_CURRENCY_CD_L
CCB_CURRENCY_CD
pkg_intg_load_prestg_master.pr_load_currency
10
CI_BILL_MSG_L
CCB_BILL_MSG_L
pkg_intg_load_prestg_master.pr_load_bill_msg
11
CI_RC
CCB_RC
pkg_intg_load_prestg_master.pr_load_rc
12
CI_RC_L
CCB_RC
pkg_intg_load_prestg_master.pr_load_rc
13
C1_CALC_RULE
CCB_CALC_RULE
pkg_intg_load_prestg_master.pr_load_calc_rule
14
CI_ACCT
CCB_ACCT
pkg_intg_load_prestg_billing.pr_load_acct
15
CI_ACCT_PER
CCB_ACCT
pkg_intg_load_prestg_billing.pr_load_acct
16
CI_SA
CCB_SA
pkg_intg_load_prestg_billing.pr_load_sa
17
CI_PER_NAME
CCB_PER
pkg_intg_load_prestg_billing.pr_load_per
18
CI_PER
CCB_PER
pkg_intg_load_prestg_billing.pr_load_per
19
CI_PER_PER
CCB_PER_PER
pkg_intg_load_prestg_billing.pr_load_per_per
20
CI_PREM
CCB_PREM
pkg_intg_load_prestg_master.pr_load_prem
21
CI_MTR_CONFIG
CCB_REG_READ
pkg_intg_load_prestg_billing.pr_load_reg_read
22
CI_MTR
CCB_REG_READ
pkg_intg_load_prestg_billing.pr_load_reg_read
23
CI_BILL
CCB_BILL
pkg_intg_load_prestg_billing.pr_load_bill
24
CI_BILL_CYC_SCH
CCB_BILL
pkg_intg_load_prestg_billing.pr_load_bill
25
CI_BILL_MSGS
CCB_BILL_MSGS
pkg_intg_load_prestg_billing.pr_load_bill_msgs
26
CI_BILL_SA
CCB_BILL_SA
pkg_intg_load_prestg_billing.pr_load_bill_sa
27
CI_FT
CCB_FT
pkg_intg_load_prestg_billing.pr_load_ft
28
CI_PAY
CCB_PAY
pkg_intg_load_prestg_billing.pr_load_pay
29
CI_PAY_EVENT
CCB_PAY
pkg_intg_load_prestg_billing.pr_load_pay
30
CI_PAY_TNDR
CCB_PAY
pkg_intg_load_prestg_billing.pr_load_pay
31
CI_ADJ
CCB_ADJ
pkg_intg_load_prestg_billing.pr_load_adj
32
CI_BILL_ROUTING
CCB_BILL_ROUTING
pkg_intg_load_prestg_billing.pr_load_bill_routing
33
CI_BILL_RT_TYPE
CCB_BILL_ROUTING
pkg_intg_load_prestg_billing.pr_load_bill_routing
34
CI_BSEG
CCB_BSEG
pkg_intg_load_prestg_billing.pr_load_bseg
35
CI_BSEG_CALC
CCB_BSEG_CALC
pkg_intg_load_prestg_billing.pr_load_bseg_calc
36
CI_BSEG_CALC_LN
CCB_BSEG_CALC_LN
pkg_intg_load_prestg_billing.pr_load_bseg_calc_ln
37
CI_BSEG_READ
CCB_BSEG_READ
pkg_intg_load_prestg_billing.pr_load_bseg_calc_read
38
CI_REG_READ
CCB_REG_READ
pkg_intg_load_prestg_billing.pr_load_reg_read
39
CI_MR
CCB_REG_READ
pkg_intg_load_prestg_billing.pr_load_reg_read
40
CI_BSEG_SQ
CCB_BSEG_SQ
pkg_intg_load_prestg_billing.pr_load_bseg_sq

Mapping of Pre-Staged Oracle Utilities CC&B Master Data With Oracle Billing Insight

Table 14 shows how master data from the Oracle Billing Insight pre-staging tables map to production tables and to file record types.

Table 14. Mapping of Pre-Staged Master Data With Oracle Billing Insight
CC&BProvider
Pre-Staging Table
Transformation Procedure
Oracle Billing Insight Production Table
Oracle Billing Insight File Input Record Type
CI_TENDER_TYPE_L
pkg_intg_load_stage_master.pr_load_100_pmt_type
EDX_RPT_PAYMENT_TYPE_DIM
100 - Payment type
CI_ADJ_TYPE_L
pkg_intg_load_stage_master.pr_load_110_adjust_type
EDX_RPT_ADJUSTMENT_TYPE_DIM
110 - Adjustment type
CI_SA_TYPE_L
pkg_intg_load_stage_master.pr_load_120_charge_type
EDX_RPT_CHARGE_TYPE_DIM
120 - Charge type
CI_UOM_L
pkg_intg_load_stage_master.pr_load_160_usage_type
EDX_RPT_USAGE_TYPE_DIM
160 - Usage type
CI_TOU_L
pkg_intg_load_stage_master.pr_load_170_tariff_code
EDX_RPT_TARIFF_DIM
170 - Tariff
CI_SA_TYPE_L
pkg_intg_load_stage_master.pr_load_210_service_type
EDX_RPT_SERVICE_TYPE_DIM
210 - Service type
CI_UOM_L
pkg_intg_load_stage_master.pr_load_220_unit_type
EDX_RPT_UNIT_DIM
220 - Unit
CI_COUNTRY_L
pkg_intg_load_stage_master.pr_load_260_country
EDX_RPT_COUNTRY_DIM
260 - Country
CI_CURRENCY_CD
CI_CURRENCY_CD_L
pkg_intg_load_stage_master.pr_load_270_currency
EDX_RPT_CURRENCY_DIM
270 - Currency

Mapping of Pre-Staged Billing Transaction Data from CC&B Provider With Oracle Billing Insight

Table 15 shows how billing transaction data from the CC&B Provider pre-staging tables map to Oracle Billing Insight production tables and file record types. Only critical pre-staging tables are listed for each record type.

Table 15. Mapping of Pre-Staged Billing Transaction Data from CC&B Provider Pre-Staging Tables With Oracle Billing Insight
CC&BProvider
Pre-Staging Table
Transformation Procedure
Oracle Billing Insight Table
Oracle Billing Insight File Input Record Type
CCB_BILL
CCB_BILL_SA
CCB_FT
CCB_BILL_MSGS
pkg_intg_load_stage_billing.pr_load_1000_stmt
EDX_RPT_STATEMENT_FACT
1000 - Statement
CCB_BILL
CCB_FT
CCB_PAY
pkg_intg_load_stage_billing.pr_load_1100_stmtpmt
EDX_RPT_STATEMENT_PAYMENT_FACT
1100 - Statement Payment
CCB_BILL
CCB_FT
CCB_ADJ
CCB_ADJ_TYPE_L
pkg_intg_load_stage_billing.pr_load_1200_stmtadj
EDX_RPT_STATEMENT_ADJUSTMENT
_FACT
1200 - Statement Adjustment
CCB_BILL
CCB_BILL_ROUTING
pkg_intg_load_stage_billing.pr_load_1300_address
EDX_RPT_ADDRESS_DIM
1300 - Mail-to Address
CCB_BILL
CCB_BILL_ROUTING
CCB_FT
pkg_intg_load_stage_billing.pr_load_2000_account_a
pkg_intg_load_stage_billing.pr_load_2000_account_s
EDX_RPT_ACCOUNT_FACT
2000 - Account charges
CCB_BILL
CCB_BSEG
CCB_BSEG_CALC
CCB_SA
CCB_SA_TYPE
pkg_intg_load_stage_billing.pr_load_2100
_acctcharge
EDX_RPT_ACCOUNT_CHARGE_FACT
2100 - Account charges at charge type level
CCB_BILL
CCB_BSEG
CCB_FT
CCB_SA
CCB_SA_TYPE
pkg_intg_load_stage_billing.pr_load_3000_service
EDX_RPT_SERVICE_FACT
3000 - Service charges
CCB_BILL
CCB_BSEG
CCB_BSEG_CALC_LN
CCB_BSEG_SQ
CCB_SA
pkg_intg_load_stage_billing.pr_load_3300_servusage
EDX_RPT_SERVICE_USAGE_FACT
3300 - Service charge at usage level
CCB_BILL
CCB_BSEG
CCB_BSEG_CALC_LN
CCB_SA
pkg_intg_load_stage_billing.pr_load_3400_servtariff
EDX_RPT_SERVICE_TARIFF_FACT
3400 - Service charge at tariff level
CCB_BILL
CCB_BSEG
CCB_BSEG_CALC
CCB_BSEG_CALC_LN
CCB_SA
pkg_intg_load_stage_billing.pr_load_3500_servmisc
EDX_RPT_SERVICE_MISC_FACT
3500 - Service misc charge
CCB_BILL
CCB_BSEG
CCB_PREM
pkg_intg_load_stage_billing.pr_load_5000_prem
EDX_RPT_PREMISE_DIM
5000 - Premise
CCB_BILL
CCB_BSEG
CCB_BSEG_READ
CCB_REG_READ
pkg_intg_load_stage_billing.pr_load_5100_consum
EDX_RPT_CONSUM_FACT
5100 - Consumption

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