Oracle General Ledger Setup & Management

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 Set of Books

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

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
• Set Up Multi Currency Accounting (MCR)
• Define a Cumulative Translation Adjustment Account
• Enter Daily Rates
• Enter Foreign Currency Journals
• Enter Period rates
• Enter Historical Rates
• Profile Options for MRC
• Work With Multiple Currencies in General Ledger
• Translate From Functional to Reporting Currency
• Working with MRC
• Transaction Level Conversion
• Inquiry and Reporting in MRC

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: ADI ACCOUNT HIERARCHY EDITOR

• Account Hierarchy Editor
• ADI Functional Security
• ADI profile Options
• Web ADI
• Account Hierarchy Manager
• AHM Set Up Steps
• Access AHM
• Account Hierarchy Manager Interface

Session 9: ADI SET UP AND SECURITY

• Set Up ADI Security
• ADI Profile Options
• Set Up ADI Applications Desktop Linking
• Modify the ADI Toolbar
• Modify the Ledger Options
• Modify the ADI General Options
• Modify the ADI Language Options
• Perform Diagnostics System Checks for ADIWeb ADI

Session 10: MULTI-COMPANY ACCOUNTING

• Multi-Companies with a Single Set of Books
• Automatic Balancing of Inter-company Transactions
• Consolidating Multiple Companies