5 Replies Latest reply: Feb 15, 2013 6:44 PM by joelkallman-Oracle RSS

    APEX 4.2.1 bug - Automatic language detection

    Tobias Arnhold
      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