Oracle Application's Blog: creating BIP reports in Oracle Fusion

Hi Friends , In this post I am going to share you the second post of BIP report Creation and Register as ESS job in Oracle Fusion. I will show the complete steps to create BIP Report and Register in Fusion as ESS Job.

Before starting this post please go through the first post of BIP report creation so that you will be better understand this second post/part of BIP

BIP Report Creation Part-1 Url:-

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

In the Last post Part-1 we have completed steps till LOV creation for BIP reports parameter.

Now I am going to share the next steps:-

Step13:- Now we will attach LOV to Report Parameter as below.

Chose Parameter Type = Menu

Select List of Value as below from Drop Down List.

Step14:-

Step15:- Our Parameter has been created and LOV is also attached. Now in this step we will put Parameter in Report SQL query.

Click on the Group G1 and then Click Edit Data Set.

Part 2 Create BIP reports and Register in Oracle Fusion as ESS Job

Step 16:-

Step 17:- Now we will run this Report click on the Data Tab and Select Vendor Parameter.

Step18:-

Step 19:- Now we will export the sample data in Our system Desktop to design RTF template.

Step 20 :- Data is Exported as below:-

Step 21:- Now click on Create report to Design your BIP report.

Step 22:- If you want to create your own RTF template for this report then click on Use Report Editor and then Finish.

Step23:- This is the Template We have Created for this BIP report.

Step 24:- Our RTF template has been created now we have to upload RTF template for This report.

click on Upload as below and then select the template as below.

Step 25:- You can manage Parameters in this option like display or not and sequence of it.

Step 26:- click on Properties as below and you can set further properties for the report as below.

Step 27:- Copy the Location of your BIP report and put it in Notepad. This location will be used when you will be create ESS job for this report in Oracle Fusion so that you can run this report in Oracle Cloud.

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 and Last post for BIP Report Creation and Register In Fusion. In the last post we will register this BIP report 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

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

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