REPORTS IN
ORACLE FUSION
CONTENTS
•INTRODUCTION
•FUSION REPORTS
•TYPES OF FUSION REPORTS
•BI PUBLISHER (BIP) REPORTS
•MULTIPLE WAYS TO CREATE BIP
REPORTS
•REGISTERING REPORT
INTRODUCTION
• Oracle Fusion is a comprehensive suite of cloud-based enterprise
applications designed to streamline various business operations
like finance, human resources, supply chain management,
customer relationship management, and more.
• Oracle Fusion Applications offer a comprehensive set of reporting
tools designed to meet diverse business needs, from operational
data analysis to strategic decision-making.
FUSION REPORTS
A report is a structured presentation of data extracted from
various sources within the Oracle Fusion Applications.
Reports transform raw data into meaningful insights, helping
businesses monitor performance, make informed decisions,
and ensure compliance with regulatory requirements.
These reports can be financial, operational, or analytical, and
they can be formatted to meet various business or regulatory
requirements.
PURPOSE
• Reporting in Oracle Fusion is crucial for transforming raw data
into actionable insights, enabling organizations to make
informed decisions, optimize processes, and maintain
compliance with regulatory requirements.
BENEFITS
1
• Real-Time Data Access
• Integrated Reporting Tools
• Customizable Reports
TYPES OF FUSION REPORTS
BI Publisher: For creating highly formatted, pixel-
perfect reports.
OTBI (Oracle Transactional Business Intelligence): Ad-
hoc reporting for real-time analytics.
FRS (Financial Reporting Studio): Specialized for
financial reports and analytics.
Smart View: Integration with Excel for advanced data
analysis.
Essbase: For multidimensional data analysis.
BIP REPORTS
• BI Publisher (BIP), originally known as XML Publisher, is a
reporting tool provided by Oracle that allows users to create,
manage, and deliver highly formatted reports from various
data sources.
• It is part of the Oracle Fusion Applications suite and is widely
used for generating documents like invoices, purchase orders,
financial statements, and more.
BIP REPORTS Cont.,
BENEFITS:
Highly Formatted Reports
Multiple Data Source Integration
Template-Based Reporting
Ease of Distribution
Scalability
Integration with Other Oracle Fusion Modules
MULTIPLE WAYS TO CREATE BIP
REPORTS
Using Oracle Standard Wizard
Using AutoGenerated RTF
Manual Template.
RTF
Excel
CSV
eText
USING ORACLE STANDARD WIZARD
Click Tools
LOG IN
By using User Id and
Password
Select Report &
Analytics
Browse Click that icon to
Catalog create new folder
Created
Folder
Click create Click “+” icon
to create New Select SQL Query
DM
Select
DataModel
Enter the name and
select the Data Source
like FSCM
Enter the Query
Once click ok then Click View to view
display the fields in the data
Select table view
table
For creating Report - Need to
save sample data
Save Data
Model
Once saved Data
Model then Click
Create Report
Select Layout
Select the Data
Model
CLICK NEXT
Choose fields based on user requirements
Save Report
CLICK NEXT
Once saved the report
then output will be Need Reports in different
display format then click this icon
to show various formats
Excel
output
BY USING AUTOGENERATED RTF : Cancel the Wizard
Click create
Select report
Select the DataModel to
generate RTF
Define the template
name
Click Generate to generate
RTF
Click view a list
to change the
output format
Once defined the
format after save
it
Save the Report Once saved and click view report
output
BY USING MANUAL TEMPLATE Save as .xml
format
RTF TEMPLATE
Click export to get the
XML data
Saved xml can be
imported to word
through BI publisher
Click table and
select the fields Group by vendor_id
to create table
CLICK NEXT
C
LI
Generated RTF and C
save as .rtf K
extension
Click finish to
generate RTF
Select Data Model
Create
Report
Click upload to upload
the template
Define the layout Choose the
name Click view a list
template file
Select the
type of
template
Once
entered
click upload
output
Select the
output format
Same process
like rtf import Select type
EXCEL TEMPLATE: the xml and the of template
template can be as excel
saved as .xlsx template
View a list
Once saved the
Report and click
view report
Open the word
CSV TEMPLATE Save the file
as .rtf(without
Type of
any contents)
template as RTF
Select
the
default
format as
CSV
View a list
Enable CSV in output
formats
Output
REGISTERING REPORT
Once the report is developed, then it can be register as an Click Task
icon
ESS(Enterprise Scheduler Services).
Go Home and click User
And select Setup and Maintenace
Select Global
Search
Query the Manage
Enterprise scheduler for Click “+” icon to
FSCM create new job
Select the report
and click more to
select history
Enter the
details Copy the
Report path
Goto Home Tools Scheduled
Processes Click Schedule New
Process
Click submit
Query the Job name
and click OK
Process will
succeeded
Click republish to
view the data
OUTPUT:
T H A N K YO U
