Oracle R12 Reporting (FSG & Report Manager)

Course code: O922

2 days

This 2 day hands on Oracle R12 FSG & Reporting course is designed to focus on working with the capabilities of the Financial Statement Generator within Oracle R12 General Ledger to build a suite of reports from a set of pre-defined report components.

Course content >

Who Should Attend?

End Users
Finance Managers
Financial Professionals
Finance Support Staff 


Oracle GL

iTrain also offer all of these courses as closed courses on your site. Please call 020 7608 1835


Course Contents

Delegates will be able to build a financial report using both the mandatory and optional report components provided by the Financial Statement Generator. The Report Manager section of the course shows how to publish and analyse these reports and apply security where required.

On this intensive course delegates will practice running and modifying such reports. They will use Report Manager as a publishing and analysis tool where a higher standard of presentation is required together with the capability to drill down to individual sub-ledger transactions.

On completion of this Oracle R12 Reporting (FSG & Report Manager) course delegates will be able to create and submit both standard and customized reports using data within the General Ledger module.

This course can be tailored for companies wishing to receive in house, or closed company training

Course Structure and Agenda

Overview of Reporting

Oracle General Ledger Reports
Oracle General Ledger Standard Reports
Financial Statement Generator
Oracle Financial Analyzer
Oracle Discoverer
RXi Reports Administration Tool
Oracle Reports
SQL Reports
Report Manager
Comparison of Reporting Tools


GL Reports
Concurrent Manager
Concurrent Processing Definitions
Useful Standard Reports
Submit Request Flow
Run a Standard General Ledger Report
Scheduling Options
Completion Options
View Requests


Financial Statement Generator
Introduction to FSG Reporting
FSG Components
Plan a FSG Report
Use Row and Column Sets
Define Row Sets
Define Column Sets
Generate an ad hoc FSG Report
Define a FSG Report
Run a FSG Report
Use a Content Set


Report Manager
Overview of Report Manager
Report Manager structure and access
Publish a report to Reports Repository
View a report in Reports Repository
Publish a report from eBusiness Homepage
Analyse a Financial Report with Report Manager


FSG Exercises
Define a Row Set
Define a Column Set
Define an FSG Report
Run an FSG Report
View Report Requests
Define a Content Set
Define Display Groups and Display Sets
Define a Row Order


Report Manager Exercises
Publish a Report from a Form Function
Analyse Report Output
Export Analysis to MS Excel
View a Report from Repository Management

Contact us for more information