Data Is Truncated From The Beginning When Fixed Length Format Is Used (Doc ID 732669.1)

Last updated on APRIL 23, 2019

Applies to:

Symptoms

If mapping data into a fixed format schema and the data is larger than the target element length,
the data is truncated from the beginning. So for example, if I was mapping the word "apostrophe" into
an element that was defined as a fixed length 5 in the xsd, the data I would receive in the xml
would be "rophe", while "apost" is the expected result.

Testcase
Use File adapter to reproduce this issue.
Input -
aaaaqqqqqqqqqqqqqqqqqqqqqqqqbbbb

Schema used :-
<?xml version="1.0" encoding="UTF-8" ?>

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:nxsd="http://xmlns.oracle.com/pcbpel/nxsd"
targetNamespace="http://TargetNamespace.com/test"
xmlns:tns="http://TargetNamespace.com/test"
elementFormDefault="qualified"
attributeFormDefault="unqualified" nxsd:encoding="ASCII" nxsd:stream="chars"
nxsd:version="NXSD">
<xsd:element name="test" nxsd:style="array" nxsd:cellSeparatedBy="${eol}">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="C1" type="xsd:string" nxsd:style="fixedLength" nxsd:length="25">
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:schema>


Output -
qqqqqqqqqqqqqqqqqqqqqbbbb

The left 7 characters where truncated.

.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.