Mdm/Eip Query List With Parameters Of Form ##P.Lst.Xxx Fail To Validate Since Latest Patch 10251569 (Doc ID 1276886.1)

Last updated on MARCH 03, 2017

Applies to:

Oracle Utilities Meter Data Management - Version: 1.6.1 and later   [Release: 1.6 and later ]
Information in this document applies to any platform.

Symptoms

When trying to validate a list in EIP (web gui) that contains two dots for an input parameter, then the list fails validation with an error.

Example of Query:
SELECT * FROM UOM WHERE UOMCODE = ##P.LST.UOMCODE

Error:
Error - List validation failed...

ExecuteReaderException:
ORA-22806: not an object or REF.

SELECT * FROM UOM WHERE UOMCODE = ##P.LST.UOMCODE


This worked in 1.6.1.0.5 but does not work after upgrading to 1.6.1.1.0.

The following query works as expected (only has 1 dot): SELECT * FROM UOM WHERE UOMCODE = ##P.LST_UOMCODE

Changes

This error occurs after upgrading to v1.6.1.1.0

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