Last updated on DECEMBER 21, 2016
Applies to:Oracle Learning Management - Version 22.214.171.124 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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms