Oracle General Ledger

Course Code: FGL

Duration: 2 days

Oracle General Ledger Course Overview

This course covers all the key areas of end user functionality provided in Oracle General Ledger. Routine tasks such as journal processing, inquiries and running reports are all covered within the syllabus, with extensive opportunities for delegates to practice as the course progresses.

Course Objectives

To provide delegates with basic navigation skills and an appreciation of terminology used in Oracle Financials; to process manual journals from start to end; to carry out inquiries; to define and run FSG reports and to use ADI to publish, interrogate and modify them.

Who will the Course Benefit?

This Oracle General Ledger course is suitable for delegates who have no previous knowledge of Oracle Financials. It incorporates navigation skills training and thus fulfils a pre-requisite for most of the other Oracle Financials courses. Its intended audience comprises finance staff, those who provide support to them such as Systems Administrators and those whose role includes some financial or budgetary responsibility which requires them to use Oracle Financials

Skills Gained

The delegate will learn and acquire skills as follows:

Navigation
Performing General Ledger inquiries
Performing funds available inquiries
Inquiring on actuals, encumbrances and budgets
Creating manual and statistical journals
Finding and amending journals
Generating a reversing journal
Approving manual journal entries
Posting a journal batch
Creating recurring and formula journal templates
Using balancing accounts
Transferring balances between accounts
Running concurrent requests
Running standard General Ledger reports
Viewing requests
Creating basic FSG and ad hoc reports
Producing reports in the ADI request centre
Linking ADI Reports to FSG Reports

View Course Contents - DAY 1

Oracle General Ledger Training Course

Course Introduction

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

Session 1: INTRODUCTION

Oracle General Ledger - Keywords and Concepts
- Transactions
- Balances
Overview of the General Ledger
- Chart of Accounts
- Accounts and Periods
- Set of Books

Session 2: ACCOUNTING CALENDARS

Accounting Periods
Accounting Calendars
Posting Account Balances
Oracle General Ledger Features

Session 3: ACCOUNT FLEXFIELD DESIGN

Key Flexfield Overview
Account Code Combinations

Session 4: NAVIGATION

Session 5: GENERAL LEDGER INQUIRIES

General Ledger Inquiries
Funds Available Inquiries
Inquiring on Actuals
Inquiring on Encumbrances
Inquiring on Budgets

View Course Contents - DAY 1 (continued)

Session 6: JOURNALS

Create a Manual Journal
Create a Statistical Journal
Create a Mixed Journal
Create a Reverse Journal
Generate a Reverse Journal
Find and Amend a Journal
Post a Journal Batch
Create a Fixed Recurring Journal Template
Generate a Recurring Journal Template
Create a Formula Recurring Journal Template
Create a Formula Recurring Journal Template Through AutoCopy

Session 7: MONTH AND YEAR END PROCESS OVERVIEW

Month and Year End Process Overview
Oracle Data Flow Across Ledgers
Steps for General Ledger Month and Year End

Session 8: GENERAL LEDGER USER EXERCISES

Run a Trial Balance Summary Report
Inquire on Account - Actual Amounts
Inquire on Account - Actual v Budget Amounts
Inquire on Journals
Enter a Journal
Post Journals
Enter Journal Batches
Reverse an Existing Journal
Post the Reversal
Define Recurring Journals
Generate a Recurring Journal
Create a Folder Definition
Run Standard Reports

View Course Contents - DAY 2

Oracle General Ledger Training Course

Session 9: AN OVERVIEW OF REPORTING TOOLS

Session 10: STANDARD GENERAL LEDGER REPORTS

Session 11: INTRODUCTION TO FSG REPORTING

Session 12: OVERVIEW OF APPLICATIONS DESKTOP INTEGRATOR

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

View Course Contents - DAY 2 (continued)

Session 13: DEFINING AND PUBLISHING REPORTS IN ADI

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

Session 14: PRODUCING REPORTS IN THE ADI REQUEST CENTRE

Session 15: 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 16: PARENT CHILD PARAMETERS

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

Session 17: 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 18: 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
Define and Publish an ADI Report
Produce Reports in the ADI Request Centre
The ADI Report Wizard

Notes:

Course technical content is subject to change without notice.
Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.

Requirements

Delegates should have knowledge of the general accounting function within their own organisation.

Follow-On Courses

Oracle Accounts Receivable

Oracle Accounts Payable

Course Reviews

John was very helpful in tailoring the content of the course to the needs of the delegates. I found the course very useful.

Rachel - Government

Public Scheduled Events

Classroom & Live Virtual Instructor-Led Training

Duration: 2 days

Price: £1,050.00 exc. VAT

Please contact us to review your requirements and schedule a date.

Print Friendly

Why Choose StayAhead?

Leading indpendent UK training provider, established 1992
Formidable reputation for quality and expertise
Flexibility comes from developing our own independent courses
Course not meeting your needs? Private courses can be tailored specifically for you
Public Schedule & Closed Intructor-Led training - Classroom and Virtual

Live Virtual Classroom

Join live instructor-led classroom training from the comfort of your home or office.
All the convenience and benefits of the classroom experience without the hassle and costs of travel and accommodation.

Live Virtual Classroom

Our Customers Include