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

Assumptions About Oracle Utilities CC&B Data

Certain data and data relationships in Oracle Utilities CC&B are required for integrating Oracle Utilities CC&B with Oracle Billing Insight.

Integration of Oracle Billing Insight with Oracle Utilities CC&B is based on the following data assumptions:

• Balance forward billing is used.
• The top level Person ID of a Person Hierarchy is extracted as the company identity ID.
• A service agreement type (CI_SA_TYPE) with one-off type of charge will map to charge type (the 120 record) in Oracle Billing Insight. A service agreement type with regular recurring type charge will map to service type (210 record) in Oracle Billing Insight.
• Same service agreement type codes (CI_SA_TYPE_L.SA_TYPE_CD) must have the same descriptions (CI_SA_TYPE_L.DFLT_DESCR_ON_BILL and CI_SA_TYPE_L.DESCR).
• A meter could be exchanged for some reason, in which case there will be multiple meters associated with same service at specific time period. This is not supported well. For the new meter you must provision a new service into Oracle Billing Insight and cancel the old meter by provisioning. Also, for the period during which a meter is exchanged, billing data will use the new meter as the service number.
• The meter ID field, BADGE_NBR, is used as the service number in Oracle Billing Insight. For the service agreement (SA) without an associated meter, service agreement ID (SA_ID) will be used as the service number in Oracle Billing Insight. A meter can have multiple unique service types in Oracle Billing Insight. For example, the same meter could be used for both water and waste water charges. For the sub SA's that have the same service type code and are implicitly associated with the same meter by their master SA, these sub SA's will be mapped to one SA in Oracle Billing Insight. There is no master-sub SA concept in Oracle Billing Insight.

For additional information about how Oracle Utilities CC&B data maps with Oracle Billing Insight, see Reference for Mapping of Oracle Utilities CC&B and Oracle Billing Insight Data Objects.