Integration Exported from Oracle Integration Cloud Service is Not Working in Oracle Integration

If you export an integration from Oracle Integration Cloud Service and import it into Oracle Integration, you may receive the following runtime failure even though there was no runtime error in Oracle Integration Cloud Service. For this example, the failure occurred in the Read File in Segments operation of the stage file action. The filename and directory parameters were configured using an XPath expression.

ErrorCode:
{http://schemas.xmlsoap.org/ws/2003/03/business-process/}selectionFailure
Details: XPath query string returns multiple nodes.
The assign activity part and query
$messagecontext_77.parameters/../nsmpr8:DownloadFileToICSResponse/nsmpr10:Down
loadResponse/nsmpr10:ICSFiles/nsmpr2:ICSFile/nsmpr2:Properties/nsmpr2:director
y 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 2562 in
the BPEL source.

This is an expected error in Oracle Integration if an XPath expression configured for a filename or directory is returning multiple nodes. In Oracle Integration Cloud Service, the first file in the array returned by the XPath expression is selected. This behavior has been changed in Oracle Integration.

As a solution:

• Add an appropriate predicate in your XPath expression to select a single node.
• Use a for-each action to loop over the repetitive element in the XPath expression. You can include a switch action inside the for-each action to select the necessary file/directory.