FINS Industry XML Query Service does not handle all XPath expressions.
Last updated on MARCH 01, 2018
Applies to:Siebel System Software - Version 220.127.116.11 SIA  and later
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 18.104.22.168  Fin Svcs
Database: Oracle 22.214.171.124
Application Server OS: Sun Solaris 8
Database Server OS: Sun Solaris 9
This document was previously published as Siebel SR 38-3520481201.
For the benefit of other users, the customer was using the FINS Industry XML Query Service to retrieve element and attribute settings from an XML document. They identified that, in certain cases, given a valid XPath expression, the BS did not return the expected result. They demonstarted this using the following example:
<lemonade supplier="mother" id="1">
<coke supplier="someone" id=”4”>test</coke>
<pop supplier="store" id="2">
<chips supplier="store" id="3">
The customer highlighted the following cases:
1. There is no way that seems to work for full queries.
/inventory/drink/*[@id = ‘1’]/@supplier
does not work to find the value of the “supplier” attribute where the “id” attribute = “1”,
/inventory/drink/coke[@id = ‘4’]/@supplier
does not give the supplier of Coke, and
/inventory/drink/*[@supplier = ‘someone’]
Just returns all rows regardless of the “[@supplier = ‘someone’]” query.
2. Other functions such as using numbers (, , etc) to reference nodes do not seem to work.
3. The “//” operator, allowing searches two or more levels deep, does not seem to work.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms