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 !

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.

Also, HRC_LOADER_ESS_STATE is a lookup not table.

You need to join fnd_lookup_Values.lookup_Code with ESS_REQUEST_HISTORY.state.

Meaning from fnd_lookup_Values contains the status. You can put a filter on this table:

flv.language = 'FR'

or any other language to get the meaning translated in the language.

Hope this helps.

Thanks.

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/62073#Comment_62073

Below MOS note confirms that the job names are not stored in backend tables (In case you need a reference to official documentation):

What are the Tables Where the ESS Jobs and Custom Job Sets are Stored? (Doc ID 2430380.1)

And you can evaluate the below idea and upvote:

Required ESS Schedule Process Job Name — Cloud Customer Connect

Thanks.

Sreekanth M, Oracle-Oracle

Hi Mandeep,

Thanks for your inputs. I will check through this and get back to you.

Thanks,

Sreekanth M