DataConnect Consumption Extracts Include Measurement Value "0" For Times At Which Reads Do Not Exist (Doc ID 2420063.1)

Last updated on SEPTEMBER 26, 2022

Applies to:

Symptoms

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.


Steps:
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.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.