My Oracle Support Banner

Error When Running Rate, "A column with name 'SERIALNUMBER' already exists in resultset. Missing prefix in one of metadata references for the 'LSMDMTRREADSYSHIST' table may lead to this error." (Doc ID 888439.1)

Last updated on FEBRUARY 03, 2019

Applies to:

LODESTAR EIP - Version: 1.5.0
Oracle Utilities Meter Data Management - Version: 1.5.0
This problem can occur on any platform.

Symptoms

In Oracle Utilities Meter Data Application (OUMDA), when running a rate schedule (or bill) an error occurs. The following error can be seen in the report output:

A column with name 'SERIALNUMBER' already exists in resultset. Missing prefix in one of metadata references for the 'LSMDMTRREADSYSHIST' table may lead to this error.

The error can also be seen when stepping through the rate schedule in Trial Calculation.

Changes

This error began occurring after upgrading to OUMDA version 1.5.

Cause

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
  Symptoms
  Changes
  Cause
  Solution
  References

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