Oracle Fusion Cloud Technical Consultant -Business Intelligence & OTBI Reports

This course will introduce you to Oracle Transactional Business Intelligence – OTBI, and provide you with the necessary skills to understand business requirements using an actionable insights approach Intelligence & OTBI reports. This Oracle Business Intelligence course content is designed to expand your expertise in business data analysis. It also improves your potential and career choices with Oracle business intelligence certification

What you’ll learn

How to create user in oracle fusion application with base tables
how to run bi publisher report in oracle fusion Application by creating as ESS Job
bursting in bi publisher oracle fusion application
sub templates in bi publisher oracle fusion application
translations in bi publisher oracle fusion application
How to create bi report in oracle fusion application
How to create stylesheet in oracle fusion bi publisher reports
how to create Multi language report in oracle fusion bi publisher reports
how to create transaltions in oracle fusion bi publisher reports
RTF Tags -Split by Page break and for-each@section ,call-template other rtf tags in oracle fusion bi reports
subtemplate with parameters in oracle fusion bi reports
Dynamic PDF Secuirity or PDF Password in oracle fusion bi reports
AR Invoice Base tables in oracle fusion Receivables
Local variable XDO_USER_NAME
How to create Bi report in oracle Fusion from Scratch
Sub template with parameter in oracle fusion
dynamic logo based on business unit name in oracle fusion bi reports
Limiting Lines per page in Bi Publisher
Display Barcodes in Bi publisher or working woth barcodes in bi publisher reports

Course Content:

Introduction
Oracle Fusion application (SAAS) User Creation with base tables
Oracle Fusion BI publisher – First Report
Running The report From Catalog
Running The report From Fusion Application by creating ESS JOB
Report Layout Creation using Manual Method – 1
Report Layout Creation using Manual Method – 2
Report Layout Properties Explained – General
Report Layout Properties Explained – Caching
Report Layout Properties Explained – Formatting
Report Layout Properties Explained – Currency Forma
Style Sheet Template
Master Detail Report using Element Level link
Master Detail Report using Group Level link\
Master Detail Report using subgroups
Aggregate functions
Expression – Arithmetic Operation on columns
Expressions – IF (exp) With Example
Expressions – NOT with xdo user_report_locale
Expressions – AND Function
Expressions – OR Function
Expressions – MIN AND MAX Function
Expressions – ROUND , SUM Function
working with bind paramete
Bind Parameters with Independent and translated independent LOV
Bind Parameters with Table value set and $FLEX$ concept in Fusion
Multi Lingual Report with BI Publisher or translations
Multi Lingual Report with BI Publisher or translation’s -Testing
Oracle BI Publisher Bursting – Delivery Channel (EMAIL ,FAX ,SFTP , FTP ,PRINT )
Oracle BI Publisher Bursting – Delivery Channel (EMAIL ) -Testing
AR invoice report development from Scratch – SQL query development part1
AR invoice report development from Scratch – SQL query development part2
AR Invoice Report -for-each and master Details Report
AR Invoice Report -for-each@section and split-by-page-bre
AR Invoice Report – Repeating Header
Sub template with parameter or dynamic logo based on business unit name
Limiting Lines per page in RTF Logic
Limiting Lines per page in Bi Publisher with execution
Display Barcodes in Bi publisher with execution
Working With Excel templates (Simple and master detail and multi sheet)