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 OCTOBER 14, 2014

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

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