Translation Error while doing Transformations in SOA

In the Transformation file (.xsl) we map source variable attributes to destination variable attributes.

Let’s say out destination is DBAdapterWriteInputVariable which has 25 columns. In the Transformation file if you map only 15 columns from source to destination (DBAdapterWriteInputVariable) and left the remaining 10 attributes as blank, then at the Transformation step of composite you’ll get this Translation error. This error is because target system is expecting values with respect to its defined schema (25 values) but the transformation file doesn’t map all the values according to the schema (only maps 15), so the error come here.

So all you need to do is, though you are not assigning any values to few attributes, they must be declared (present in source code of XSL file) like <attribute7/> having no value.

To declare them right click on each attribute in design mode which is not present in Source mode, and click on Edit Text and Enter (No need to give any value), so that attribute declaration will be saved which you can see in the source mode.


Hope this is helpful!


Translate Native Format File to XML File and Vice versa using Translator in SOA 12c

Translator is the new component introduced in SOA 12c which is very useful to convert any native format file like CSV to XML and vice versa.

Now am going to create a new application and BPEL process for doing this in JDeveloper 12.1.3

1) Create a new SOA Application named ‘TranslateApplication‘ and a project named ‘TranslateProj


2) Select Composite with BPEL Process and click on Finish

3) Name the BPEL Process as ‘TranslateBPELProcess‘ and Template as ‘Synchronous BPEL Process’ and click on OK


4) Drag and drop the Translate Activity which is under Oracle Extensions to the BPEL Process and double click on it.


5) Click on the Search icon and for Input and assign the client:input variable to it


6) For NXSD Schema field Click on the ‘New xsd icon’ and Select file type as Delimited and click on Next.


7) In the next screen browse the File and click on Next.


8) Select File contains only one record and Next. In next screen Enter the name for element as ‘Emp’


9) Check the Use First Record as the Field Name and click on Next and Finish.


10) Create an Output variable for assigning to reply Output and click on OK.


11) Now open the created Schema and remove the few xsd:schema attributes which are not required (nxsd:hasHeader, nxsd:HeaderLines , nxsd:headerLinesTerminatedBy) and save it.


12) Deploy the Project to server


13)  Give the value for input as ‘Ravi, 15, 1000’ and click on Test Web Service and then click on ‘Launch Flow Trace’


14) Click on Input and Translate to see the comma seperated input and XML output.


15) If you are not able to see the Translate value in XML format then click on the deployed project and under settings change the Composite Audit Level to Development and test again. You can see the response in XML Format.