Skip to content
MSAMM
Back to all courses

Technical & Dev · Fusion · Advanced

Oracle Fusion Technical: Reports, Data, Integrations and Extensions

Nineteen modules, nineteen labs, and a technical work package end to end

The layer beneath the functional courses. Data gets into Fusion, comes back out as a report, and another system talks to it - and none of that is configuration you can click your way through. This is for the consultant or developer who can already navigate Fusion and now has to load a client history, explain why a report is slow, or make an integration survive a quarterly update. Vendor documentation lists the tools. This covers which one answers which question, what order the work goes in, and which decisions cannot be taken back once transactions exist.

Live cohort · registration open

Live teaching starts 14 December 2026

One hour daily, Sunday to Thursday · 19:00 Riyadh, 18:00 Cairo · 9 weeks

Taught live by an Oracle consultant, with every session recorded for anyone who misses one. Places are limited — we teach these in small groups so questions get answered.

Your access starts the day you enrol, not the day the cohort starts. The written lessons, the quizzes and the final assessment open straight away, so you can come to the first session having already read the ground.

The sessions run online, and the joining details reach you by email before the first one.

Watch a free lesson

All free lessons in this course · 9 free lessons

EGP 8,625EGP 11,500Save 25%

177 lessons · 266 min

Fourteen-day refund · Full refund within fourteen days if you have completed fewer than a fifth of the lessons and not sat the assessment. Read the refund policy.

Buying for a team? See seat pricing.

Bundle · save 25%

Oracle Technical Track

All 4 courses together for EGP 34,500 instead of EGP 46,000.

Includes

Request this bundle

There is no bundle checkout yet. Leave your email and we will send a payment link within one business day; every course in the bundle is unlocked when it is paid.

Get the free lessons by email

We will email you a link to every free lesson in this course. No account needed, and one message only.

Or get them on WhatsApp

Who this is for

  • Consultants and developers who can navigate Fusion and now have to load a client history, explain a slow report, or make an integration survive a quarterly update.
  • Technical leads on an implementation, deciding which tool answers which question before the work starts.
  • Functional consultants who keep reaching the line where configuration stops and the technical layer begins.

What you will be able to do

  • Choose between BI Publisher, OTBI and a direct extract for a given reporting question, and defend the choice.
  • Build a BI Publisher data model and template that still performs when the data set grows.
  • Load master and transactional data with FBDI, and prove afterwards that it landed correctly.
  • Plan a migration with a reconciliation that a finance owner will accept.
  • Call Fusion from another system, and let Fusion call out, without inventing a bespoke integration.
  • Extend Fusion inside supported boundaries, and recognise when a request has crossed one.
  • Refresh a non-production environment without leaking production data or losing configuration.
  • Read a quarterly update for risk and test the right things before it lands.

What you should know first

  • You can navigate Fusion and have seen at least one implementation from the inside.
  • SQL you can read and write - joins, aggregates, and why a query is slow.
  • An environment you are allowed to break. Several lessons demonstrate operations that are disruptive in a shared instance, and one module is about refreshing environments, which cannot be rehearsed anywhere else.
  • No prior BI Publisher, OIC or Java experience is assumed.

What you will cover

Watch a free lesson

1. Module 0 · Orientation

What this course covers, what it deliberately leaves to the functional courses, and how to get an environment you are allowed to break.

4 lessons9 min

2. Module 1 · The Fusion technical landscape

The layers a technical consultant works across, and which problems live in which one. The module that stops you solving a reporting problem with an integration.

7 lessons14 min

3. Module 2 · Security, roles and what you are allowed to see

Role-based access as it actually behaves, and the diagnostic sequence for "why can this person not see that". The module that saves you from granting a role to fix a data problem.

10 lessons20 min

4. Module 3 · The reporting stack: which tool answers which question

The decision module. Four tools overlap and choosing wrongly costs weeks, so this settles the choice before any of them is opened.

8 lessons16 min

5. Module 4 · BI Publisher: data models, templates and bursting

FLAGSHIP. The tool most technical work ends up in, and the one where an early decision about the data model cannot be tuned away later.

14 lessons28 min

6. Module 5 · OTBI and subject areas

The tool a business user can maintain after you leave, and the reason to prefer it whenever it can answer the question at all.

11 lessons22 min

7. Module 6 · Reports at scale: scheduling, delivery, performance

What changes when a report stops being run by a person and starts running itself at 2am for a thousand recipients.

8 lessons16 min

8. Module 7 · FBDI: the file-based loader end to end

FLAGSHIP. The main road for getting data into Fusion, and the one where an error is not a rejected file but posted transactions nobody expected.

14 lessons29 min

9. Module 8 · HDL for HCM data

HCM loads its own way, and the differences from FBDI are not cosmetic - effective dating changes what a load even means.

10 lessons20 min

10. Module 9 · Migration strategy and reconciliation

FLAGSHIP. The module about deciding what to migrate, in what order, and how to prove it afterwards to somebody who signs for it.

11 lessons22 min

11. Module 10 · REST and SOAP: calling Fusion, and being called

The integration surface, without an integration platform. What Fusion exposes, how to use it, and how to keep it working across updates.

12 lessons24 min

12. Module 11 · Integration patterns without OIC

What you can build with what Fusion already has, and the honest boundary where an integration platform stops being optional. Keeps OIC a separate product rather than a prerequisite.

8 lessons16 min

13. Module 12 · Extensions: sandboxes, Page Composer and the boundaries

Changing what users see, inside what Oracle supports. The module that teaches you to recognise a request that has crossed the line before you have spent a week on it.

10 lessons20 min

14. Module 13 · Groovy in Application Composer

The scripting that runs inside Fusion. Small, constrained, and the place where an innocuous-looking rule becomes a performance problem for everyone.

9 lessons18 min

15. Module 14 · Approvals and BPM workflow

Routing work to people. Configuration rather than code, and the module where a wrong rule is discovered by an invoice that nobody approved for three weeks.

10 lessons20 min

16. Module 15 · ESS jobs and scheduling

The scheduler everything else runs on. Understood properly it explains most "why did that not happen" questions in Fusion.

8 lessons16 min

17. Module 16 · Environment management: P2T, refreshes and what breaks

FLAGSHIP. The module that cannot be rehearsed anywhere but a real estate, and the one where a mistake sends production data somewhere it must never be.

9 lessons18 min

18. Module 17 · Release readiness: quarterly updates and regression

Updates arrive on a schedule you do not control. Reading them for risk, and testing the right things rather than everything.

8 lessons16 min

19. Module 18 · Capstone: one technical work package, end to end

A single realistic brief that touches reporting, loading, integration and extension - delivered, reconciled and handed over.

6 lessons12 min