Oracle Reporting (FSG & ADI)

1 day @ £350.00  
S5

Oracle Reporting (FSG & ADI) Course Overview

After completing this course delegates will be able to create and submit both standard and customised reports using data within the General Ledger module.  The focus is on working with the capabilities of the Financial Statement Generator within Oracle 11i General Ledger to build a suite of reports from a set of pre-defined report components.  The ADI section of the course shows how to amend, publish and analyse these reports.

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 FSG Account Assignments
  • Defining FSG Calculations
  • Defining a FSG Content Sets
  • Defining FSG Row Order
  • Running a FSG Report
  • Using FSG AutoCopy
  • Creating Reports Using the ADI Report Wizard
  • Using the ADI Wizard to Define and Publish Reports
  • Producing Reports in the Request Centre
  • Linking ADI Reports to FSG Reports

Who will the Course Benefit?

This Oracle Reporting (FSG & ADI) course is designed for end users and managers in Finance departments, financial professionals and technical support staff.

Course Objectives

By the end of this Oracle Reporting (FSG & ADI) 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 ADI 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

Familiarity with the Oracle General Ledger.  A working knowledge of Oracle General Ledger is required.

Oracle Reporting (FSG & ADI) 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 11i REPORTING TOOLS

  • Oracle General Ledger Reports
  • Oracle General Ledger Standard Reports
  • Financial Statement Generator
  • Oracle Financial Analyzer
  • Applications Desktop Integrator
  • Oracle Discoverer
  • RXi Reports Administration Tool
  • Oracle Reports
  • SQL Reports
  • 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: OVERVIEW OF APPLICATIONS DESKTOP INTEGRATOR

  • Introduction to ADI
  • Advantages of Using ADI Reports
  • Options for Creating a Report in ADI
  • Starting ADI
  • The ADI Toolbar

Session 5: DEFINING AND PUBLISHING REPORTS IN ADI

  • Set Defaults for ADI
  • Set FSG Options for ADI
  • Publishing Reports in ADI

Oracle Reporting (FSG & ADI) Training Course

Course Contents - DAY 1 ( continued)

Session 6: PRODUCING REPORTS IN THE ADI REQUEST CENTRE

  • Overview
  • Request Centre Functions
  • The ADI Request Centre
  • Submitting Reports
  • Submit a Standard (Fixed Format) Report
  • Submit a Standard (Variable Format) Report
  • Submit a Financial Statement or Ad Hoc Report
  • Create and Apply Themes
  • Report and Request Sets

Session 7: THE ADI REPORT WIZARD

  • Access the Report Wizard Toolbar
  • The Report Wizard Toolbar
  • Create a Report Using the Report Wizard
  • Define a Report in ADI with Existing Reports Components

Session 8: PARENT CHILD PARAMETERS

  • Review or Amend Parent/Child Parameters
  • Define a New Parent Account

Session 9: ROLL UP GROUPS

  • Roll Up Groups and Budget Inquiries
  • Define a Roll Up Group
  • Assign Roll ID Groups to Account Segment Values
  • Create a Summary Account Template

Session 10: FSG AND ADI EXERCISES

Follow-On Courses


       Home     Let Us Call You     Enquiry     Make Booking     Top

Make A Booking

In London


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 7600 6116
Manchester centre:
MWB Manchester
Pall Mall Court
61-67 King Street
Manchester
M2 4PD
UK
Birmingham centre:
MWB Birmingham
43 Temple Row
Birmingham
B2 5LS
UK
Bristol centre:
Woodhouse Manor
Fern Hill
Almondsbury
Bristol
BS32 4LX
UK
Leeds centre:
c/o Blue Chip Training Solutions
11 New Princess Street
Leeds
LS11 9BA
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 7600 6116

or email:

info@
stayahead.com



 

Top  |  Go back  

Print Friendly

Printer friendly version of the Oracle Reporting (FSG & ADI) outline