Hi Sambhav, This is currently not supported. OTBI pulls data based on your language preference set. So, displaying the data in multiple languages at same time is not supported. Thanks.

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

This is a long pending enhancement. We should be able to report the data created from UI. I understand this might be a major revamp as this data is stored as metadata. So, any solution - webservices rather than direct table access will also be helpful. Thanks.

Is it possible to share the navigation from application and a screen shot showing data in UI? You can mask the sensitive data in your screen shot. Thanks.

That's right. Thanks.

Please check sample given on below support note to convert it as per User preferences: How To Set Date As Per User Preference Time zone in Fusion Applications BI Publisher Report (Doc ID 2864734.1) Thanks.

The dates by default are shown in date timestamp format as stored in DB. If you need any particular format, you need to define that in your BI data model query. Thanks.

I am able to find it under Calculation Component Details: In your original post, you mention about PAYE scheme reference attribute. Thanks.

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.

Can you please share navigation and screen shot pls? Thanks.

Thank you for sharing it with the community !!!

Hi Babs, You can try connecting using PAY_ELE_CLASSIFICATIONS_TL.CLASSIFICATION_ID. Thanks.

Hi Babs, In Oracle, we have element classification - Earnings/Deductions (Voluntary/Involuntary)/Information etc. Gross Pay/Basic Pay are both elements of type classification Earnings. For salaries calculation, the Payroll engine works a lot behind the scenes using fast formulas, element types and other factors as well. If…

This will be a great enhancement. Simple export to PPT output will not be a workable solution in all the cases. Formatting is definitely needed to present data.

Thanks for sharing the details but can you share the value of "FK" from Q1. Also, can't you select legal_entity_id as an attribute in Q1 and Q2 and do a direct join? Thanks.

can you share sample data for both? hou.name || rcta.attribute15 and inv.organization_code AS CODIGO_FILIAL, xl.registration_number AS CNPJ_FILIAL, inv.organization_name AS NOME_FILIAL Also, can you link from q1 to q2 instead from q2 to q1. Thanks.

My apologies. I still didnt understand. You get the legal entity id from your Q1 but when you link it to legal_entity_id from Q2 (XLE_ENTITY_PROFILES), you don't get any data? Thanks.

You can bookmark the below link and always get the latest file: R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet — Cloud Customer Connect Thanks.

You mean legal_entity_id is blank in ra_customer_trx_all ? Thanks.

Below post should be helpful as well: How to embed BIP report in OTBI dashboard with Date Prompt/parameter? — Cloud Customer Connect Thanks.