nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

How to translate the data in a BIP Report to another language?

Sreekanth M, Oracle-Oracle

We have created a BIP Report where English(en-US) is the default language. We want the data as well of the BIP Report to be translated to another language(Specifically SPANISH). One method that we have tried is by Exporting Translation from the Properties(XLIFF File) and importing it back. But the thing that we have noticed there is only the columns are getting translated when the user logging in using Spanish language. The Report majorly contains the data from ESS_REQUEST_HISTORY tables ie, to monitor the Scheduled ESS Jobs of Fusion.

Please let me know if there are any other steps that I should try for the data translation in BIP.

Thanks in Advance !

Find more posts tagged with

BIP

OTBI

Fusion ERP Analytics

Accepted answers

All comments

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/24083/how-to-translate-the-data-in-a-bip-report-to-another-language

Not all the data is translated in fusion HCM. Only the base tables having a name ending with _TL contains translated data. So, what this essentially means is not all the objects are translatable.

Thanks.

Sreekanth M, Oracle-Oracle

Ok .. Thanks Mandeep. Actually we want to translate the Data in ESS Tables. Do you know if there are any _TL table to get the ESS History ?

If yes please do share.

Thanks,

Sreekanth M

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/61883#Comment_61883

What translated information exactly you need from history table? Is it the job name?

Thanks.

Sreekanth M, Oracle-Oracle

Hi Mandeep,

Basically all information that we see in English should be translated. Those are basically 'Job Name' , 'Error Message(If any), 'Status' etc.

Thanks,

Sreekanth M

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/61898#Comment_61898

You can't get all these things translated. Status comes from a lookup named HRC_LOADER_ESS_STATE and in this lookup, you can get translated values for status.

Thanks.

Sreekanth M, Oracle-Oracle

Ok Thanks Mandeep.

So similarly is there a way to get the Job Names and Error Message translated ? If yes please please do share the table name.

And also about the 'HRC_LOADER_ESS_STATE' table , is this supported for translation ?

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/62033#Comment_62033

Hi Sreekanth,

I have checked and I couldn't find anything related to translation of job names data.

If you notice any ESS job definition, there are no translation option available:

in whatever language you create the job, you will get the same result from your query.

Also, as per my knowledge, it is not possible to get the job name from backend tables as this data is stored in metadata not in direct tables. You can get the job definition only which is stored in ESS_REQUEST_HISTORY and is non translatable.