E-FLO: Application Engine using File Layout Generates Output which Reflects Incorrect Decimal Separator in Monetary Amount, when Run by French User (Doc ID 841277.1)

Last updated on JULY 25, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.1 and later
Information in this document applies to any platform.
***Checked for relevance on 18-MAR-2011***


Symptoms

This issue relates to the use of File Layout(FLO) in an Application Engine(AE) program which exports data into a flat file. However, the same type of issue can be seen with any other function that use regional setting, e.g. NumberToDisplayString()

The requirement, in this situation, is that the Decimal Separator be a comma (,) which is customary in France. The issue is the Decimal Separator is showing as decimal (.) instead.

IMPACT
-----------
The output generated is not correct it does not reflect the French standard, and therefore makes resulting output unusable.

When attempting to export data with monetary values using File Layout and Application Engine running in batch the following occurs...

EXPECTED BEHAVIOR
-----------------------
Expect data output for monetary value to have comma for decimal separator.

ACTUAL BEHAVIOR
-----------------------
The data output for monetary values have dot for decimal separator.

REFER TO ATTACHED E900G2AP-2nd-ReproAttempt.doc for in house REPLICATION STEPS

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms