My Oracle Support Banner

Data Loaded Into GL Using Web ADI Is Being Translated Into Other Characters (Doc ID 1567049.1)

Last updated on FEBRUARY 20, 2019

Applies to:

Oracle Web Applications Desktop Integrator - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


Initial issue was reported Chinese, but the issue has also been reported with German & French characters and probably occurs with other languages too.

After setting the profile option "BNE: Enable Upload Compression" to "Yes" when uploading data with accent like é, â, ö,  the data is getting converted from a multi-byte character set to a single byte character set such as WE8MSWIN1252 ÿ

Spreadsheet shows English, Line Description column has Chinese and English characters.

Upload is successful.

The data is getting converted before it gets to the Interface table.

(Excel Options -> Language Settings) - set to English (United States)

Regional settings on the client PC where this issue is reproduced:
Region/Language is English

BNE.log shows data has been changed to non Chinese characters

3/7/13 3:50 PM Web ADI Upload Job 1964142 INFORMATION No interface name defined for column: REFERENCE10 Using interface: GL_INTERFACE
3/7/13 3:50 PM Web ADI Upload Job 1964142 TRACE Column name: GL_INTERFACE.REFERENCE10 value: 张宁宁借员工食堂伙食费备用金lent petty cash for staff meals


Similarly for French message

Cause : Entrez un Type de transaction valide.
Action : Créer n'est pas valide. Entrez une valeur valide pour la colonne de mappage Type de transaction.

The transaction type in French was Créer and not Créer



 After the setting of profile option "BNE: Enable Upload Compression" to Yes and when uploading multi-byte data with accent like é, â, ö


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.