In this article we will look into how to translate the BI Output in languages other than English.
This is a guest post by Vivek Omar who is an Oracle HCM Cloud Lead with vast experience on the HCM Technical and Functional modules.
If the implementation spans multiple countries, then getting the output of the reports in their local language is the most common requirement. Ex Chinese/ Japanese/ French/ Spanish, etc.
The first step would be to Prepare the data model and Template (RTF) in the base language (English –US) and it would generate the output in the English language.
Next, Load sample XML file from data model to RTF template and download xliff file from it using the Translation
The other way is to download the translation file from the BI Report properties.
The xliff file (.xlf) when opened will look like below:
We need to change the target language value as per our requirement in the xliff file. For French it would be FR, for Spanish, it would be es, etc.
We need to provide actual translation of the wordings that are present in xliff file to the target language. We need to use google translate or any other tool to get the translation text for the target.
After modification of xliff file we need to go to Report > Edit and click on Properties where template is present. You need to upload modified xliff file to LOCALE Option.
In the bursting query, we need to fetch Locale from SQL as their preferred language. Use the below query.
(select (select username from per_users where user_guid = level_value) username ,profile_option_value from fnd_profile_option_values where profile_option_id in ( select profile_option_id from fnd_profile_options_vl where profile_option_name like 'FND_LANGUAGE' ))Translation_Rec
We can join this query in the from clause and join with papf.person_number
Translation_Rec.username = papf.person_number
The above query will pull the default language setup for the user from user preferences. So, the users with English will be able to see the output in English Language and the users with the French language will be able to see the output in the French language.
Thank you Vivek Omar for contributing to Fusion HCM Knowledgebase. If anyone else is interested in sharing the content, please reach out to us using the contact/chat options.If you like the content, please follow us on LinkedIn, Facebook, and Twitter to get updated with the latest content.
Top 10 Popular Posts from our Knowledgebase
- DataFusing FREE Cloud based SQL Developer like tool for Oracle Cloud
- Core HR Entity Relationship Diagram (ERD) for HCM Cloud
- Most Frequently used Document IDs from Oracle Support
- FREE Oracle Training & Accreditation with Oracle Learning Explorer
- How HDL Transformation Formula works with ElementEntry Sample
- FREE Oracle Fusion Demo Instance (VISION) Access
- Top 10 FREE useful tools for Fusion Consultants
- Learning Fusion HCM Technical Skillset
- Sample HCM Data Loader (HDL) files for all Business Objects
- Most frequently used Tables list in Fusion HCM