Oracle R12 Reporting (FSG & Report Manager)
- Course Code FRR12
- Duration 1 day
Course Delivery
Additional Payment Options
-
GTC 9 inc. VAT
GTC, Global Knowledge Training Credit, please contact Global Knowledge for more details
Jump to:
Course Delivery
This course is available in the following formats:
-
Company Event
Event at company
-
Public Classroom
Traditional Classroom Learning
-
Virtual Learning
Learning that is virtual
Request this course in a different delivery format.
Course Overview
TopAfter 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.
Course Schedule
TopTarget Audience
TopThis 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.
Course Objectives
TopBy 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.
Course Content
TopOracle 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
Course Prerequisites
TopA working knowledge of Oracle General Ledger is required.
Follow on Courses
Top- Oracle R12 General Ledger Setup & Management (FGLSMR12)
- STA_FRR12
- Oracle R12 Reporting (FSG & Report Manager)
- Business Analysis
- STA_FRR12 | Oracle R12 Reporting (FSG & Report Manager) | Training Course | Oracle.
- Oracle
