Databases Reference
In-Depth Information
To create dynamic translations, you must use the “Optionally identify any data that needs to be
dynamically translated to support SQL based lists of values” option in the Translate Non Application
Text section, as shown in Figure 5-15. This section is found in Translate Application in the Shared
Components.
Figure 5-15.
Dynamic Translations option
For example, we may decide to always translate “Sales” to “Ventes”, “Accounting” to
“Comptabilité”, and “Shipping” to “Livraison.”
The steps to follow are as follows (see Figure 5-16):
Select the language to translate to and that matches the mapped translated
application language.
Enter the Translate From text: Sales.
Enter the Translate To text: Ventes.
Figure 5-16.
Dynamic Translation page
The Translate From Text must exactly match the text that will be selected by the List of Values using
the
APEX LANG.LANG
function. Once all the translations have been entered into the Dynamic Translations
repository, the
APEX LANG.LANG
function will return the corresponding translations in the lists of values.
Select APEX LANG.LANG(Department)
From departments;
The result of the LOV query in English (en-us) is shown in Figure 5-17.
