Creating an OTBI Report - OracleFusion

 OTBI stands for Oracle Transactional Business Intelligence. OTBI Reports are very useful to users who don't have knowledge on coding since it involves drag and drop functionality.

We can easily place filters and switch between different types of report outputs like Tables, Graphs and much more...

Let us create an OTBI Report..

Open Reports and Analytics Page, go to New and select Analysis


Select required Subject Area. Subject Area contains data specific to a business object 

For example, let us take Payables

After Selecting Subject Area, the following page appears

In the above page, we have columns related to that business objects organised in terms of respective folders. Expand the folder and start drag the required columns into Selected Column Pane




After Dragging all the required columns, we can see data in Results tab


Query to fetch COA Account Fields

 Hi All, A short post to get COA Account Segment related fields. select  fvvv.value, FVVV.DESCRIPTION, fvvv.ENABLED_FLAG  Enabled, fvvv.STAR...