What is BIP?
BI Publisher (BIP) is a reporting tool in Oracle Fusion used to create custom reports using SQL and templates (like PDF, Excel, RTF).
Step-by-Step Process:
- Login to Oracle Fusion Cloud
- Use your credentials to sign in.
- Make sure your user has the BI Administrator role.
- Click on Reports and Analytics.
- Navigate to ‘Browse Catalog’ to access existing reports and initiate the creation of new reports.
- Click on Create Button.
- Click on ‘Data Model’ to write the SQL query for retrieving data.
- Click on ‘New Data Set’.
- Select ‘SQL Query’ to write the SQL query within the Data Model.
- Enter the Data Model Name ‘AP_Invoice_Details’.
- Select the Data Source as ‘ApplicationDB_FSCM’.
- Choose the SQL Type as ‘Standard SQL’.
- Write the SQL query in the SQL Query section.
- Once the query is complete, click OK to proceed
- G_1 is the name of the Data Set.
- Click on ‘Data’ or ‘View Data’ to preview the data retrieved by the SQL query.
- Select the number of ‘Rows’ to fetch. You can select a maximum of 200 rows.
- Click on ‘View’ to see the retrieved data.
- There are two viewing options: ‘Tree View’ and ‘Table View’.
- Click on ‘Table View’ to display the data in a tabular format.
- There are two viewing options: ‘Tree View’ and ‘Table View’.
- Click on ‘Table View’ to display the data in a tabular format.
- In the Name section, enter the Data Model name ‘Invoice Details DM’.
- Then click the ‘OK’ button to save the Data Model.
- In the Name section, enter the Data Model name ‘AP_Invoice_Details’.
- Then click the ‘OK’ button to save the Data Model.
- The Data Model has been saved successfully.
- Click on the ‘Edit’ button to create and design the report layout.
- Click on ‘Data’.
- Click on ‘View’.
- Click on Save As Sample Data to Create Report.
Click on ‘OK’.
- Click on ‘Create Report’.
- Click on ‘Create Report’ to begin creating a new report.
- Select ‘Use Report Editor’ to design the report layout.
- Click on the ‘Finish’ button to proceed.
- In the ‘Name’ section,enter the report name ‘Invoice Details Report’, then click ‘OK’ to proceed
- There are two template options available:
- Option 1: Upload a custom template such as RTF, Excel, or E-Text etc.
- Option 2: Use the Standard Template provided by Oracle BI Publisher.
- Click on ‘Generate RTF layout based on selected Data Model’
- Enter Template Name ‘Invoice Details Report’.
- Click on ‘Generate’.
- The layout is displayed in the image above.
- Click on ‘View Report’ to preview the output based on the selected layout and data
- The layout is displayed in the image above.
- Click on ‘View Report’to preview the output based on the selected layout and data.
- Click on ‘View Report’Button.
- We have HTML, PDF, RTF, EXCEL, PowerPoint format output is available.
- Click on ‘Excel’ to Download this report.
OUTPUT:
