OUCCB2_OUMDM2_ErrorCode

All

Transforms the Oracle Utilities Meter Data Management Message Category and Message number to the Oracle Utilities Customer Care and Billing Message Category and message number. This helps the implementation layer to map specific message numbers to specific error codes, and thus provide more user-friendly error messages in Oracle Utilities Customer Care and Billing.

 

The Message Category and message number are stored in the same DVM column but separated by “!’ symbol.

OUCCB2_ErrorCode - This is a combination of CCB Message Category and Message Number separated by “!”.

 

OUMDM2_ErrorCode - This is a combination of MDM Message Category and Message Number separated by “!”.

 

Note: If nothing is defined in the Error Code DVM table or no equivalent CCB Error Code lookup value exists in the DVM table for the provided MDM Error Code, the integration passes the CCB Generic Message Category and CCB Generic Business Exception Message Number defined in the Configuration properties file in the response message.

OUCCB2_OUMDM2_MO

All

Transform the CCB Maintenance Object name to MDM Maintenance Object name.

Maps the Oracle Utilities Customer Care and Billing Maintenance Object value to corresponding Oracle Utilities Meter Data Management Maintenance Object value.

 

OUCCB2_MO - This is a valid maintenance object defined in CCB.

 

OUMDM2_MO - This is a valid maintenance object defined in MDM.

OUCCB2_OUMDM2_ContactType

Person Sync

Transform the CCB Contact type to MDM Contact Type.

Maps the Oracle Utilities Customer Care and Billing Contact Type value to corresponding Oracle Utilities Meter Data Management Contact type value.

 

OUCCB2_ContactType - This is a valid Contact Type defined in CCB.

OUMDM2_ContactType - This is a valid Contact Type defined in MDM.

OUCCB2_OUMDM2_Country

SP Sync

Transform the Country code from CCB to MDM format and vice versa.

Maps the Oracle Utilities Customer Care and Billing country code to corresponding Oracle Utilities Meter Data Management Country code.

 

OUCCB2_CountryCode - This is a valid country code defined in CCB.

 

OUMDM2_Country Code - This is a valid country code defined in MDM.

OUCCB2_OUMDM2_DisconnectLocation

SP Sync

Transform Disconnect location code from CCB to MDM format and vice versa.

Maps the Oracle Utilities Customer Care and Billing Disconnect Location to corresponding Oracle Utilities Meter Data Management Disconnect Location.

 

OUCCB2_DisconnectLocation - This is a valid Disconnect Location defined in CCB.

 

OUMDM2_DisconnectLocation - This is a valid Disconnect Location defined in MDM.

OUCCB2_OUMDM2_MeasurementCycle

SP Sync

Transform measurement cycle code from CCB to MDM format and vice versa.

Maps the Oracle Utilities Customer Care and Billing Measurement Cycle to corresponding Oracle Utilities Meter Data Management Measurement Cycle.

 

OUCCB2_MeasurementCycle - This is a valid Measurement Cycle defined in CCB.

 

OUMDM2_MeasurementCycle - This is a valid Measurement Cycle defined in MDM.

OUCCB2_OUMDM2_MeasurementCycleRoute

SP Sync

Transform measurement cycle route code from CCB to MDM format and vice versa.

Maps the Oracle Utilities Customer Care and Billing Measurement Cycle Route to corresponding Oracle Utilities Meter Data Management Measurement Cycle Route.

 

OUCCB2_MeasurementCycleRoute - This is a valid Measurement Cycle Route defined in CCB.

 

OUMDM2_MeasurementCycleRoute - This is a valid Measurement Cycle Route defined in MDM.

OUCCB2_OUMDM2_SPSourceStatus

SP Sync

Transform SP Source status from CCB to MDM format and vice versa.

Maps the Oracle Utilities Customer Care and Billing SP Source Status to corresponding Oracle Utilities Meter Data Management SP Source Status.

 

OUCCB2_SPSourceStatus - This is a valid SP Source Status defined in CCB.

 

OUMDM2_SPSourceStatus - This is a valid SP Source Status defined in MDM.

OUCCB2_OUMDM2_SPStatus

SP Sync

Transform SP status from CCB to MDM format and vice versa.

Maps the Oracle Utilities Customer Care and Billing SP Status to corresponding Oracle Utilities Meter Data Management SP Status.

 

OUCCB2_SPStatus - This is a valid SP Status defined in CCB.

 

OUMDM2_SPStatus - This is a valid SP Status defined in MDM.

OUCCB2_OUMDM2_SPType

SP Sync

Transform SP Type from CCB to MDM format and vice versa.

Maps the Oracle Utilities Customer Care and Billing SP Type to corresponding Oracle Utilities Meter Data Management SP Type.

 

OUCCB2_SPType - This is a valid SP Type defined in CCB.

 

OUMDM2_SPType - This is a valid SP Type defined in MDM.

OUCCB2_OUMDM2_LifeSupportSensitiveLoad

SP Sync

Transform life support sensitive load to enter code from CCB to MDM format and vice versa.

Maps the Oracle Utilities Customer Care and Billing LifeSupportSensitiveLoad flag to corresponding Oracle Utilities Meter Data Management LifeSupportSensitiveLoad flag.

 

OUCCB2_LifeSupportSensitiveLoad - This is a valid LifeSupportSensitiveLoad flag defined in CCB.

 

OUMDM2_LifeSupportSensitiveLoad - This is a valid LifeSupportSensitiveLoad flag defined in MDM.

OUCCB2_OUMDM2_USType

SA Sync

Transform CCB SA type and CIS Division combination to MDM US type and vice versa. In the CCB column, the SA Type and CIS Division are both entered with “!” symbol as the separator.

Maps the Oracle Utilities Customer Care and Billing CIS Division and SA Type to corresponding Oracle Utilities Meter Data Management Usage Subscription type.

 

OUCCB2_CISDivision_SAType - This is a valid CIS Division and SA Type combination defined in CCB separated by “!”.

 

OUMDM2_USType - This is a valid Usage Subscription type defined in MDM.

OUCCB2_OUMDM2_SAStatus

SA Sync

Transform CCB SA status to MDM Usage subscription status and vice versa.

Maps the Oracle Utilities Customer Care and Billing SA Status to corresponding Oracle Utilities Meter Data Management US Status.

 

OUCCB2_SAStatus - This is a valid SA Status defined in CCB.

 

OUMDM2_USStatus - This is a valid US Status defined in MDM.

OUCCB2_OUMDM2_DeviceType

Meter Sync

Transform CCB Meter type to MDM Device type and vice versa.

This DVM is used by the integration layer to map Oracle Utilities Customer Care and Billing Device Type to corresponding Oracle Utilities Meter Data Management Device Type.

 

OUCCB2_DeviceType - This is a valid Device Type defined in CCB.

 

OUMDM2_DeviceType - This is a valid Device Type defined in MDM.

OUCCB2_OUMDM2_MeterStatus

Meter Sync

Transform CCB Meter status to MDM Device status and vice versa.

This DVM is used by the integration layer to map Oracle Utilities Customer Care and Billing Meter Status to corresponding Oracle Utilities Meter Data Management Device Status.

 

OUCCB2_MeterStatus - This is a valid Meter Status defined in CCB.

OUMDM2_DeviceStatus - This is a valid Device status defined in MDM.

OUCCB2_OUMDM2_Manufacturer

Meter Sync

Transform CCB Manufacturer to MDM Manufacturer and vice versa.

This DVM is used by the integration layer to map Oracle Utilities Customer Care and Billing Manufacturer code to corresponding Oracle Utilities Meter Data Management Manufacturer code.

 

OUCCB2_Manufacturer - This is a valid Manufacturer code defined in CCB.

OUMDM2_Manufacturer - This is a valid Manufacturer code defined in MDM.

OUCCB2_OUMDM2_Model

Meter Sync

Transform CCB Model to MDM Model and vice versa.

Maps the CCB Model code to corresponding Oracle Utilities Meter Data Management Model code.

 

OUCCB2_Model - This is a valid Model code defined in CCB.

OUMDM2_Model - This is a valid Model code defined in MDM.

OUCCB2_OUMDM2_DeviceConfigType

Meter Configuration Sync

Transform CCB Meter Config type to MDM Device Config type and vice versa.

Maps the CCB Device Config Type code to corresponding Oracle Utilities Meter Data Management Device Config Type code.

 

OUCCB2_DeviceConfigType - This is a valid Device Config Type code defined in CCB.

OUMDM2_DeviceConfigType - This is a valid Device Config Type code defined in MDM.

OUCCB2_OUMDM2_HowToUse

Meter Configuration Sync

Transform CCB How to use flag to MDM How to use flag and vice versa.

Maps the CCB HowToUse flag to corresponding Oracle Utilities Meter Data Management HowToUse flag.

 

OUCCB2_HowToUse - This is a valid HowToUse flag defined in CCB.

OUMDM2_HowToUse - This is a valid HowToUse flag defined in MDM.

OUCCB2_OUMDM2_ReadOutType

Meter Configuration Sync

Transform CCB Read out type to MDM Read out type and vice versa.

Maps the CCB Read Out Type code to corresponding Oracle Utilities Meter Data Management Read Out Type code.

 

OUCCB2_ReadOutType - This is a valid Read Out Type code defined in CCB.

OUMDM2_ReadOutType - This is a valid Read Out Type code defined in MDM.

OUCCB2_OUMDM2_ConsumptiveSubtractive

Meter Configuration Sync

Transform CCB Consumptive Subtractive flag to MDM Consumptive Subtractive flag and vice versa.

Maps the CCB ConsumptiveSubtractive flag to corresponding Oracle Utilities Meter Data Management ConsumptiveSubtractive flag.

 

OUCCB2_ConsumptiveSubtractive - This is a valid ConsumptiveSubtractive flag defined in CCB.

OUMDM2_ConsumptiveSubtractive - This is a valid ConsumptiveSubtractive flag defined in MDM.

OUCCB2_OUMDM2_MCServiceType

Meter Configuration Sync

Transform CCB Measuring component service type to MDM Measuring component service type and vice versa.

Maps the CCB Measuring Component Service Type code to corresponding Oracle Utilities Meter Data Management Measuring Component Service Type code.

 

OUCCB2_MCServiceType - This is a valid Measuring Component Service Type code defined in CCB.

OUMDM2_MCServiceType - This is a valid Measuring Component Service Type code defined in MDM.

OUCCB2_OUMDM2_NegativeConsumption

Meter Configuration Sync

Transform CCB negative consumption flag to MDM negative consumption flag and vice versa.

Maps the CCB NegativeConsumption flag to corresponding Oracle Utilities Meter Data Management NegativeConsumption flag.

 

OUCCB2_NegativeConsumption - This is a valid NegativeConsumption flag defined in CCB.

OUMDM2_NegativeConsumption - This is a valid NegativeConsumption flag defined in MDM.

OUCCB2_OUMDM2_BillCondition

Batch BD, Online BD and Get Usage Request

Transform CCB Bill Condition to MDM Bill Condition and vice versa.

Maps the CCB BillCondition flag to corresponding Oracle Utilities Meter Data Management BillCondition flag.

 

OUCCB2_BillCondition - This is a valid BillCondition flag defined in CCB.

OUMDM2_BillCondition - This is a valid BillCondition flag defined in MDM.

OUCCB2_OUMDM2_AllowEstimate

Batch BD, Online BD and Get Usage Request

Transform CCB Allow Estimate to MDM Allow Estimate and vice versa.

Maps the CCB AllowEstimate flag to corresponding Oracle Utilities Meter Data Management AllowEstimate flag.

 

OUCCB2_AllowEstimate - This is a valid AllowEstimate flag defined in CCB.

OUMDM2_AllowEstimate - This is a valid AllowEstimate flag defined in MDM.

OUCCB2_OUMDM2_BillingOption

Batch BD and Online BD

Transform CCB Billing Option to MDM Billing Option and vice versa.

Maps the CCB BillingOption flag to corresponding Oracle Utilities Meter Data Management BillingOption flag.

 

OUCCB2_BillingOption - This is a valid BillingOption flag defined in CCB.

OUMDM2_BillingOption - This is a valid BillingOption flag defined in MDM.

OUCCB2_OUMDM2_BillMode

Batch BD and Online BD

Transform CCB Bill Mode to MDM Bill Mode and vice versa.

Maps the CCB BillMode flag to corresponding Oracle Utilities Meter Data Management BillMode flag.

 

OUCCB2_BillMode - This is a valid BillMode flag defined in CCB.

OUMDM2_BillMode - This is a valid BillMode flag defined in MDM.

OUCCB2_OUMDM2_AutomatedRetry

Batch BD

Transform CCB Automated Retry to MDM Automated Retry and vice versa.

Maps the CCB AutomatedRetry flag to corresponding Oracle Utilities Meter Data Management AutomatedRetry flag.

 

OUCCB2_AutomatedRetry - This is a valid AutomatedRetry flag defined in CCB.

OUMDM2_AutomatedRetry - This is a valid AutomatedRetry flag defined in MDM.

OUCCB2_OUMDM2_UsageRequestMode

Get Usage Request

Transform CCB Usage Calculation Call Type flag to MDM Usage Request Mode flag.

Maps the CCB Usage Calculation Call Type flag (usageCalculationCalType) to the corresponding Oracle Utilities Meter Data Management Usage Request Mode flag (usageRequestMode).

 

OUCCB2_UsageReqMode - This is a valid Usage Calculation Call Type defined in CCB.

OUMDM2_UsageReqMode - This is a valid Usage Request Mode defined in MDM.

OUMDM2_OUCCB2_IsEstimate

Batch BD, Online BD and Get Usage Request

Transform MDM Is Estimate flag to CCB Is Estimate flag and vice versa.

Maps the MDM Is Estimate flag to corresponding Oracle Utilities Customer Care and Billing Is Estimate flag.

OUMDM2_ IsEstimate - This is a valid Is Estimate flag defined in MDM.

 

OUCCB2_ IsEstimate - This is a valid Is Estimate flag defined in CCB.

OUMDM2_OUCCB2_UOM

Meter Configuration Sync, Batch BD, Online BD and Get Usage Request

Transform CCB UOM to MDM UOM and vice versa.

Maps the MDM UOM to corresponding Oracle Utilities Customer Care and Billing UOM.

OUMDM2_UOM - This is a valid UOM defined in MDM.

 

OUCCB2_UOM - This is a valid UOM defined in CCB.

OUMDM2_OUCCB2_TOU

Meter Configuration Sync, Batch BD, Online BD and Get Usage

Transform CCB TOU to MDM TOU and vice versa.

Maps the MDM TOU to corresponding Oracle Utilities Customer Care and Billing TOU.

 

OUMDM2_TOU - This is a valid TOU defined in MDM.

OUCCB2_TOU - This is a valid TOU defined in CCB.

OUMDM2_OUCCB2_SQI

Meter Configuration Sync, Batch BD, Online BD and Get Usage

Transform CCB SQI to MDM SQI and vice versa.

Maps the MDM SQI to corresponding Oracle Utilities Customer Care and Billing SQI.

OUMDM2_SQI - This is a valid SQI defined in MDM.

 

OUCCB2_SQI - This is a valid SQI defined in CCB.

OUMDM2_OUCCB2_UsageType

Batch BD, Online BD and Get Usage Request

Transform the MDM usage type to CCB usage type. Example: Interval, Scalar, etc.

Maps the MDM usage type to corresponding Oracle Utilities Customer Care and Billing usage type.

OUMDM2_UsageType - This is a valid Usage type defined in MDM.

 

OUCCB2_UsageType - This is a valid Usage type defined in CCB.

OUMDM2_OUCCB2_SPHowToUse

Batch BD, Online BD and Get Usage Request

Transform MDM SP How to Use flag to CCB SP How to Use Flag and vice versa

Maps the MDM SP How To USe to corresponding Oracle Utilities Customer Care and Billing SP How To Use.

OUMDM2_SPHowToUse - This is a valid TOU defined in MDM.

 

OUCCB2_ SPHowToUse - This is a valid TOU defined in CCB.

OUMDM2_OUCCB2_MeasuresPeakQuantity

Batch BD, Online BD and Get Usage Request

Transform MDM Measures Peak Quantity flag to CCB Measures Peak Quantity flag and vice versa

Maps the MDM Measures Peak Quantity to corresponding Oracle Utilities Customer Care and Billing Measures Peak Quantity.

OUMDM2_MeasuresPeakQuantity - This is a valid SQI defined in MDM.

 

OUCCB2_ MeasuresPeakQuantity - This is a valid SQI defined in CCB.

OUMDM2_OUCCB2_SkipSA

Batch BD

Transform MDM Skip flag to CCB Skip SA flag

Maps the MDM Skip element to the corresponding Oracle Utilities Customer Care and Billing Skip SA element.

OUMDM2_Skip - This is a valid Skip flag defined in MDM.

 

OUCCB2_ Skip - This is a valid Skip SA value defined in CCB.

The values are true or false.

OUMDM2_OUCCB2_Skipreason

Batch BD

Transform MDM Skip Reason flag to CCB Skip Reason flag.

Maps the MDM Skip Reason element to the corresponding Oracle Utilities Customer Care and Billing Skip Reason element.

OUMDM2_SkipReason - This is a valid Skip Reason defined in MDM.

 

OUCCB2_ SkipReason - This is a valid Skip Reason defined in CCB.

OUCCB2_ OUMDM2_ReadType

Scalar Meter Read

Transform CCB Read Type flag to MDM Measurement Condition.

Maps the CCB ReadType flag to corresponding Oracle Utilities Meter Data Management MeasurementCondition flag.

 

OUCCB2_ReadType - This is a valid Read Type defined in CCB.

OUMDM2_ ReadType - This is a valid Measurement Condition defined in MDM.

OUMDM2_OUCCB2_HighlightType

Batch BD and Online BD

Transform MDM Highlight Type to CCB Highlight Type

Maps the MDM Highlight Type element to the corresponding Oracle Utilities Customer Care and Billing Highlight Type element.

OUMDM2_HighlightType - This is a valid Highlight Type defined in MDM.

 

OUCCB2_HighlightType - This is a valid Highlight Type defined in CCB.

OUMDM2_OUCCB2_EstimationIndicator

Batch BD and Online BD

Transform MDM Estimation Indicator to CCB Estimation Indicator

Maps the MDM Estimation Indicator element to the corresponding Oracle Utilities Customer Care and Billing Estimation Indicator element.

OUMDM2_EstimationIndicator - This is a valid Estimation Indicator defined in MDM.

 

OUCCB2_EstimationIndicator - This is a valid Estimation Indicator defined in CCB.

OUMDM2_OUCCB2_ItemType

Batch BD and Online BD

Transform MDM Item type to CCB Item type

Maps the MDM Item type element to the corresponding Oracle Utilities Customer Care and Billing Item type element.

 

OUMDM2_ItemType - This is a valid Item Type defined in MDM.

 

OUCCB2_ItemType - This is a valid Item Type defined in CCB.