Oracle APEX Multi Language translation

How to translate Oracle APEX into Multi-Languages?

In application development, multilanguage translation is always a tedious job to accomplish. But when it comes to APEX is just like couple of steps. Found Interesting? Let's see.....

• Language Selector

Select all the available languages for the application.

apex_lang.emit_language_selector_list;

apex_lang package is very useful to identify all the available languages in the application. It holds the above procedure which fetches the language select list.

• Letting Application know

&p_lang parameter can be passed in the application URL to define the current language. So in the application URL would append the string "&p_lang=en-gb", where "en-gb" is language code.

How to pass the language code to URL?

Passing language code to the application URL is as easy as fetching the language list from the application. If you are using apex_lang.emit_language_selector_list  procedure to select the language list then it has the property to pass the language code to URL by selecting the language.

After language selection URL would be like 

http://127.0.0.1:1902/apex/f?p=153:9999:9660454344633:::::&p_lang=en-gb

Steps to translate.

• Select "session" in the language deriving source in application globalization 

Application Language Derived From No NLS (Application not translated) Application Primary Language Browser (use browser language preference) Application Preference (use FSP_LANGUAGE_PREFERENCE) Item Preference (use item containing preference) Session 

• Define Application language
• Goto Application Shared Component
• Globalization
• Translate
• Define Application Languages

Note: APEX will use this new application id with respect to language selection

• Seed translatable text
• Go to shared components
• Globalization
• Translate
• Seed translatable text
• Select language checkbox
• Click on Publish 
• Again Select language checkbox
• Click on Seed 

• Download XLIFF translation files
• Go to shared components
• Globalization
• Translate
• Download XLIFF translation files
• XLIFF Export
• Selection language 
• Include XLIFF Target Elements: yes
• Export: As we wish

• Update XLIFF file target elements

Note: All the strings are taken from Google translator

• Apply XLIFF file to application
• Go to shared components
• Globalization
• Translate
• Apply XLIFF translation files
• Click on Upload files button
• Selection Updated XLIFF file and upload
• Select Uploaded file checkbox
• Map to the application from the column "Apply to Translation"
• Click on Apply Checked.
• Again Select Uploaded file checkbox
• Map to the application from the column "Apply to Translation"
• Click on Publish
• Now you are in "Seed and Publish" Screen.
• Selection language and click on Publish Button
• Again Selection language and click on Seed Button.
• All Set. hurray

Download Sample application

Additional Script

CREATE TABLE text_multi_lang
(
   id     NUMBER,
   text   VARCHAR2 (300)
);

SET DEFINE OFF;
Insert into APEX_19_2.TEXT_MULTI_LANG
   (ID, TEXT)
 Values
   (1, 'लॉगिन वाला पन्ना');
Insert into APEX_19_2.TEXT_MULTI_LANG
   (ID, TEXT)
 Values
   (2, 'पृष्ठ');
Insert into APEX_19_2.TEXT_MULTI_LANG
   (ID, TEXT)
 Values
   (3, 'घर');
COMMIT;

Migrations:

After migrating the application to any environment follow the below steps.

• Go to shared components
• Globalization
• Translate
• Publish translated applications
• Select the application to publish
• Click on Publish button
• Again Select application to seed
• Click on Seed button
• All Set.