My Oracle Support Banner

E-FLO: WriteRecord Output is Non-Compliant XML Numeric and Date Value If User Personalization is Used (Doc ID 1405172.1)

Last updated on JANUARY 31, 2022

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.4 to 8.52 [Release 8.4]
Information in this document applies to any platform.


PeopleTools (PT) 8.50.05  /   FSCM 9.1

In French locale, a personalized decimal and Digit Grouping symbol is used, e.g. comma as Decimal separator and dot as digit grouping separator. When attempting to use a File Layout to create XML file, the resulting XML file contains numeric values that are not compliant with XML standards.

Here is the spec for XML

The canonical representation of numeric and date datatypes:
numeric (decimal, float, double)
datetime (dateTime, time, date)

The canonical representation for numbers is no thousands separator, and a period for a decimal separator if there is one. Example: 100000.00

The canonical representation for dates is YYYY-MM-DD. Example: 2011-12-31

The canonical representation for times/datetimes allows a few options, but the date part stays the same:
YYYY-MM-DDTHH:MM:SS Example: 2011-12-31T23:30:00
YYYY-MM-DDTHH:MM:SS.ssssss Example: 2011-12-31T23:30:00.000000
and with timezones specified as Z (meaning 0000 offset from UTC) or with an offset with +/-nnnn offset from UTC.
Examples: 2011-12-31T23:30:00Z, 2011-12-31T23:00:00+0800
Timezone names such as PST are not valid in XML, they have to be either the numeric offset, or letter Z meaning 0000 offset.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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