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

Last updated on JANUARY 09, 2017

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.

Symptoms

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

Messages
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

 

Changes

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

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