Setting the Application Language

Before you begin the configuration, set the language in which you want to view the application, and specify your preferred currencies.

For the application language, you must create the language folders and enable the application language selection. All localized files are in OFMA_Installed_Location/OFMA/Localization_File.

See “Localizing Oracle Business Intelligence” in the Oracle® Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.


HFM users must set a language preference, because all the HFM metadata accessed from OBIEE is displayed based on the language preference set in HFM Workspace.

  To enable application language selection:

  1. Optional: If BI Services are not stopped, select Start, then All Programs, then Oracle Business Intelligence, and then Stop BI Services.

  2. Navigate to ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obipsn/msgdb/l_xx/captions, where xx is the language extension, and open the msgdb.

    For example, this file is located in C:/BIEE111171/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/.

  3. In the msgdb, create a language folder (l_xx) for each language that you want to use, where xx represents the language:

    • l_en (English)

    • l_de (German)

    • l_fr (French)

    • l_it (Italian)

    • l_sv (Swedish)

    • l_pl (Polish)

    • l_fi (Finnish)

    • l_ko (Korean)

    • l_da (Danish)

    • l_nl (Dutch)

    • l_tr (Turkish)

    • l_ru (Russian)

    • l_zh-TW (Traditional Chinese)

    • l_zh-CN (Simplified Chinese)

    • l_ja (Japanese)

    • l_pt-BR (Portuguese Brazilian)

    • l_es (Spanish)

  4. In each language folder (l_xx), create a captions folder.

  5. Navigate to Localization_File in the installation directory, and copy the required language folders. By default, the files are in OFMA_Installed_Location/OFMA/Localization_File.

  6. Paste the copied localization file into the respective language captions folder.

    • C:/BIEE111171/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/msgdb/l_fr/captions/ofmacaptions_fr.xml

    • C:/BIEE111171/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/msgdb/l_de/captions/ofmacaptions_de.xml

    • C:/BIEE111171/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/msgdb/l_it/captions/ofmacaptions_it.xml

  7. Select Start, then All Programs, then Oracle Business Intelligence and then Start BI Services.

  8. When you restart BI services, select the language in which you want to view the application and data from the list, and then enter your User ID and Password.

    The application is displayed using the selected language and currencies.

  9. Click Sign In.