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

About the Service Type Mapping Table

The service type mapping table, EDX_INTG_SVS_MAP, maps Oracle Utilities CC&B service types to the Oracle Billing Insight one-off charge service types and recurring charge service types. Only service agreements with recurring charge service types (such as Water, Gas, Electric, and so on) will be mapped to a service agreement in Oracle Billing Insight. You populate this table when configuring the pre-staging schema.

Table 11 shows an example of a configured service type mapping table, EDX_INTG_SVS_MAP.

The SVC_TYPE_CD column data comes from the CI_SVC_TYPE table. The SVR_TYPE column is used to flag the service type, either R (Recurring charge) or O (One-off charge).

If the service type changes in Oracle Utilities CC&B, you must update the service type mapping table and load master data again.