DVM lookup not returning a value when a Domain Qualifier is Null, SOA 184.108.40.206
Last updated on NOVEMBER 03, 2016
Applies to:Oracle SOA Suite - Version 220.127.116.11.0 to 18.104.22.168.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.
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