Professional Training

Prerequisites

A working knowledge of Oracle General Ledger is required.

Course Objectives

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.

The delegate will learn and acquire skills as follows:

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
Enabling Encumbrance Accounting
Setting Budgetary Controls
Performing Budget Inquiries

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

Accounting Calendars

Accounting Periods
Accounting Calendars
Define an Accounting Calendar
Post Account Balances

Chart of Accounts Structure

Flexfield Considerations
Good Design Principles
Define the Accounting Flexfield
Parent/Child Accounts
Rollup Groups and Summary Account Templates

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

General Ledger Security Rules

Security Rules and Cross Validation Rules
Define a Security Rule
Cross Validation Rules

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

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

Multi-company accounting

Automatic Balancing of Inter-company Transactions
Consolidating Multiple Companies

Encumbrance Accounting

Set up steps in General Ledger
Set up steps in Purchasing
Funds Inquiry
Encumbrance reports
Transaction processing examples