DVM lookup not returning a value when a Domain Qualifier is Null, SOA 11.1.1.7
(Doc ID 2000194.1)
Last updated on APRIL 23, 2019
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.
CityCode | CityName | Q1 (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
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
Symptoms |
Cause |
Solution |
References |