How to Create Multi Language BIP report in Oracle Cloud : BIP report template translation in Oracle Cloud

How to Create Multi Language BIP report in Oracle Cloud : BIP report template translation in Oracle Cloud

In this post , We will discuss about multi language report in oracle fusion. If we want to generate the report output in multiple languages then we can use the translation feature of the Oracle Cloud BIP reports. Translation feature helps to generate the report output in multi language. Here below I will share the detail steps to create multi language BIP report in Oracle Cloud.

 

 

Step by step to create the Multi Language BIP report in Oracle Cloud

RTF and BI Publisher (.xpt) templates can be translated from the Properties page. To access the Properties page, click the Properties link for the layout in the Report Editor..

Figure 14-2 Accessing the Properties Page

From the Properties page you can generate an XLIFF file for a single template. Click Extract Translation to generate the XLIFF file.


 BI Publisher extracts the translatable strings from the template and exports them to an XLIFF (.xlf file).

 

After Click on the Extract Translation , system will generate the XLIFF file for the template.

We need to make the changes in this XLIFF file to generate the output in other language.

 

When you have downloaded the XLIFF file, it can be sent to a translation provider, or using a text editor, you can enter the translation for each string.

 

A "translatable string" is any text in the template that is intended for display in the published report, such as table headers and field labels. Text supplied at runtime from the data is not translatable, nor is any text that you supply in the Microsoft Word form fields.

You can translate the template XLIFF file into as many languages as desired and then associate these translations to the original template.

 Once you have made the changes in the XLIFF file , then we need to upload that change XLIFF file again back to the template.

 

If you want to learn , how we can make the changes in the XLIFF file , please follow my another post regarding What is XLIFF file : Working with XLIFF file.

 

To upload the translated XLIFF file:

 

1. Navigate to the report, sub template, or style template in the catalog and click Edit to open it for editing.
   For reports only:
   From the thumbnail view of the report layouts, click the Properties link of the layout to open the Template Manager.
2. In the Translations region, click the Upload toolbar button.
3. In the Upload Translation File dialog, locate the file in the local directory and select the Locale for this translation.
4. Click OK to upload the file and view it in the Translations table.