Oracle Fusion Report Development | BI Publisher Report in Oracle Fusion

Development of Custom BI Publisher Report in Oracle Fusion Cloud Applications

There Are Two simple Steps to develop Custom BI Publisher report in Oracle Fusion Cloud Applications

Creation of  Data Model

Navigator > Reports and Analytics 

Click on Browse Catalog  

Page will be redirected to Business Intelligence Home Page 

Click on New Icon which is available on left side of BI home Page

click New Data Set – SQL Query

Enter details
Name : Can give as per your Naming Standards
Data Source : This can be selected based fusion DB Schema which we would like to access
Note :
ApplicationDB_FSCM ( Financial and Supply Chain Management )
ApplicationDB_HCM ( Human Capital Management )
ApplicationDB_CRM ( Customer Relationship Management )
Type of SQL: This is can based on Type of SQL which using for report
Standard SQL :Standard SQL used for normal SELECT statements interpreted to understand database schema
Procedure Call : query type to call a database procedure
To use REF cursor in Oracle BI Publisher :
Use this query type to issue SQL statements that can include the following:
Cursor statements that return nested results sets
Functions returning REF cursors
To use REF cursor in Oracle BI Publisher

In SQL Query Section we can provide Query If readily available . Otherwise can use Query Builder to Build Query for report

Click Ok. Then Save Data Model

Enter Details of Data Model

Click on Data  Tab to save sample data

Report Creation

Click on Create Report Which is available in BI Home Page

Default Data Model will selected Click On Next

Select
Page Options : Portrait 
Layout : Table 
Click next 

Drag Fields from Data Source > Click Next 

Click on Finnish to Save report and View Output 

We can report output in Interactive Dash Board 

To View or Download output in different format. Click on View report icon which is available in extreme right corner .

Report Is Created