Oracle R12 Reporting FSG and Report Manager

Who will the Course Benefit? Who will the Course Benefit?

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.

The delegate will learn and acquire skills as follows:

• 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

Using Report Manager to publish standard and financial reports Course Objectives Course Objectives

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.

View Course Contents - DAY 1 Oracle R12 Reporting (FSG & Report Manager) Training Course

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

View Course Contents - DAY 1 (continued)

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

Course Contents

View Course Contents - DAY 1

Oracle R12 Reporting (FSG & Report Manager) Training Course

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

View Course Contents - DAY 1 (continued)

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

Course Contents View Course Contents - DAY 1

...more Oracle R12 Reporting (FSG & Report Manager) Training Course

Oracle R12 Reporting (FSG & Report Manager) Training Course Oracle R12 Reporting (FSG & Report Manager) Training Course

Analyse a Financial Report with Report Manager View Course Contents - DAY 1 (continued) View Course Contents - DAY 1 (continued) View Course Contents - DAY 1 (continued) View Course Contents - DAY 1 (continued)