Data Loaded Into GL Using Web ADI Is Being Translated Into Other Characters
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.
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 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 é, â, ö
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms