“There were more rows than could be returned” error occurs when executing LookupValue in an UI data map (Doc ID 1925807.1)

Environment:
------------
Siebel CRM 8.1.1.11 [23030]
Microsoft Windows (32-bit) 2003

Statement of Issue:
-------------------

An external application sends a record to Siebel. An UI data map is used to convert the record. This includes the expression LookupValue("MSC_WARD",[MSC Ward]) to convert an incoming WARD code into the required value in Siebel. In Siebel there are 11400 List Of Value records where Type = MSC Ward, but there is only 1 record with the relevant Type and LIC combination. When the external application sends a record to Siebel, an error is occurring.

Error:
------
Error invoking service 'EAI Data Transformation Engine', method 'Execute' at step 'DataMap'.(SBL-BPR-00162)
--
An error occurred while attempting to look up the LOV value of '0512005' of type 'MSC_WARD'.(SBL-DAT-00590)
--
There were more rows than could be returned. Please refine your query to bring back fewer rows(SBL-DAT-00500)

Error Code:
(SBL-BPR-00162)--(SBL-DAT-00590)--(SBL-DAT-00500)

Cause

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