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)

Who this course is for:

Oracle apps Technical or Oracle fusion techincal consultants or oracle fusion Functional – FINANCE ,SCM ,HCMA

Oracle Job Interview Preparation

International Student Fee: 1000$

Job Interview Preparation (Soft Skills Questions & Answers)

🎥 Your FRE eLEARNING Courses (Click Here)

Internships, Freelance and Full-Time Work opportunities

Oracle Fusion Technical – Procure to Pay Cycle complete flow

Oracle Techno Functional Consultant – Oracle ERP Apps

Oracle HCM – HRMS Career and Succession

Fusion Cloud ERP Training – Oracle Fusion Cloud General Ledger Fundamentals

Oracle Hyperion Planning – Implementation Installation & Configuration

KEY FEATURES

Flexible Classes Schedule

[bsf-info-box icon=”linear-checkmark-circle” icon_size=”32″ icon_color=”#b3b3b3″ title=”Online Classes for out of city / country