FINS Industry XML Query Service does not handle all XPath expressions.
(Doc ID 503687.1)
Last updated on FEBRUARY 04, 2019
Applies to:Siebel System Software - Version 18.104.22.168 SIA  and later
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 22.214.171.124  Fin Svcs
Database: Oracle 126.96.36.199
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.
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