Oracle R12 Reporting (FSG & Report Manager)

This Oracle R12 Reporting (FSG & Report Manager) course is designed for end users and managers working in Finance departments, financial professionals and technical support staff. A working knowledge of Oracle General Ledger is required.

By the end of this Oracle R12 Reporting course, delegates will be able to build a financial report using both the mandatory and optional report components provided by the Financial Statement Generator. They 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.

Oracle R12 Reporting (FSG & Report Manager) Training Course

Course Contents - DAY 1
Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Session 1: AN OVERVIEW OF REPORTING TOOLS

• 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

Session 2: STANDARD GENERAL LEDGER REPORTS

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

Session 3: THE 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

Session 4: REPORTING WITH 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

Session 5: 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

Session 6: REPORT MANAGER EXERCISES

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