Oracle R12 General Ledger

2 Day Course
Hands On
Code FGLR12

Book Now - 2 Delivery Methods Available:

Classroom Virtual Classroom Private Group - Virtual Self-Paced Online


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. It provides 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 Report Manager to publish and interrogate them.

The delegates will practise:

  • 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
  • Using Web ADI: Journal Wizard, Budget Wizard,
  • Using Web ADI: Currency Rates Manager
  • Design a report using FSG - Financial Statement Generator
  • Publish / view / analyse reports using Report Manager

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.


Hide all

Introduction (8 topics)

  • Oracle General Ledger - Keywords and Concepts
  • Transactions
  • Balances
  • Overview of the General Ledger
  • New Features in Release 12
  • Chart of Accounts
  • Accounts and Periods
  • Ledgers and Ledger Sets

Accounting Calendars (4 topics)

  • Accounting Periods
  • Accounting Calendars
  • Posting Account Balances
  • Oracle General Ledger Features

Account Flexfield Design (2 topics)

  • Key Flexfield Overview
  • Account Code Combinations Review High-Level Invoice Information

Navigation (14 topics)

  • Login and Logout of Oracle
  • The Navigator Functions Tab
  • The Navigator Top Ten List
  • The Navigator Documents Tab
  • The Navigator Processes Tab
  • Oracle Window Features and Terminology
  • Oracle Form Features and Terminology
  • Flexfields
  • Icons
  • Enter and Find Data
  • Attachments
  • Folders
  • Profile Options
  • Oracle Help

General Ledger Inquiries (5 topics)

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

Journals (11 topics)

  • 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
  • Journal Reconciliation

Web ADI (3 topics)

  • Use the Journal Wizard to enter and upload a journal
  • Use the Budget Wizard to enter and upload budgets
  • Use the Currency Rates Manager to enter and upload exchange rate information

Journal Reconciliation (4 topics)

  • Set up Journal Reconciliation
  • Reconcile Journals
  • Run Reconciliation Reports
  • Reversal of Reconciliation process

Month and Year End Process Overview (3 topics)

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

Overview of Reporting Tools (10 topics)

  • Overview
  • Oracle General Ledger StandardReports
  • Report Categories
  • Financial Statement Generator
  • Oracle Financial Analyzer
  • Oracle Discoverer
  • RXi Reports Administration Tool
  • Oracle Reports
  • SQL * Plus Reports
  • Comparison of Reporting Tools

Standard General Ledger Reports (8 topics)

  • Concurrent Manager
  • Concurrent Processing Definitions
  • Useful Standard Reports
  • Submit Request Flow
  • Run a Standard General Ledger Report
  • Scheduling Options
  • Completion Options
  • View Requests

The Financial Statemeent Generator (12 topics)

  • Introduction to FSG Reporting
  • FSG Components
  • Plan an FSG Report
  • Sets
  • Predefined Row and Column Sets
  • Define Row and Column Sets
  • Generate an Ad Hoc FSG Report
  • Define Row Sets
  • Define Column Sets
  • Define an FSG Report
  • Run an FSG Report
  • Use a Content Set

Reporting with Report Manager (6 topics)

  • 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

General Ledger User Exercises (13 topics)

  • Run a Trial Balance Summary Report
  • Inquire on Account - Actual Amounts
  • Inquire on Account - Actual v Budget Amounts
  • Inquire on Journals
  • Enter a Journal - (standard and via Journal Wizard)
  • 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

FSG Exercises (8 topics)

  • 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

Report Manager Exercises (4 topics)

  • Publish a report from a form function
  • Analyse Report Output
  • Export Analysis to MS Excel
  • View a Report from Repository Management


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

Scheduled Dates

Please select from the dates below to make an enquiry or booking.


Different pricing structures are available including special offers. These include early bird, late availability, multi-place, corporate volume and self-funding rates. Please arrange a discussion with a training advisor to discover your most cost effective option.

Code Location Duration Price Feb Mar Apr May Jun Jul
FGLR12 2 Days $1,470

Course PDF


Share this Course


Recommend this Course