Oracle Fusion Techno Functional Master Class

Oracle Fusion Techno Functional Consultant – Complete Training (Security, BI, OIC, HCM & Financials)

What you'll learn

Understand Oracle Fusion technical architecture and core concepts.

Configure and manage Oracle Fusion Security Model effectively.

Build and customize BI Publisher reports with data models and layouts.

Develop advanced BI Publisher templates, bursting, and scheduling.

Design OTBI analyses and dashboards for real-time reporting needs.

Perform journal import processes and troubleshoot common issues.

Create and manage Data Access Sets in General Ledger.

Upload customers and automate AR Auto Invoice creation.

Work with HCM data loader and create employees via Worker.dat.

Use SOAP Web Services to extend and integrate Oracle Financials.

Develop integrations in Oracle Integration Cloud (OIC) step by step.

Import invoices into Oracle Fusion using FBDI with OIC.

Implement lookups, mappings, and transformations in OIC.

Call database packages and validate files from OIC integrations.

Automate AR invoice creation through OIC and DBCS integrations.

Work with OIC REST APIs for advanced integration scenarios.

Use Page Composer and Sandbox to personalize and extend Fusion apps.

Display and configure new pages on Oracle Fusion springboard.

Encrypt files and secure integrations using PGP keys.

Explore Hyperion Financial Reporting Studio for advanced reporting.

Requirements

Basic understanding of ERP concepts (Financials or HCM).

Familiarity with SQL and PL/SQL will be helpful but not mandatory.

No prior experience in Oracle Fusion required; beginners welcome.

Access to Oracle Fusion Cloud (trial or corporate) recommended.

Description

This course is designed for anyone who wants to build a strong career as an Oracle Fusion Technical Consultant. Whether you are a beginner exploring Oracle Cloud applications or an experienced professional looking to expand your technical skills, this course provides a complete, step-by-step guide to mastering Fusion technical concepts.You will start by understanding the Fusion Security Model, learning how roles, privileges, and data access are controlled. Then, you will dive into BI Publisher and OTBI reporting, where you will build data models, layouts, dashboards, and advanced templates to deliver powerful reports for business users.The course also covers Workflow and Approval Notifications, along with hands-on tutorials in Financials (GL, AR) and HCM (Data Loader, Worker.dat), giving you real-world exposure to critical business processes.You will then move into Web Services and Integrations, exploring SOAP and REST APIs for Oracle Financials, followed by a complete Oracle Integration Cloud (OIC) series. This includes lookups, mappings, FBDI import, database package calls, AR invoice creation, and REST API-based advanced integrations.Finally, you will learn Page Composer and UI personalization, file encryption with PGP Keys, and Hyperion Financial Reporting Studio for advanced reporting.By the end of this course, you will have the knowledge and confidence to implement, customize, and integrate Oracle Fusion applications, making you job-ready as a Fusion Technical Consultant.

Overview

Section 1: Introduction & Security Model

Lecture 1 Introduction to Oracle Fusion Technical Consulting

Lecture 2 Oracle Fusion Security Model – Fundamentals (Part 1)

Lecture 3 Oracle Fusion Security Model – Roles & Privileges (Part 2)

Lecture 4 Oracle Fusion Security Model – Advanced Concepts (Part 3)

Section 2: BI Publisher Reporting

Lecture 5 BI Publisher in Oracle Fusion – Getting Started (Part 1)

Lecture 6 BI Publisher – Creating Data Models (Part 2)

Lecture 7 BI Publisher – Layouts & Templates (Part 3)

Lecture 8 BI Publisher – Parameters & Bursting (Part 4)

Lecture 9 BI Publisher – Scheduling Reports (Part 5)

Lecture 10 BI Publisher – ESS Job , Job Definition & All (Part 6)

Lecture 11 BI Publisher – Custom Templates (Part 7)

Section 3: Workflow & Approvals

Lecture 12 Workflow Approval Notifications – Overview (Part 1)

Section 4: OTBI (Oracle Transactional BI)

Lecture 13 OTBI – Basics and Navigation (Part 1)

Lecture 14 OTBI – Building Analyses (Part 2)

Lecture 15 OTBI – Dashboards and Prompts (Part 3)

Lecture 16 OTBI – Advanced Features (Part 4)

Section 5: Core Financials Technical Tutorials

Lecture 17 Journal Import – Concepts and Setup (Part 1)

Lecture 18 Journal Import – Hands-on Tutorial (Part 2)

Lecture 19 GL Data Access Set – Basics (Part 1)

Lecture 20 AR – Customer Upload Tutorial (Part 1)

Lecture 21 AR – Auto Invoice Import Tutorial (Part 1)

Section 6: HCM Technical Tutorials

Lecture 22 HCM Master Data Upload (Part 1)

Lecture 23 HCM – Create Employee via Worker.dat (Part 1)

Section 7: Web Services Integration

Lecture 24 SOAP Web Services for Financials (Part 1)

Lecture 25 SOAP Web Services for Financials (Part 2)

Section 8: Oracle Integration Cloud (OIC)

Lecture 26 OIC – Introduction (Part 1)

Lecture 27 OIC – Connections and Adapters (Part 2)

Lecture 28 OIC – Mappings and Transformations (Part 3)

Lecture 29 OIC – Business Processes (Part 4)

Lecture 30 OIC – Integrations with Applications (Part 5)

Lecture 31 OIC – Import Invoice via FBDI (Part 6)

Lecture 32 OIC – Advanced Integrations (Part 7)

Lecture 33 OIC – Lookups (Part 8)

Lecture 34 OIC – Validating Files & Calling DB Packages (Part 8b)

Lecture 35 OIC – AR Invoice Creation (Part 9)

Lecture 36 OIC – AR Invoice Creation with DBCS (Part 10)

Lecture 37 OIC – REST APIs Deep Dive (Part 11)

Section 9: Page Composer & UI Extensions

Lecture 38 Page Composer and Sandbox – Introduction (Part 1)

Lecture 39 Page Composer – Displaying New Pages on Springboard (Part 2)

Section 10: Advanced Security & Reporting Tools

Lecture 40 Encrypting Files with PGP Keys (Part 1)

Lecture 41 Hyperion Financial Reporting Studio – Basics (Part 1)

Lecture 42 GL Ledger Data Access Set – In-depth Tutorial (Part 1)

Beginners who want to start a career as Oracle Fusion Technical Consultant.,Functional consultants looking to expand into technical development.,Developers or DBAs transitioning to Oracle Fusion Cloud.,IT professionals interested in ERP Cloud integrations and reporting.,Students preparing for Oracle Fusion Technical Consultant interviews.