DataConnect Consumption Extracts Include Measurement Value "0" For Times At Which Reads Do Not Exist
Last updated on JULY 06, 2018
Applies to:Oracle Utilities Meter Data Management - Version 184.108.40.206 and later
Information in this document applies to any platform.
When running interval data extract by period, if consumption is available only for partial period, then consumption for missing intervals is exported with quantity zero, without any indicator that the consumption was missing.
The issue can be reproduced at will with the following steps:
1. Create a Service Point Type.
2. Create a Device, Device Configuration and Interval Measuring Component.
3.Create Service Point of above created Service Point Type and install the Device.
4.Create a batch control for “Interval Data by Period” by duplicating an existing batch.
5.Create a Consumption Extract Type :-
Extraction Through Date/Time: 01-01-2020
Extraction Cutoff Time: 12 AM
Target UOM: Same as UOM for Interval MC
Target Interval Size: Same as Interval MC’s SPI
Initial Load/Ongoing Extract Algorithm: D2-IDEXTPRD
Historical Corrections Extract Algorithm: D2-IDEXTIMD
Initial Load/Ongoing Batch Control: Batch for Extract by Period
Historical Corrections Batch Control: Batch for Extract by IMD
Service Point Types: Newly created Service Point Type
6.Create measurements from
01.01.2017 12 AM to 01.01.2017 2 AM on the Interval Measuring Component.
7.Create measurements from 01.01.2017 6 Am to 01.01.2017 10 AM on the Interval Measuring Component.
8. Run batch for Interval Data extract by Period with startDateTime = 01.01.2017 12 AM and endDateTime = 01.02.2017 12 AM.
9.Data for intervals for whole day is exported with quantity = 0 for missing intervals.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms