My Oracle Support Banner

DVM lookup not returning a value when a Domain Qualifier is Null, SOA (Doc ID 2000194.1)

Last updated on APRIL 23, 2019

Applies to:

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


You have a DVM that includes some additional qualifiers. During a lookup operation (dvm:lookupValue) no value is returned if some of the qualifiers are null in the lookup request.


You have a Domain Value Map that relates City Codes and City Names like in the table below. The DVM contains a couple of additional qualifiers Q1 and Q2 used to resolve ambiguous mapping. Remember that qualifier domains contain information solely to clarify the mapping.  


CityCodeCityNameQ1 (Country)Q2 (State)
BO Boston USA Massachusetts
BELG Belgrade USA North Carolina
BELG Belgrade USA Minnesota
NP North Port USA Alabama


Lookup request for CityCode = BO and Q1=USA and Q2=Massachusetts  returns "Boston" as result.

Lookup request for CityCode = BO and Q1=USA and Q2=null  returns no result.

Lookup request for CityCode = BO and Q1=null and Q2=Massachusetts  returns no result.

Lookup request for CityCode = BO and Q1=null and Q2=null returns "Boston" as result.



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

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