Runtime Interface (WIFP_METER_READING_INTERFACE) Adding To Mileage

(Doc ID 1471993.1)

Last updated on OCTOBER 16, 2016

Applies to:

Oracle Utilities Work and Asset Management - Version 1.9.0 and later
Information in this document applies to any platform.

Symptoms


When the Runtime Entry Log has multiple asset ids with a meter_reading_current_date that has the SAME date AND timestamp, the Meter Reading Interface (WIFP_METER_READING_INTERFACE) increments the meter_reading value by 1,000,000

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create multiple entries for different asset ids in sa_runtime_log that have the same date / timestamp
2. Enter a record in WAIF_METER_READING for one of those assets.
3. Run WIFP_METER_READING_INTERFACE
4. Check the SA_RUNTIME_LOG- the value entered was incremented by 1,000,000


Cause

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