Converting Interval Profile Data Sets

Interval profile data sets from Oracle Utilities Customer Care and Billing can be converted into measuring components and measurement data for use in Customer to Meter (and Customer Cloud Service).

Note: Refer to Maintaining Interval Data and Maintaining Interval Profile Data in the Oracle Utilities Customer Care and Billing Administrative User Guide for more information about interval profile data in Oracle Utilities Customer Care and Billing.

Interval Profiles should have been migrated to Interval Measuring Components as part of the Initial Master Data Conversion process (see Initial Master Data Conversion). Once the profiles have been converted, profile data can be converted to measurement data.

A batch control (see below) is used to convert interval profile data to the Customer to Meter (Customer Cloud Service) Measurement table. Processing can be defined for a specified year and month range, and optionally for a range of Register IDs.

Processing Notes:

  • Only Profile Data Sets with a status of "Complete" will be converted.  Data sets that have 'No Data' will be excluded from the conversion.

  • No validation is performed on the interval profile data. All the interval profile data is assumed to be valid. 

  • If the Data Set Type is not defined for the profile data set, the converted measurements will have a Condition of "Regular".

  • Profile data sets with a Data Set Type of "Estimated" will result in measurements with a Condition of "Estimated".

  • If overlapping profile data sets are processed, the values from the data set with the latest Set Data Time are selected for the conversion.

  • The conversion process will not fill-in data for periods without interval data.

Creation of records in the Measurement table is be performed via an Insert Select of the Interval Profile Data, for a month's worth of data at a time, which will be immediately committed. 

Conversion should only be run for a given range of Profile IDs for a given date range once. Attempting to convert the Profile IDs for the same date range multiple times can result in errors.

Data Conversion Batch Control

The Migrate Interval Profile Data Set (X1-MIGID) batch control performs processing for interval profile data set conversion.

The profiles to be converted for each batch run can be defined using the Interval Profile ID Low and Interval Profile ID High parameters. To process data for a single interval profile, you can set both of these parameters to the same Interval Profile  ID. If neither parameter is defined, the process will convert data for all interval profiles.

The batch process can convert up to 1 year of data at a time, the specific year is designated by the Year parameter. The Start Month and End Month parameters can be used to further limit the time range for the conversion.

This batch control uses the following parameters:

  • Interval Profile ID Low: Optional. Used to specify an ID value to override the low ID in the thread ID range calculation. This, along with the Interval Profile ID High be used to limit the number of records processed by each batch run. If not specified, the process will convert data for all interval profiles whose ID is lower than the Interval Profile ID High parameter (if defined). 

  • Interval Profile ID High: Optional. Used to specify an ID value to override the high ID in the thread ID range calculation. This, along with the Interval Profile  ID Low, can be used to limit the number of records processed by each batch run. If not specified, the process will convert data for all interval profiles whose ID is higher than the Interval Profile ID Low parameter (if defined)

  • Year: The year for which data will be converted. (Required)

  • Start Month: The start month of the time range for which data will be converted. (Required)

  • End Month: The start month of the time range for which data will be converted. (Required)

  • Clear Measurements:  Flag indicating whether or not to delete existing measurements within the date range

Examples:

To convert data for all interval profiles from the year 2020, you would set the parameters as follows:

  • Year: 2020

  • Start Month: 01

  • End Month: 12

To convert data for all interval profiles for the months of January through May of 2020, you would set the parameters as follows:

  • Year: 2020

  • Start Month: 01

  • End Month: 05

To convert data for interval profiles whose IDs range from 10001000 to 10009000 for from the year 2020, you would set the parameters as follows:

  • Interval Profile ID Low: 10001000

  • Interval Profile  ID High: 10009000

  • Year: 2020

  • Start Month: 01

  • End Month: 12

To convert data for interval profiles whose IDs range from 100100 to 100900 for the months of January through May of 2020, you would set the parameters as follows:

  • Interval Profile  ID Low: 10001000

  • Interval Profile ID High: 10009000

  • Year: 2020

  • Start Month: 01

  • End Month: 05