Unpredictable Results Doing lookupValue When the DVM Contains a Hash Sign (#)

(Doc ID 1288018.1)

Last updated on APRIL 01, 2015

Applies to:

Oracle SOA Suite - Version 11.1.1.1.0 to 11.1.1.7.0 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

You have created a Domain Value Map (DVM), and some rows in your DVM have a hash sign (#).  For example, your DVM might look like the following:


domain1           domain2
A                 1
B#                2
#B                3
##                hash
#A#               4
test#test         hash
C                 #value#
D                 #value
E                 value#



You observe that when you perform a lookupValue on that DVM, the output is unpredictable - sometimes you get back the default value and sometimes you get back some value that seems random.  For example:


input           received           expected
A               1                  1
B#              default            2
#B              B                  3
##              default            hash
#A#             A                  4
test#test       test               hash
C               default            #value#
D               default            #value
E               value              value#


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