Oracle R12 Reporting (FSG & Report Manager)

1 day @ £375.00  
S6

Oracle R12 Reporting (FSG & Report Manager) Course Overview

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.

Skills Gained

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

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.

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.

Requirements

A working knowledge of Oracle General Ledger is required.

Note:

Delegates who are also going to attend the Oracle R12 General Ledger course should note that the Oracle R12 Reporting (FSG & Report Manager) course material is also covered in that course.

Follow-On Courses

NOTE: Course technical content is subject to change without notice.

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

Oracle R12 Reporting (FSG & Report Manager) Training Course

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

Follow-On Courses


       Home     Let Us Call You     Enquiry     Make Booking     Top

Make A Booking

In London




May also be run upon request at:

Centres


Oracle User Group - Membership Benefits

Oracle User Group - Membership Benefits

 

MOD Career Transition

Ministry Of Defense - Career Transition Partnership

 

We have created our website to the following W3C standards, this helps makes our pages easier to use for you.

Valid HTML 4.01 Transitional

Valid CSS!

If you find a non-compliant page on our site, please let us know and we will endeavour to fix it immediately.
 

Publicly Scheduled
Training Locations
London centre:
6 Long Lane
Barbican
London
EC1A 9HF
UK

telephone:
+44 (0)20 7600NoSkype 6116
Manchester centre:
St James Court
30 Brown Street
Manchester
M2 1DH
UK
Birmingham centre:
The Enterprise Suite
9th Floor Centre City Tower
5-7 Hill Street
Birmingham
B5 4UA
UK
Bristol centre:
Apex House
Westerleigh Business Park
Turner Drive
Yate
Bristol
BS37 5YX
UK
Leeds centre:
Halsbury House
Chancellor Court
21 The Calls
Leeds
LS2 7EH
UK
Edinburgh centre:
16 St Mary's Street
Edinburgh
Scotland
B3 2HJ
UK
Please contact our London office for all enquiries.

telephone:
+44 (0)20 7600NoSkype 6116

or email:

info@
stayahead.com



 

Top  |  Go back  

Print Friendly

Printer friendly version of the Oracle R12 Reporting (FSG & Report Manager) outline