
Explore Oracle fusion, cloud and SaaS reporting tools, access course materials and code in the GitHub repository, learn Oracle SOA Suite basics, and participate in Q&A for support.
Learn how Oracle BI Publisher integrates with Fusion Cloud to create parameterized reports and dashboards, manage roles and privileges for reports and analytics, and export outputs via various options.
Create a master-detail bi report using subgroup by modeling a data source with header and line groups linked by the primary key, then build and format the report.
Learn how to implement bursting in the VIP reporting tool by adding a bursting query to the data model, scheduling the report, and delivering the PDF attachment via email.
Learn to use XSLT and XPath in BI Publisher to transform Excel data into target documents, using templates, namespaces, value-of, for-each, and choose logic.
Learn how to work with enterprise scheduler service (ess) jobs in fusion cloud: define, submit, parameterize, secure, and monitor jobs, and review logs and csv or xml outputs.
Learn to create a custom enterprise scheduler job for a BI report in Oracle Fusion, define the job path and parameters, submit, and verify the output as a pdf.
Create a fusion cloud lookup for invoice sources, attach it as a list of values source for the invoice source parameter, and schedule the process to run.
Automate Fusion report invocation and data extraction by building an Oracle SOA Suite composite that calls the Fusion report service, decodes base64 output to PDF, and writes it to disk.
Create a BI report using OTBI analysis by building an analysis, extracting its SQL, and modeling data with a parameter-driven dataset to generate a payables invoice report.
Log into financial reporting studio to add a total amount column with a custom formula and insert a textbox graph and a line chart with a chart title.
What's this course about?
Learn Oracle Cloud Fusion ERP Technical - BI, OTBI, BICC, FRS, SmartView and dive deeper into it. Understand the Reporting tools and solutions of Oracle Fusion ERP Cloud. To be precise the reporting capabilities being provided by Oracle in Fusion Cloud SaaS.
What do you expect end of this course?
By the end of the course, you will be equipped with all the knowledge of Reporting tools and solutions of Oracle Fusion ERP Cloud e.g. BI Publisher, OTBI, BICC, FRS, Smart View ! And you will be ready for your next assignment! :-)
A detailed list with the course content can be found below.
Who's teaching you in this course?
My name is Raja Dutta and I have my partner Leena, We are both Fusion Cloud, PaaS and Fusion Middlware Consultant and we are passionate about helping more people to learn Fusion Cloud Technologies. After huge postive feedbacks we are here at Udemy with our second course of Oracle Fusion Technical - BI, OTBI, BICC, FRS, SmartView and we had lot of fun in preparing this course! Hope you too will have fun learning this course!
It's our goal to get you started with Oracle Fusion Technical - BI, OTBI, BICC, FRS, SmartView as soon as possible and ensure your success. I want everyone to get benefited out of this course and to us, helping others is the best way of learning. So Let's Learn together!
Is this course for you?
This course is for you if ...
.. you want to upskill with Reports and Analytics in Oracle Fusion ERP Cloud
.. you want to pursue your career with Oracle Fusion BI & Analytics
.. you have idea on ERP and Package solutions
What's inside the course?
BI Publisher
- BI Roles & Configuration
- Develop First BI Report
- BIP Report with Parameters
- Export BIP Report Output
- BI Report Migration
- Master Details BI Report
- BIP Bursting & Delivery Channel
- Secure BI Report
BI - Yeh Dil Maange More
- BI Report using Excel Template
- Print Barcode in BI Report Output
- Secure your PDF Report Output - Static Method
- Secure your PDF Report Output - Dynamic Method
- SubTemplates in Fusion BI
- Explore different features of RTF Template
- Fixed Position flat file using BI Report
- Generate BI Report Output in Multi-Languages - Part1
- Generate BI Report Output in Multi-Languages - Part2
- Customize Standard BI Report
BI - All about RTF Templates
- Auto Generate RTF Templates
BI - Schedule BI Reports
- FTP Delivery Channel Configuration
- Schedule BI Report From Fusion & Burst Report Output to FTP Server
- Prepare SOAP Payload to schedule BI Report using SOAP UI
- Schedule BI Report through SOAP Web Service using PLSQL
BI ESS Jobs
- Getting Started with Enterprise Scheduler Services (ESS) Jobs
- Creating first ESS Job on BI Report
- Lookups in Fusion - Use in ESS Jobs Parameter
- ValueSets in Fusion - Use in ESS Jobs Parameter
- Secure your BI ESS Job
BI Outbound Integration Tool
- All about Report Service
- Fetch Data from Fusion using BI & Java
- Fetch Data from Fusion using BI & SOA
Oracle Transactional Business Intelligence (OTBI)
- Getting Started with OTBI
- OTBI Analysis - Tabular Representation
- OTBI Analysis - Graphical Representation
- Create Dashboard using OTBI
- Create Drill Down Report using OTBI
- Create BI Report using OTBI Analysis
- All about OTBI Report Security
- Create Infolet using OTBI Analysis
BI Cloud Connector (BICC)
- BICC – What is this??
- Get Ready with BICC
- Create your first BICC Extract(Full)
- Run for Incremental Extracts
- Secure your BICC Extract
Financial Reporting Studio (FRS)
- Getting started with FRS
- Build Report using FRS
Smart View
- Getting started with Smart View
- Build Report using Smart View
Export BI Report Output to DB/FTP using OIC (Bonus)
- Export BI Report Output to DB using OIC
- Export BI Report Output to FTP using OIC