That was just an example. Instead of below: '80' num_of_hours, to_number('80')/to_number('10') per_day_hours Use your actual table.column names. If you are not able to replicate, share the table name and column name, I can try to write it for you. Thanks.

Also, duplicate of below post: What are the database Tables for Opt in Features in Oracle Fusion Cloud? — Oracle Analytics Can you please close one? Thanks.

You can get these details in ASM_FILTER_OPTIONS_FILTERS table. Please check below MOS note for other related tables: What are the tables or views related to Offerings And Opt In Features ? (Doc ID 2666170.1) Thanks.

You can write something like below: select papf.person_number ,'80' num_of_hours, to_number('80')/to_number('10') per_day_hours from per_all_people_f papf, (select level lvl from dual connect by level <= to_number('80')/to_number('10') ) where trunc(sysdate) between papf.effective_start_date and papf.effective_end_date and…

Can you please elaborate your query a bit more? What are you trying to build is it an OTBI or a BIP or in FDI? Thanks.

This will be a great enhancement to the product. We often face scenario's where usage of an attribute change over time (or the attribute is not required) anymore. In such scenario's we manually have to dig each report to find if the particular attribute is being used or not. Upvoted !!!

If you are trying to display the status of individual bursting details, then that is not possible to get. There is an idea submitted for same. Please evaluate and upvote: Expose Table for Bursting Output Results — Oracle Analytics Thanks.

There is already an idea submitted for same. Please review the existing and upvote there and close this idea. Increase the count of maximum rows from data model query — Cloud Customer Connect Thanks.

I can see a similar idea already submitted on cloud customer connect many years back having more than 70+ votes. It will be good to consolidate the idea at a single location and use all the votes there. Required ESS Schedule Process Job Name — Cloud Customer Connect Please review the below idea and upvote if you feel that…

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…

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…

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.