My Oracle Support Banner

Adding Usage in MDM with a Starttime Different to Midnight Creates Incorrect Data (Doc ID 744738.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Utilities Meter Data Management - Version 4.5 and later
Information in this document applies to any platform.
***Checked for relevance on 29-Nov-2011***


When adding usage in MDM - Usage Add/Edit - Add Interval and the starttime is not midnight, the application creates extra cuts.

For example, if you create a one day cut with a starttime of 01/01/2008 06:00:00 and a stoptime of 01/02/2008 05:59:59 and a value of 1000, two cuts are created in the database:

One with a startime of 01/01/2008 00:00:00 and value of 1000;

The other with a starttime of 01/02/2008 00:00:00 and a value of 1000.

Only one cut should be created.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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