Skip to Main Content
Forums

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

getNodes returing Mulitple nodes error

TarakNov 29 2012 — edited Feb 26 2020
Hi All,

I am trying to use xpath query getNodes to get the each node from the xml and assign to the variable of type element.

When i ran it i am ending with error as below. I am sure what have give is correct.

XPath query string returns multiple nodes. The assign activity part and query are returning multiple nodes. The assign activity part and query named in the error message returned multiple nodes. It should return single node. According to BPEL4WS specification 1.1 section 14.3, the assign activity part and query named in the error message should not return multiple nodes. Verify the part and xpath query named in the error message at line number 203 in the BPEL source.

Could some one please help me here.

My assign activity
<assign name="Asg_getNodesReceipt">
      <copy>
        <from expression="ora:getNodes('CtReceivingUpload','/ns14:receipts/ns14:receipt[$count]')"/>
        <to variable="receipttest" query="/ns14:receipt"/>
      </copy>
    </assign>
receipttest is the variable of element type receipt.

XSD is here :-
<?xml version="1.0" encoding="windows-1252" ?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
            xmlns="http://www.manh.com/Custom/SOA/CtReceivingDownload/CtReceivingDownload.xsd"
            targetNamespace="http://www.manh.com/Custom/SOA/CtReceivingDownload/CtReceivingDownload.xsd"
            elementFormDefault="qualified">
  <xsd:element name="receipts">
    <xsd:complexType>
    <xsd:sequence>
    <xsd:element minOccurs="1" maxOccurs="unbounded" ref ="receipt"/>
    </xsd:sequence>
    </xsd:complexType>
  </xsd:element>
  <xsd:element name="receipt">
  <xsd:complexType>
  <xsd:complexContent mixed="false">
  <xsd:extension base="InterfaceEntity">
  <xsd:sequence>
  <xsd:element minOccurs="0" maxOccurs="1" name="Appointment" type="Appointment"/>
 <xsd:element minOccurs="0" maxOccurs="1" name="ArrivedDate" type="xsd:dateTime"/>
 <xsd:element minOccurs="0" maxOccurs="1" name="InternalRecNum" type="xsd:int"/>
 <xsd:element minOccurs="0" maxOccurs="1" name="ReceiptId" type="xsd:string"/>
 <xsd:element minOccurs="0" maxOccurs="1" name="ReceiptType" type="xsd:string"/>
 <xsd:element minOccurs="0" maxOccurs="1" name="Details" type="ReceiptDetailList"/>
 <xsd:element minOccurs="0" maxOccurs="1" name="ReceiptContainers" type="ReceiptContainerList"/>
 </xsd:sequence>
 </xsd:extension>
 </xsd:complexContent>
 </xsd:complexType>
 </xsd:element>
 <xsd:complexType name="Appointment">
 <xsd:sequence>
 <xsd:element minOccurs="0" maxOccurs="1" name="ApptDateTime" type="xsd:dateTime"/>
 </xsd:sequence>
 </xsd:complexType>
 <xsd:complexType name="ReceiptDetailList">
<xsd:sequence>
<xsd:element minOccurs="0" maxOccurs="unbounded" name="ReceiptDetail" nillable="true" type="ReceiptDetail"/>
</xsd:sequence>
</xsd:complexType>
<xsd:complexType name="ReceiptDetail">
<xsd:complexContent mixed="false">
<xsd:extension base="InterfaceEntity">
<xsd:sequence>
<xsd:element minOccurs="0" maxOccurs="1" name="ErpOrderNum" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="SKU" type="SKU"/>
</xsd:sequence>
</xsd:extension>
</xsd:complexContent>
</xsd:complexType>
<xsd:complexType name="SKU">
<xsd:sequence>
<xsd:element minOccurs="0" maxOccurs="1" name="Item" type="xsd:string"/>
</xsd:sequence>
</xsd:complexType>

<xsd:complexType name="ReceiptContainerList">
<xsd:sequence>
<xsd:element minOccurs="0" maxOccurs="unbounded" name="ReceiptContainer" nillable="true" type="ReceiptContainer"/>
</xsd:sequence>
</xsd:complexType>
<xsd:complexType name="ReceiptContainer">
<xsd:sequence>
<xsd:element minOccurs="0" maxOccurs="1" name="ContainerId" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="ReceiptDetail" type="ReceiptDetail"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Qty" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="Status" type="xsd:int"/>
</xsd:sequence>
</xsd:complexType>
<xsd:complexType name="InterfaceEntity">
<xsd:sequence>
<xsd:element minOccurs="0" maxOccurs="1" name="UserDef1" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="UserDef2" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="UserDef3" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="UserDef4" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="UserDef5" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="UserDef6" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="UserDef7" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="UserDef8" type="xsd:decimal"/>
<xsd:element minOccurs="0" maxOccurs="1" name="UserStamp" type="xsd:string"/>
<xsd:element minOccurs="0" maxOccurs="1" name="appt_nbr" type="xsd:string"/>
</xsd:sequence>
</xsd:complexType>
 </xsd:schema>
XML is here:-
<receipts xmlns:ns6="http://www.manh.com/Custom/SOA/CtReceivingDownload/CtReceivingDownload.xsd" xmlns="http://www.manh.com/Custom/SOA/CtReceivingDownload/CtReceivingDownload.xsd"><ns6:receipt><ns6:appt_nbr>N</ns6:appt_nbr><ns6:ArrivedDate>2012-11-28T15:31:40</ns6:ArrivedDate><ns6:InternalRecNum>1001473</ns6:InternalRecNum><ns6:ReceiptId>16173</ns6:ReceiptId><ns6:ReceiptType>ASN</ns6:ReceiptType><ns6:Details><ns6:ReceiptDetail><ns6:UserDef3>10000</ns6:UserDef3><ns6:UserDef7>1.00000</ns6:UserDef7></ns6:ReceiptDetail><ns6:ReceiptDetail><ns6:UserDef3>10000</ns6:UserDef3><ns6:UserDef7>1.00000</ns6:UserDef7></ns6:ReceiptDetail></ns6:Details><ns6:ReceiptContainers><ns6:ReceiptContainer><ns6:ContainerId>00099999990000017444</ns6:ContainerId><ns6:ReceiptDetail><ns6:ErpOrderNum>421431</ns6:ErpOrderNum><ns6:SKU><ns6:Item>5602001</ns6:Item></ns6:SKU></ns6:ReceiptDetail><ns6:Qty>170.00000</ns6:Qty><ns6:Status>900</ns6:Status></ns6:ReceiptContainer><ns6:ReceiptContainer><ns6:ContainerId>00099999990000017433</ns6:ContainerId><ns6:ReceiptDetail><ns6:ErpOrderNum>421431</ns6:ErpOrderNum><ns6:SKU><ns6:Item>5602060</ns6:Item></ns6:SKU></ns6:ReceiptDetail><ns6:Qty>118.00000</ns6:Qty><ns6:Status>900</ns6:Status></ns6:ReceiptContainer></ns6:ReceiptContainers></ns6:receipt><ns6:receipt><ns6:appt_nbr>Y</ns6:appt_nbr><ns6:ArrivedDate>2012-11-28T15:33:41</ns6:ArrivedDate><ns6:InternalRecNum>1001474</ns6:InternalRecNum><ns6:ReceiptId>16174</ns6:ReceiptId><ns6:ReceiptType>ASN</ns6:ReceiptType><ns6:Details><ns6:ReceiptDetail><ns6:UserDef3>10000</ns6:UserDef3><ns6:UserDef7>1.00000</ns6:UserDef7></ns6:ReceiptDetail><ns6:ReceiptDetail><ns6:UserDef3>10000</ns6:UserDef3><ns6:UserDef7>1.00000</ns6:UserDef7></ns6:ReceiptDetail></ns6:Details><ns6:ReceiptContainers><ns6:ReceiptContainer><ns6:ContainerId>00099999990000017466</ns6:ContainerId><ns6:ReceiptDetail><ns6:ErpOrderNum>421431</ns6:ErpOrderNum><ns6:SKU><ns6:Item>5602182</ns6:Item></ns6:SKU></ns6:ReceiptDetail><ns6:Qty>75.00000</ns6:Qty><ns6:Status>900</ns6:Status></ns6:ReceiptContainer><ns6:ReceiptContainer><ns6:ContainerId>00099999990000017455</ns6:ContainerId><ns6:ReceiptDetail><ns6:ErpOrderNum>421431</ns6:ErpOrderNum><ns6:SKU><ns6:Item>5602078</ns6:Item></ns6:SKU></ns6:ReceiptDetail><ns6:Qty>138.00000</ns6:Qty><ns6:Status>900</ns6:Status></ns6:ReceiptContainer></ns6:ReceiptContainers></ns6:receipt></receipts>
I am happy if someone point out where i went wrong here.

Edited by: Tarak on Nov 29, 2012 6:36 PM
This post has been answered by vladodias on Nov 29 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 27 2012
Added on Nov 29 2012
#business-process-management-suite, #soa-process-management
7 comments
479 views