This is a long pending enhancement from Oracle. All selected attributes in a data model should be available for use while defining the remote file name. Thanks.

Are you not able to create two date parameters following the approach on below link? https://community.oracle.com/customerconnect/discussion/585077/how-to-embed-bip-report-in-otbi-dashboard-with-date-prompt-parameter

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.

I don't see a direct way of doing it. You can definitely call BIP reports from groovy with the approach given in below note: How To Call BIP Report Webservice From App Composer using Groovy Script (Doc ID 2150332.1) Can you try similar approach for OTBI with webservices mentioned in below notes: How to include date filter…

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.