Hi Pooja, I don't see this idea is related to FDI. Can you please post it on cloud customer connect which is more appropriate for fusion apps: Idea Lab – Receivables & Collections — Cloud Customer Connect And close this idea down. Thanks.

Hi, You can check about the dimension elements from MOS note which I mentioned in my post. For other one customer connect, create an account on customer connect and provide CSI of your customer and you should be able to access. Thanks.

Please check if below helps: How to join Cost Accounting Real Time and Inventory Transactions Real Time in OTBI reporting? — Cloud Customer Connect Check below MOS for more details on cross SA reports: Fusion Applications OTBI: Guidelines for creating cross subject area analyses in Oracle Transactional BI (Doc ID…

In your main select clause: add below: Pay_Run_Balances.Balance_Value num_of_hours ,(Pay_Run_Balances.Balance_Value/10) per_day_hours FROM ….. add a new line in from clause: , (select level lvl from dual connect by level <= (Pay_Run_Balances.Balance_Value/10) ) in where clause: and lvl <=…

Please check if below helps: SQL Query for Time Card Data and Absence Details — Cloud Customer Connect Thanks.

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?

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…