Oracle R12 Reporting (FSG & Report Manager)

Select your learning method

Overview Learning objectives What you’ll learn Key facts FAQs What our customers say Get in touch

Learn essential skills

Course overview

Gain hands-on experience in Oracle R12 reporting tools that reflect today’s business demands. This Oracle R12 Financials training course enables you to produce accurate financial outputs to support compliance and informed business decisions.

Gain confidence with Oracle R12 Financials reporting

Develop core skills in using Oracle R12’s Financial Statement Generator (FSG) and Report Manager tools. This one-day course helps you create, format and publish financial reports with confidence and precision, boosting your impact in finance roles.

Learning objectives

Generate standard General Ledger reports
Configure FSG report components
Design and deliver custom layouts
Execute complete FSG reports
Publish using Report Manager
Format output for Excel
Use drill-down and filters
Manage output access and layout

What you’ll learn

Our Oracle R12 Financials training develops practical skills in financial report creation. You’ll learn to structure, refine and distribute reports using FSG and Report Manager – enhancing your value in finance and ERP teams.

Submitting and scheduling reports

Learn how to run Oracle General Ledger reports through the Submit Request form. This section guides you through configuring requests, scheduling recurring reports, monitoring activity via Concurrent Manager, and interpreting output stages. You’ll cover how to select the right templates, work with varied report formats and manage output for audit and compliance. By mastering these techniques, you’ll build confidence in managing standard financial reports to support business performance and review.

Building reports with FSG

This module introduces the Financial Statement Generator (FSG) as a flexible reporting tool. You'll define Row Sets, Column Sets, Content Sets and Row Orders to shape reports that reflect your business structure. Through our live lab exercises, you’ll practise ad hoc report creation and use AutoCopy to speed up tasks. Learn to group financial data by cost centre, account or period, and follow naming and design conventions to create clear, reusable outputs aligned to business goals.

Publishing with Report Manager

Discover how Report Manager supports the secure delivery and formatting of financial outputs in Oracle R12. You’ll learn how to configure publishing settings, assign permissions, export results to Excel and enhance presentation with display options. This module also introduces drill-down functionality and layout enhancements that help stakeholders access meaningful data. By the end of this session, you’ll be ready to support reporting cycles and compliance reviews with professional, well-managed outputs.

What’s included

One-day, live virtual classroom session
Learning materials and downloadable references
Live expert instruction
Real-world finance scenarios
ILX course completion certificate

Key facts

Ideal for

Professionals working in finance, ERP support or data roles who interact with Oracle R12 General Ledger outputs.

Prerequisites

Prior experience with Oracle R12 General Ledger is recommended.

Learning experience

Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one.

FAQs

This hands-on Oracle R12 Financials training course introduces you to key reporting functions. You'll learn to build and distribute reports using FSG and Report Manager tools – giving you the confidence to manage finance outputs with clarity and structure.

What are Oracle R12 FSG and Report Manager tools?

Oracle R12’s FSG and Report Manager are built-in reporting tools that help finance teams create, format and publish General Ledger reports. They support compliance, analysis and stakeholder reporting by delivering structured, customisable outputs.

Do I need experience with Oracle to take this course?

Yes. To get the most from this course, you should already have practical experience using Oracle R12 General Ledger. A basic understanding of how General Ledger data is structured and processed will help you engage fully with the interactive exercises and reporting tasks. If you're new to Oracle R12 or need to build foundational knowledge first, ILX also offers an Oracle R12 General Ledger course that’s ideal preparation. It provides the essential background in GL navigation, data entry and enquiry functions to support your progression into more advanced topics like FSG and Report Manager.

Does Oracle Report manager allow me to drill into report data for analysis?

Yes. Oracle Report Manager includes powerful drill-down capabilities that allow you to explore the underlying transactions behind summary-level figures. During the course, you’ll learn how to navigate from financial statement lines to supporting journal entries, sub-ledger transactions and balances. This feature is especially useful for audit preparation, variance analysis and providing context to senior stakeholders. Understanding how to use drill-down effectively helps you validate reports, troubleshoot anomalies and deliver more insightful financial commentary.

Will I receive Oracle R12 Financials certification for completing the course?

You’ll receive an ILX certificate of completion, confirming the skills gained. While not an official Oracle certification, it demonstrates valuable expertise to current and prospective employers.

What our customers say

“This is now my second course and once again the delivery was simply excellent. I was a little bit worried coming in that I wouldn't have the requisite knowledge; however, I found that it was just about the perfect level between being able to understand the concepts and stretching the grey matter. Hoping to come back for more in the future!”

Ashley, ILX learner

“Always good courses from ILX. Tutor explained the course very well.”

Paul, ILX learner

Why study with ILX

500,000+ learners

Join the half a million learners developing their skills with our training

5,000+ businesses

A trusted partner to thousands of organisations worldwide

96% customer satisfaction

Our passionate team goes above and beyond to support customer needs

Similar courses

Oracle Financials

Course

Oracle R12 General Ledger