My Oracle Support Banner

French Characters In The Etext Generated Output File Not Appearing Properly in the output (Doc ID 2431851.1)

Last updated on AUGUST 20, 2018

Applies to:

Oracle Fusion Global Human Resources - Version and later
Information in this document applies to any platform.


On : version, Technology Management - BI & Reporting

Customer developed an extract interface with the template type as etext (The format of the etrext template used was UTF-8).The output file contains French characters .When ftping the file from Oracle Fusion to private ftp site it appears correctly(French Word : Sérénade) however when the vendor is picking the file from private sftp directory (in Binary mode) the French characters are not appearing correctly(Word : Sérénade)

Customer had a call with vendor and they mentioned that they are expecting the file to encoded in ANSI and not in UTF-8 format.

Customer had modified the format of the etext template to iso-8859-1 from UTF-8. When they view the extract output through the BI screen the French characters appears incorrectly. However when they save the file with .txt extension and open the same using notepad/notepad++ the French characters are appearing correctly.

They would like to know couple of things
1) How to set the encoding of the output file generated from BI to ANSI? We are not setting the encoding explicitly so does that mean when I am using ascii format in the etext template and storing the output as .txt file the encoding is automatically taken care of ?
2) The vendor is picking the file from vertiv sftp directory using Binary mode , is that causing any issue?
3) If we transmit the above txt file (etext template format set to iso-8859-1) to vertic sftp directory , do the vendor needs to change the mode from Binary to Ascii while they pick the file for the French characters to appear correctly?

An early response on this is highly appreciated.

Thanks & Regards,


To view full details, 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 a vibrant support community of peers and Oracle experts.