I’m trying to validate an XML element to be numeric XXXX.XXXX.
I have the following element defined in my XSD
<xs:element name=“FILM_WIDTH”>
xs:annotation
xs:documentationRequired, film width</xs:documentation>
</xs:annotation>
xs:simpleType
<xs:restriction base=“xs:decimal”>
<xs:totalDigits value=“8”/>
<xs:fractionDigits value=“4”/>
</xs:restriction>
</xs:simpleType>
</xs:element>
I created a schema object in Developer importing the above XSD, and it correctly detected the totalDigits 8 fractionDigits 4 constraints (i.e. I can see them in developer).
In TN, I set the document type to validate the record using the schema above.
However, the only value which passes validation in that field is a 2 digit number. As soon as I use a 3 digit number or larger, and even include a decimal, TN gives me a validation error saying:
/E_PURCHASE_ORDER/FILM_WIDTH: [B2BCORE.0082.9489] Number of digits is greater than totalDigits
But the # of digits in the XML is NOT greater than the total digits!
I have the same problem with an integer field as well:
<xs:element name=“DELIVERY_MASS”>
xs:annotation
xs:documentationRequired, delivery mass</xs:documentation>
</xs:annotation>
xs:simpleType
<xs:restriction base=“xs:integer”>
<xs:totalDigits value=“10”/>
</xs:restriction>
</xs:simpleType>
</xs:element>
2 digits passed, 3 or more digits fails validation, but the max is 10!!
The 2 problems must be related.
Any ideas or suggestions are appreciated.