reed.co.uk Courses

Header

Oracle R12 General Ledger


StayAhead Training

Summary

Price
£1,260 inc VAT
Study method
Distance Learning with live classes
Duration
2 Days, Part-time/Full-time
Qualification
No formal qualification
Additional info
  • Tutor is available to students

1 student enquired about this course

Add to basket or enquire

Enquire now Enquire for business

Enquiring for your team?

Get in touch with the course provider to understand what training they can offer you.

Overview

S6Oracle R12 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.

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

Who will the Course Benefit?

This Oracle R12 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.

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

Requirements

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

Follow-On Courses

  • Oracle R12 General Ledger Setup & Management

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.

Oracle R12 General Ledger Training Course

Description

Course Contents - DAY 1Course 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
  • New Features in Release 12
  • Chart of Accounts
  • Accounts and Periods
  • Ledgers and Ledger Sets

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 Review High-Level Invoice Information

Session 4: NAVIGATION

  • 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

Session 5: GENERAL LEDGER INQUIRIES

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

Oracle R12 General Ledger Training CourseView 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
  • Journal Reconciliation

Session 7: WEB ADI

  • 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

Session 8: JOURNAL RECONCILIATION

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

Session 9: 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 10: 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 - (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

Oracle R12 General Ledger Training CourseCourse Contents - DAY 2Session 11: OVERVIEW OF REPORTING TOOLS

  • 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

Session 12: STANDARD GENERAL LEDGER REPORTS

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

Session 13: THE FINANCIAL STATEMENT GENERATOR

  • 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

Session 14: 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 15: 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 16: REPORT MANAGER EXERCISES

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

Questions and answers

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

What does study method mean?

Study method describes the format in which the course will be delivered. At reed.co.uk courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

What are CPD hours/points?

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on reed.co.uk, many of which can be completed online.

What is a ‘regulated qualification’?

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

What is an ‘endorsed’ course?

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body’s logo if they wish. Certain awarding bodies - such as ABC Awards and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.

Modals

Mobile Navigation