DVM lookup not returning a value when a Domain Qualifier is Null, SOA 220.127.116.11
(Doc ID 2000194.1)
Last updated on APRIL 23, 2019
Applies to:Oracle SOA Suite - Version 18.104.22.168.0 to 22.214.171.124.0 [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.
|CityCode||CityName||Q1 (Country)||Q2 (State)|
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