How to create report in oracle fusion : BIP Report in Oracle Fusion

How to create report in oracle fusion : BIP Report in Oracle Fusion

In this post , We will discuss about How to create report in oracle fusion. Oracle fusion has given some different tools to create the reports in the oracle applications. Here we cannot use the Oracle apps r12 tools. In Oracle fusion we have BIP & OTBI reports tool to create the Repots in Oracle Fusion. In this post , I will share the complete steps for How to create report in oracle fusion.

 

Step 1:- Login to Oracle Fusion and go to Menu Navigator as below and Click on Reports and Analysis option.

Step2:-

Step3:- Click on + sign and Data set will be open as below
Give the name of Data Set:= XX_INVOICE_DETAILS
Data Source:= ApplicaionDB_FSCM

 

Step3:- Again Click on + sign and Data set will be open as below
Give the name of Data Set:= XX_SUPPLIER_SITES
Data Source:= ApplicaionDB_FSCM

 

 

 

 



Step 5:- Now these two data sets has been created and now we will join these two group by data link so Click on Vendor_id column and select Create Link

Step 5:- we will join these two group by data link so Click on Vendor_id column

 

 

Step 7:- Now Save the Data model as below in right folder under Invoices Folder.

 

 

 

 

Step 8:- Now we will Create Parameters. I am going to create Vendor Name parameter for this  as below.

 

 

Step 10:-

 

Step 11:-

 

Now we will create Value set and attach this Value set to Parameters.

 

 

 

Step 12:- LOV Creation as below.

 

 

 

Hi Friends due to the length of this topic I will split these topic three parts , I have split this topic in three parts. Please follow the next post for rest of the steps.

Part 2 Url:-

http://rpforacle.blogspot.com/2018/01/oracle-fusion-bip-reports-step-by-step-process-to-create-bip-report-and-register-in-oracle-fusion.html