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

Last updated on NOVEMBER 03, 2016

Applies to:

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

Symptoms

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.

Example:

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.

 

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