OBIEE 10G/11G - WEBLANGUAGE system session variable


Part of the process of customizing is localizing the interface, users can select a language on the sign-in page of BI Presentation Service. Many elements of the interface are automatically displayed in this language.

This user's setting is stored in the WEBLANGUAGE system session variable.

In an integrated Oracle BI application environment, the value of the WEBLANGUAGE variable is what determines the value of the LOCALE variable for externalized display names.

WEBLANGUAGE is initialized automatically, based on the language selected when a user logs in. You don't need to create an initalization block.

How the language value is determined ?

For Presentation Services

The language is set based on the WEBLANGUAGE session variable. WEBLANGUAGE is set to the language of the user's browser when a user logs in for the first time. For example, if a user with a browser language set to French logs in for the first time, then the value for WEBLANGUAGE is French, and the metadata is translated to French.

After the first logon, users can change the language setting on the Preferences tab of the My Account dialog.

For other clients

For other clients including third-party clients, the language is determined by the following precedence model:

  • The language is set based on the WEBLANGUAGE session variable.
  • If the WEBLANGUAGE session variable is not set, then the language is based on the language that is specified in the ODBC Data Source Name (DSN) that is used to access the Oracle BI Server.
  • If an language has not been set in the ODBC DSN, then the language that is specified in the ORACLE_BI_LANG environment variable is used. To change the value of ORACLE_BI_LANG, update the character code for this variable in opmn.xml. You can view the character codes for supported languages in the ORACLE_HOME/bifoundation/server/locale directory (for example, “en” for English, or “pt-BR” for Portuguese/Brazilian).
  • If the ORACLE_BI_LANG environment variable is not set, then messages are displayed in English.

Note that clients as the Administration Tool and Job Manager do not set the WEBLANGUAGE session variable.


Value Language
cs Czech
da Danish
de German
en English
es Spanish
fi Finnish
fr French
it Italian
ja Japanese
ko Korean
nl Dutch
pt Portuguese
pt-br Brazilian Portuguese
sv Swedish
zh Chinese (Simplified)
zh-tw Chinese (Traditional)


In OBIEE - Instanceconfig.xml (Configuration Presentation Services):

<!-- To configure a limited set of languages to be available to users uncomment the <AllowedLanguages> tag below 
and choose a subset set of language tags from the list. Values must be comma separated. -->

<!-- <AllowedLanguages>ar,cs,da,de,el,en,es,fi,fr,hr,hu,it,iw,ja,ko,nl,no,pl,pt,pt-br,ro,ru,sk,sv,th,tr,zh,zh-tw</AllowedLanguages> -->

Documentation / Reference

Powered by ComboStrap