how to save payload of soa composite to xml file?

Question

i am working on oracle SOA project in which i want to save csv data to XML file. till now i got the payload in form of xml using Translate activity but i can only use it directly. I want to save the pay load to xml file.

i am facing following error :

<?xml version="1.0" encoding="UTF-8"?><bpelFault>
   <faultType>0</faultType>
   <subLanguageExecutionFault xmlns="http://docs.oasis-open.org/wsbpel/2.0/process/executable">
      <part name="summary">
         <summary>An error occurs while processing the XPath expression; the expression is ora:doXSLTransformForDoc("../Transformations/Transformation.xsl", $Receive_Read_InputVariable.body)</summary>
      </part>
      <part name="code">
         <code>XPath expression failed to execute</code>
      </part>
      <part name="detail">
         <detail>XPath expression failed to execute.
An error occurs while processing the XPath expression; the expression is ora:doXSLTransformForDoc("../Transformations/Transformation.xsl", $Receive_Read_InputVariable.body)
The XPath expression failed to execute; the reason was: javax.xml.transform.TransformerException: oramds:/deployed-composites/default/CSV_To_XML_rev1.0/Transformations/Transformation.xsl&lt;Line 30, Column 109&gt;: XML-22031: (Error) Variable not defined: 'oracle_empty_param'.
Check the detailed root cause described in the exception message text and verify that the XPath query is correct.
</detail>
      </part>
   </subLanguageExecutionFault>
</bpelFault>

I am working with oracle soa suite 12c.

@underscore_d while translating native data to xml and assigning it to write file adapter — Paras, Apr 20 '18 at 12:45
You don't say what version you are on. *Always* include version number. I think this may be related to a similar problem in version 12.1. You should go to My Oracle Support and search there for this error for this product. — Joe, Apr 25 '18 at 12:47
https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=ehe77slbx_9&_afrLoop=235410543045302 - there are more there, so you should search there. — Joe, Apr 30 '18 at 22:01

score 0 · Answer 1 · answered Jun 04 '18 at 13:49

It sounds like you want to convert a variable to a string. I would use an XSL transform. Input to the transform would be your newly translated variable and the output be a plain old String variable. The transform would look like this:

  <xsl:template match="/">
    <tns:myString>
      <xsl:copy-of select="/ns0:RootElement"/>
    </tns:myString>
  </xsl:template>

If you wanted to, you could then write this string to the file adapter

how to save payload of soa composite to xml file?

1 Answers1