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!

XPath expression failed to execute Error during evaluation of XPath "ora:doXSLTransformForDoc

abhijitapawarMay 8 2025 — edited May 12 2025

Hello Friends,

I am getting an xpath error while mapping xml string using parseXML(TOInputPayload) function to stage file

Below is code snippet from code view of OIC Mapper

`<xsl:template match="/" xml:id="id_11">`  
     `<nstrgmpr:Write xml:id="id_12">`  
           `<xsl:copy-of select="oraext:parseXML ($TOInputPayload )"/>`  
     `</nstrgmpr:Write>`

</xsl:template>

TOInputPayload=

&lt;LgfData&gt;&lt;Header&gt; &lt;DocumentVersion&gt;23.1.0&lt;/DocumentVersion&gt; &lt;OriginSystem&gt;Oracle Fusion Inventory Management&lt;/OriginSystem&gt; &lt;ClientEnvCode&gt;23A&lt;/ClientEnvCode&gt; &lt;ParentCompanyCode&gt;PP&lt;/ParentCompanyCode&gt; &lt;Entity&gt;ib_shipment&lt;/Entity&gt; &lt;TimeStamp&gt;2025-05-05T21:36:34.177Z&lt;/TimeStamp&gt; &lt;MessageId&gt;100000118580509&lt;/MessageId&gt; &lt;/Header&gt;&lt;ListOfIbShipments&gt;&lt;ib_shipment&gt;&lt;ib_shipment_hdr&gt; &lt;shipment_nbr&gt;OSODL10100010841-1&lt;/shipment_nbr&gt; &lt;facility_code&gt;206&lt;/facility_code&gt; &lt;company_code&gt;ODLUS&lt;/company_code&gt; &lt;trailer_nbr&gt;841&lt;/trailer_nbr&gt; &lt;action_code&gt;CREATE&lt;/action_code&gt; &lt;ref_nbr&gt;675290&lt;/ref_nbr&gt; &lt;shipment_type&gt;TRANSFER ORDER&lt;/shipment_type&gt; &lt;/ib_shipment_hdr&gt;&lt;ib_shipment_dtl&gt; &lt;seq_nbr&gt;1065524&lt;/seq_nbr&gt; &lt;action_code&gt;CREATE&lt;/action_code&gt; &lt;item_alternate_code&gt;310556&lt;/item_alternate_code&gt; &lt;shipped_qty&gt;1&lt;/shipped_qty&gt; &lt;lpn_nbr&gt;00372569&lt;/lpn_nbr&gt; &lt;batch_nbr&gt;&lt;/batch_nbr&gt; &lt;expiry_date&gt;&lt;/expiry_date&gt; &lt;shipping_packing_unit&gt;1010505202500372569&lt;/shipping_packing_unit&gt; &lt;shipping_outermost_packing_unit&gt;1010505202500372569&lt;/shipping_outermost_packing_unit&gt; &lt;pallet_nbr&gt;1010505202500372569&lt;/pallet_nbr&gt; &lt;receipt_advice_line&gt;675290~^~1065524&lt;/receipt_advice_line&gt; &lt;/ib_shipment_dtl&gt;&lt;/ib_shipment&gt;&lt;/ListOfIbShipments&gt;&lt;/LgfData&gt;

Error - XPath expression failed to execute

Error during evaluation of XPath "ora:doXSLTransformForDoc('resources/processor_9420/resourcegroup_9423/req_a982e43c03f343b0a6555d31bb63edf3.xsl', $messagecontext_24, 'IntegrationVersion', $messagecontext_7919, 'offSet', $messagecontext_395, 'hasMore', $messagecontext_443, 'IntegrationCode', $messagecontext_7863, 'OicInstanceId', $messagecontext_6626, 'serialHeaderCollection', $messagecontext_2804, 'IntegrationName', $messagecontext_6548, 'OrderType', $messagecontext_6043, 'TOInputPayloadHdr', $messagecontext_8801, 'TOInputPayload', $messagecontext_8863, 'tracking_var_1', $ics_api_internal_rep_flow_inst_name, 'serialCollection', $messagecontext_2820, 'serialElement', $messagecontext_2827, 'tracking_var_3', $ics_api_internal_rep_cust_prop_2, 'tracking_var_2', $ics_api_internal_rep_cust_prop_1, 'selfProperties', $messagecontext_327, 'RESTReceiptAdviceLines', $messagecontext_34, 'CreatedBy', $messagecontext_7891, 'TrackingIdentifier', $messagecontext_7785, 'TrailerNumber', $messagecontext_5858, 'module', $messagecontext_6470, 'IBShipmentsData', $messagecontext_8451, 'ShipNumber', $messagecontext_5927, 'serialHeaderElement', $messagecontext_2811, 'RESTReceiptAdviceLines_REQUEST', $messagecontext_32, 'self', $messagecontext_100, 'TOInputPayloadDtl', $messagecontext_8832)"

Stage File where I am trying to write file - Sample XML document is as attached - SaveXMLForTO-InputPayloadTemplate.txt

Also attached XSL Code (Map to SaveXMLForTO-XSL-Code.txt) for the above mentioned mapper for reference which shows above error.

Any pointers - suggestions would be appreciated, Thanks.

-Abhijit

SaveXMLForTO-InputPayloadTemplate.txt

Map to SaveXMLForTO-XSL-Code.txt
Comments
Post Details
Added on May 8 2025
#oic, #oicgen3
0 comments
349 views