<Insert Picture Here>
Oracle E-Business Suite R12.1 Financial Management Systems (FMS)
Essentials Partner Boot Camp Training Courseware
General Ledger Overview 1
For use by Oracle employees and authorized partners only.
Do not distribute to third parties. -1-
Safe Harbor Statement
The following is intended to outline our general
product direction. It is intended for information
purposes only, and may not be incorporated into any
contract. It is not a commitment to deliver any
material, code, or functionality, and should not be
relied upon in making purchasing decisions.
The development, release, and timing of any features
or functionality described for Oracle’s products
remains at the sole discretion of Oracle.
For use by Oracle employees and authorized partners only.
Do not distribute to third parties. -2-
Oracle Training Materials – Usage Agreement
Use of this Site (“Site”) or Materials constitutes agreement with the following terms and conditions:
1. Oracle Corporation (“Oracle”) is pleased to allow its business partner (“Partner”) to download and copy
the information, documents, and the online training courses (collectively, “Materials") found on this Site. The
use of the Materials is restricted to the non-commercial, internal training of the Partner’s employees only.
The Materials may not be used for training, promotion, or sales to customers or other partners or third
parties.
2. All the Materials are trademarks of Oracle and are proprietary information of Oracle. Partner or other
third party at no time has any right to resell, redistribute or create derivative works from the Materials.
3. Oracle disclaims any warranties or representations as to the accuracy or completeness of any Materials.
Materials are provided "as is" without warranty of any kind, either express or implied, including without
limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
4. Under no circumstances shall Oracle or the Oracle Authorized Delivery Partner be liable for any loss,
damage, liability or expense incurred or suffered which is claimed to have resulted from use of this Site of
Materials. As a condition of use of the Materials, Partner agrees to indemnify Oracle from and against any and
all actions, claims, losses, damages, liabilities and expenses (including reasonable attorneys' fees) arising out
of Partner’s use of the Materials.
5. Reference materials including but not limited to those identified in the Boot Camp manifest can not be
redistributed in any format without Oracle written consent.
For use by Oracle employees and authorized partners only.
Do not distribute to third parties. -3-
Key Content Contributors
Contributing Companies
For use by Oracle employees and authorized partners only.
Do not distribute to third parties. -4-
R12.1: Oracle Financials
For use by Oracle employees and authorized partners only.
Do not distribute to third parties. -5-
Module: Oracle General Ledger
Module Objectives
• General Ledger process overview
• General Ledger integration with other modules
• Setup and use of General Ledger module
For use by Oracle employees and authorized partners only.
Do not distribute to third parties. -7-
What is Oracle General Ledger?
• A Big Bucket, where
most financial
transactions end up!
• A “book of final entry,
summarising all of a
company’s financial $
transactions”
For use by Oracle employees and authorized partners only.
Do not distribute to third parties. -8-
Oracle General Ledger Overview
Other Subledgers
Manufacturing
Customer
Relationship
Management
Oracle General Ledger
Projects
Oracle Financials
Human Resources
Management
For use by Oracle employees and authorized partners only.
Do not distribute to third parties. -9-
Oracle General Ledger Overview
• Record
• Analyze
• Manipulate Other Subledgers
• Report &
Review
Review
Edit General Ledger
Record
Analyze, Correct,
and Adjust
For use by Oracle employees and authorized partners only.
Do not distribute to third parties. -10-
Major Functions and Features
Oracle General Ledger facilitates the following tasks:
• Financial controls
• Data collection
• Information access
• Financial reporting and analysis
For use by Oracle employees and authorized partners only.
Do not distribute to third parties. -11-
General Ledger Accounting Cycle
• Open period
• Create / Reverse journal entries
• Post
• Review
• Revalue
• Translate
• Consolidate
• Review / Correct balances
• Run accounting reports
• Close accounting period
For use by Oracle employees and authorized partners only.
Do not distribute to third parties. -12-
Integration with Other Oracle Modules
Financials HRMS
• Payables • Human Resources
• Receivables • Payroll
• Assets
• Purchasing
• Projects
• Treasury
• Property Manager
• Lease Management
Manufacturing Public Sector
• Inventory • Grants Accounting
• Work in Progress • Public Sector Budgeting
• Labour Distribution • Public Sector Financials
• Federal Financials
Business Intelligence / Analytics Non-Oracle Systems
• Financial Consolidation Hub
• Enterprise Planning & Budgeting
• Oracle Financial Services Application
• Daily Business Intelligence
• Activity Based Management
For use by Oracle employees and authorized partners only.
Do not distribute to third parties. -13-
Integration with Subledgers
Transfer in summary Automatic or manual
or detail
Subledgers GL_INTERFACE Journal Import
GL_BALANCES Post GL_JE_LINES
GL_JE_HEADERS
GL_JE_BATCHES
For use by Oracle employees and authorized partners only.
Do not distribute to third parties. -14-
Importing from Non–Oracle Systems
Journal Import
Budget Import ADI Budget
ADI Journal
Spreadsheet
Spreadsheet
Other feeder
systems
General Ledger
For use by Oracle employees and authorized partners only.
Do not distribute to third parties. -15-
Steps to set up General Ledger
• Accounting Setup Manager
– Legal Entities
– Operating Units
– Ledgers (primary and secondary ledgers)
– Data Access Sets
– Ledger Sets
– Reporting Currencies
– Foreign Currency Concepts
– Subledger Accounting
– Inter- and Intra-company Balancing
– Sequencing (Accounting and Reporting Sequencing)
• Budgeting
• Reporting & Analysis
For use by Oracle employees and authorized partners only.
Do not distribute to third parties. -16-
Accounting Setup Manager
• Centralized definition and maintenance of accounting setup:
– Step 1 : Create Legal Entity
– Step 2 : Create Primary Ledger : 4C’s
– Step 3 : Optional : Create Secondary Ledger
– Step 4 : Define Accounting Options
For use by Oracle employees and authorized partners only.
Do not distribute to third parties. -17-
Budgeting
• Oracle General Ledger provides many methods to enter, maintain
and track budget data, depending on your specific organizational
needs.
• Budget entry methods comprises of:
– Excel Spreadsheet through ADI
– Budget Journals / Amounts
– Budget Formulas
– Budget / Journal Wizards
• Maintenance and Tracking of Budget can be performed through:
– Enterprise Planning and Budgeting (EPB) module
For use by Oracle employees and authorized partners only.
Do not distribute to third parties. -18-
Reporting & Analysis
• Oracle General Ledger provides a variety of powerful reporting and
analysis capabilities:
– Standard reports and listings
– Financial Statement Generator (FSG)
– Applications Desktop Integrator (ADI)
– Report Wizard
– ReQuest Center
– Analysis Wizard
– Online account and transaction analysis
– Enterprise Planning and Budgeting (EPB)
For use by Oracle employees and authorized partners only.
Do not distribute to third parties. -19-
Module Highlights
• Module overview
• Major functions & features
• Accounting cycle
• Integration points
• Module setup steps
For use by Oracle employees and authorized partners only.
Do not distribute to third parties. -20-