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 

BIP Reports in Oracle Fusion: Step by Step to Create BIP reports and Register in Oracle Fusion

BIP Reports in Oracle Fusion: Step by Step to Create BIP reports and Register in Oracle Fusion

Hi Friends , In this Post , We will discuss Oracle Fusion BIP Reports. I will show you step by step process for how to create an BIP report and how we can run the BIP report in Oracle cloud.

Before starting this post if you have not go through my last post for BIP reports then please go through it. Its recommended to go through that before starting creation BIP reports.

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

Step by Step to create the BIP 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

 To Learn OAF Online , You can refer this Complete step by step OAF Tutorial

 Oracle Fusion BIP Reports