Learn to create a simple report in oracle cloud
In this article, we provide a detailed guide on how to create OTBI reports in Oracle Cloud, with step-by-step instructions. However, sometimes you may only need to quickly extract data from application for analysis. For example, you might want to extract a list of employees from a particular legal employer with their current absence plan balance, or retrieve data from a user-defined table. While you may have a SQL query ready to extract the data you need, the problem is that using Data Model (or for simple understanding you can also say SQL Query), you can only extract a maximum of 200 rows.
To help you overcome this limitation, we will outline the steps to create a simple report that can extract more than 200 rows.
Get SQL query to fetch required data
To complete this exercise you will need a SQL query that will fetch some data from the application, if you already have one that is great, if not, you can head over to this post » Oracle Fusion (Cloud) Reusable SQL Queries and copy sql query shared to get Employees Absence Plan Balance.
Subscribe Now to Unlock Premium Content!
Choose a plan that fits your needs and stay ahead in your career with our expertly curated premium content.
