My Oracle Support Banner

How to Change the Default Language in the Offering Creation? (Doc ID 422966.1)

Last updated on DECEMBER 21, 2016

Applies to:

Oracle Learning Management - Version and later
Information in this document applies to any platform.


This note will explain the change about the Language used for offerings in OLM.
In order to illustrate that change, we will use English in this example.

First of all ensure that you have the following set:
a. As system administrator navigate to profile/system

b. check profile option FND:OA:Enable Defaults is set to Yes for the Site level.

c. If you do not see the link "Personalize 'General'" with learning management administrator responsibility, 
    you may need to set the following profile(s) and bounce Apache to be able to view these links:

    FND: Personalization Region Link (Enabled)
    Personalize Self-Service Defn" (YES)
    "FND: Personalization Region Link Enabled" enables the "Personalize Region" links on a page if the
    Personalize Self-Service Defn profile is set to Yes.
    Hence, setting this profile should display the link "Personalize General"

  OTA.J.RUP2 and higher (including R12)

a. The table recording the languages used is: FND_NATURAL_LANGUAGES

b. Maintaining Data:
    i log as system administrator responsibility
    ii Navigate to  Install > Natural Languages
    iii Enable languages you need to retrieve when creating your offerings. 
       in our example we decide to enable English (United Kingdom) as just English was enabled.

    iv with that form you can pick up the language code to be used in the personalization page.

c. Select statement to find the same values displayed in the form on step b: 
    select language_code, name, iso_language_3, description
    from ota_natural_languages_v 
    where name like '%Eng%' ;
    LANGUAGE_CODE      NAME                                ISO_LA           DESCRIPTION
    ---------------------- -------------------------         --------- -----------------------------------
    ang                       English, Old                         ang      English, Old (ca.450-1100
    cpe                       Creoles and pidgins...           cpe       Creoles and pidgins, English based...
    en                         English                                eng      English
    en-GB                    English (United Kingdom)      eng      English (United Kingdom)
    en-AU                    English (Australia)                eng      English (Australia)
    en-BZ                    English (Belize)                    eng      English (Belize)
    en-CA                    English (Canada)                 eng      English (Canada)
    en-IE                     English (Ireland)                  eng      English (Ireland)
    en-US                    English (United States)         eng      English (United States)

d. Language_code is the value to used in the personalization to default the language.

    with our example, by defaulting to "English (United Kingdom)" the language, we see by default: English (United Kingdom).


the languages proposed for an offering were based on the translated language for oracle
applications which was more restrictive than the long list of existing language in the world.

The column language_code has been introduced in the ota_offerings table in order to handle
all the existing languages (introduced with Bug 2733966 )
Nevertheless although the language_id column has been kept in the ota_offerings table for historical reasons, it has been suppressed
from the views like OTA_EVENTS_V for instance, as it is not used anymore. Please use Language_code instead.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.