This discussion is archived
5 Replies Latest reply: Feb 15, 2013 4:44 PM by jkallman RSS

APEX 4.2.1 bug - Automatic language detection

Tobias Arnhold Journeyer
Currently Being Moderated
Hi,

we found a bug in the currect version of Oracle APEX 4.2.1:
Browser language can not be used in applications during the runtime.

We are developing mostly German applications but database standard character set is:
SELECT * FROM NLS_DATABASE_PARAMETERS
Parameter Value
NLS_LANGUAGE     AMERICAN
NLS_TERRITORY     AMERICA
NLS_CURRENCY     $
NLS_ISO_CURRENCY     AMERICA
NLS_NUMERIC_CHARACTERS     .,
NLS_CHARACTERSET     WE8ISO8859P15
NLS_CALENDAR     GREGORIAN
NLS_DATE_FORMAT     DD-MON-RR
NLS_DATE_LANGUAGE     AMERICAN
All applications are set up with "Globalization Attributes":
 Application Primary Language: German
 Application Language Derived From: Browser (use browser language preference)
 Application Date Format: DD.MM.YYYY
In all former versions of APEX it changes the default settings from the database to the browser settings. In the current version it does NOT change the language.
For example: APEX 4.1 number value
10.000,00

APEX 4.2.1 number value
10,000.00

If I check the debug log I find this:
0.04096     0.00016     S H O W: application="101" page="16" workspace="" request="" session="16485344217862"     4     
0.04110     0.00044     Reset NLS settings     4     
0.04155     0.00020     alter session set NLS_LANGUAGE="AMERICAN"     4     --> This is the default behavior
0.04174     0.00016     alter session set NLS_TERRITORY="AMERICA"     4     
0.04189     0.00014     alter session set NLS_CALENDAR="GREGORIAN"     4     
0.04203     0.00014     alter session set NLS_SORT="BINARY"     4     
0.04217     0.00017     alter session set NLS_COMP="BINARY"     4     
0.04234     0.00003     ...NLS: Set Decimal separator="."     4     
0.04237     0.00014     ...NLS: Set NLS Group separator=","     4     
0.04251     0.00013     ...NLS: Set g_nls_date_format="DD-MON-RR"     4     
0.04264     0.00013     ...NLS: Set g_nls_timestamp_format="DD-MON-RR HH.MI.SSXFF AM"     4     
0.04277     0.00032     ...NLS: Set g_nls_timestamp_tz_format="DD-MON-RR HH.MI.SSXFF AM TZR"     4     
0.04309     0.00005     NLS of database and client differs, characterset conversion needed     4     
0.04314     0.00257     ...Setting session time_zone to +01:00     4     
0.04572     0.00005     NLS: Language=       --> No changes are made, default language will stay
Issue happens in all browsers: FF, Chrome, IE

Somebody else had similar issues as we did:
Apex 4.2 - Not clear behaviour with translated applications

Hope you can help. You may even have a workaround? Problem is especially difficult with translated applications!

Thanks

Tobias

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points