Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

Oracle - General Ledger

( Duration: 2 Days )

This Oracle - General Ledger training 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 to practice as the course progresses.

By attending Oracle - General Ledger workshop, delegates will learn:

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

  • Knowledge of the general accounting function within their own organisation.

The Oracle - General Ledger class is ideal for:

  • Finance staff, and 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 AGENDA

1

Course Introduction

2

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
3

Accounting Calendars

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

Account Flexfield Design

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

Navigation

  • Login and Logout of Oracle
  • The Navigator Functions Tab
  • The Navigator Top Ten
  • 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
6

General Ledger Inquiries

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

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
8

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
9

Journal Reconciliation

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

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
11

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
12

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
13

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
14

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
15

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

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X