Oracle R12 Reporting (FSG & Report Manager)

1 Day Course
Hands On
Code FRR12

Book Now - 2 Delivery Methods Available:

Classroom Virtual Classroom Private Group - Virtual Self-Paced Online


After completing 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. The focus is 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. The Report Manager section of the course shows how to publish and analyse these reports and apply security where required.

The delegate will practice:

  • Running Standard reports with the Submit Request Form
  • Using FSG Report Data Sources and Data Structures
  • Defining an ad hoc FSG Report
  • Defining FSG Row and Column Sets
  • Defining a FSG Content Sets
  • Defining FSG Row Order
  • Running a FSG Report
  • Using FSG AutoCopy
  • Using Report Manager to publish standard and financial reports

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.


Hide all

An Overview of Reporting Tools (10 topics)

  • 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

Standard General Ledger Reports (9 topics)

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

The Financial Statement Generator (10 topics)

  • 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

Reporting With Report Manager (6 topics)

  • 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 (8 topics)

  • 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 (4 topics)

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


A working knowledge of Oracle General Ledger is required.

Scheduled Dates

Please select from the dates below to make an enquiry or booking.


Different pricing structures are available including special offers. These include early bird, late availability, multi-place, corporate volume and self-funding rates. Please arrange a discussion with a training advisor to discover your most cost effective option.

Code Location Duration Price Apr May Jun Jul Aug Sep
Later scheduled dates may be available for this course.

Course PDF


Share this Course


Recommend this Course