How XLIFF Streamlines Multilingual ERP Reports
A major advantage of BI Publisher’s translation approach is its separation of report logic from language rendition. Instead of duplicating report layouts for every language, Oracle Cloud ERP lets you keep one template and associate it with multiple XLIFF translation files, each mapping a language’s localised strings. This ensures easier maintenance, since report logic and structure are updated only once.
01.
Prepare Your Report Layout
Use BI Publisher’s Template Builder in Microsoft Word to design your report (RTF format). All data and prompt headings should be clearly separated from dynamic data.
02.
Extract Text for Translation
Extract your Translation using the Template Builder toolbar, go to Tools > Translation > Extract Text or by downloading it from the report template you have uploaded into the application. Edit > Properties > Translations > Extract Translation. This generates an XLIFF file type from the selected Base Template file containing all strings intended for translation.
03.
Translate Using XLIFF
Edit the XLIFF file using your chsen text or XML editor. Each source string gets a corresponding target string for the translation.
Save the XLIFF translated files following Oracle’s conventions, like
TemplateName_<language code>.xlf(for example,Invoice_nl.xlffor Dutch).
As you will see, the base report is written in English (en-US), whilst the translations will be written in Dutch (nl).
<?xml version = '1.0' encoding = 'UTF-8'?>
<xliff version="1.0">
<file source-language="en-US" target-language="nl" datatype="biprtf" original="n/a" product-version="12.2.6.1.15" product-name="Oracle BI Publisher">
...
</file>
</xliff>
As you will see the, “Receipt Number” will use the translated heading “Ontvangstnummer”, when the report is run by a user whose report local is NL.
<trans-unit id="75471a71">
<source>Receipt Number</source>
<target>Ontvangstnummer</target>
<note>Text located: body/table/table header</note>
</trans-unit>
04.
Upload Translated Files
Upload the XLIFF File to your report template. Edit > Properties > Translations > Upload. This uploades and associated the XLIFF translation file to the report.
04.
Test Your Translations
Adjust user preferences, such as Report Locale, to view or schedule reports in different languages and confirm proper everything renders as expected.
Need some assistance?
Ready to bring clarity to customer, supplier and employee communications? With BI Publisher, we specialise in customising customer, supplier, and employee-facing documents such as invoices, purchase orders, payslips, and statements to meet your exact branding, compliance, and operational needs. From layout design to data logic enhancements, we help you deliver clear, consistent, and impactful outputs across your organization. Contact us today to discover how our expertise in BI Publisher can streamline your document processes and elevate your business communications.
