0 Items | 0.00
Go

Course Overview

Authorised training on Cisco, Microsoft, Nortel and VMware as well as generic networking, security, VoIP and wireless courses. Our management curriculum includes project management, business analysis and ITIL training.


Oracle R12 General Ledger Setup & Management

Course Code: FGLSMR12
Day(s): 1
Price: £395.00 (ex. VAT)

Overview 

This course is designed to give delegates the knowledge to set up and use Oracle General Ledger. Delegates will learn how to create an Accounting Setup, set up journals, define budgets and budget organisations and set budgetary controls. There will be opportunities to practice implementing many of the new features introduced in R12 General Ledger such as Primary and Secondary Ledgers, Reporting Currencies, Ledger Sets and Data & Definition Access Sets.


Pre-Requisites

Oracle R12 General Ledger



Next Course Dates

August
22 Aug - 22 Aug, 2012LondonAdd to Basket
November
14 Nov - 14 Nov, 2012LondonAdd to Basket






    More Information

    This Oracle R12 General Ledger Setup & Management is designed for managers in a finance department who need to set up and manage the Oracle General Ledger or systems administrators who need to carry out both initial set up and ongoing maintenance tasks. It would also suit delegates who currently work with Oracle General Ledger who wish to gain a greater appreciation of its available functionality.

    By the end of the Oracle R12 General Ledger Setup & Management course, delegates will be able to identify the key implementation and setup issues of the Oracle General Ledger.

    Skills Gained

    The delegate will practise:

    Working with the Accounting Setup Manager

    Setting up Accounting Periods and Calendars

    Defining Accounting Flexfields

    Defining Security and Cross Validation Rules

    Performing General Ledger Inquiries

    Setting Up General Ledger Journals

    Setting Journal Profile Options

    Setting Up Journal AutoReversal Criteria and Defining AutoPost Criteria

    Opening and Closing GL Accounting Periods

    Setting Up and Using Reporting Currencies

    Defining Budgets and Budget Organizations

    Setting Budgetary Controls

    Performing Budget Inquiries

    Course Contents - DAY 1

    Course Introduction

    Administration and Course Materials

    Course Structure and Agenda

    Delegate and Trainer Introductions

    Session 1: INTRODUCTION TO THE GENERAL LEDGER

    General Ledger Keywords and Concepts

    Overview of the General Ledger

    Define a Ledger

    Define a Ledger Set

    Define a Data Access Set

    Session 2: ACCOUNTING CALENDARS

    Accounting Periods

    Accounting Calendars

    Define an Accounting Calendar

    Post Account Balances

    Session 3: CHART OF ACCOUNTS STRUCTURE

    Flexfield Considerations

    Good Design Principles

    Define the Accounting Flexfield

    Parent/Child Accounts

    Rollup Groups and Summary Account Templates

    Session 4: JOURNALS

    Key Set Up Considerations for GL Journals

    Set Up Options for Journaling

    Set Up Journal Options

    Journal Profile Options

    Journal AutoReversal Set Up Steps

    Define an AutoPost Criteria set

    Reports Listings and Inquiry Options for Journals

    Session 5: GENERAL LEDGER SECURITY RULES

    Security Rules and Cross Validation Rules

    Define a Security Rule

    Cross Validation Rules

    Session 6: MULTI CURRENCY

    Key Processes

    Defining a Reporting Currency

    Define a Cumulative Translation Adjustment Account

    Enter Daily Rates

    Enter Foreign Currency Journals

    Enter Period rates

    Enter Historical Rates

    Profile Options

    Work With Multiple Currencies in General Ledger

    Translate From Functional to Reporting Currency

    Transaction Level Conversion

    Inquiry and Reporting

    Session 7: BUDGETING

    Overview of Budgeting

    Create Master and Detail Budgets

    Define Budgets

    Define Budget Organizations

    Protect a Budget Organization with a Password

    Set Budgetary Control Options for an Account Range

    Copy Account Ranges from an Existing Budget Organization

    Add or Change Individual Accounts

    Delete a Budget Organization

    Budget Reports and Listings

    Define a Rollup Group

    Assign Rollup Groups to Account Segment Values

    Create a Summary Account Template

    Carry Out a Budget Inquiry

    Session 8: MULTI COMPANY ACCOUNTING

    Automatic Balancing of Inter-company Transactions

    Consolidating Multiple Companies

    Oracle R12 System Administration


    In This Section


    Copyright © 2012 Global Knowledge Network Training Ltd. Registered in England & Wales with company no. 05462286. VAT no. GB878 5513 76.
    RSS. (Srv: 220)