FINS Industry XML Query Service does not handle all XPath expressions. (Doc ID 503687.1)

Last updated on AUGUST 16, 2016

Applies to:

Siebel System Software - Version 7.5.3.15 SIA [16279] and later
Oracle Solaris on SPARC (64-bit)
Product Release: V7 (Enterprise)
Version: 7.5.3.15 [16279] Fin Svcs
Database: Oracle 9.2.0.1
Application Server OS: Sun Solaris 8
Database Server OS: Sun Solaris 9

This document was previously published as Siebel SR 38-3520481201.



Symptoms

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:

<inventory>
<drink>
<lemonade supplier="mother" id="1">
<price>$2.50</price>
<amount>20</amount>
</lemonade>
<coke supplier="someone" id=”4”>test</coke>
<pop supplier="store" id="2">
<price>$1.50</price>
<amount>10</amount>
</pop>
</drink>
<snack>
<chips supplier="store" id="3">
<price>$4.50</price>
<amount>60</amount>
<calories>180</calories>
</chips>
</snack>
</inventory>



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 ([0], [2], etc) to reference nodes do not seem to work.

3. The “//” operator, allowing searches two or more levels deep, does not seem to work.

Cause

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