Oracle E-Business Suite 12 Certified Implementation Specialist: Oracle General Ledger

MODULE 1 : E-BUSINESS ESSENTIALS

Navigating in R12 Oracle Applications

  • Log in to Oracle Applications
  • Navigate from Personal Home Page to Applications
  • Choose a responsibility
  • Create Favorites and set Preferences
  • Use Forms and Menus
  • Enter data using Forms
  • Search for data using Forms
  • Access online Help
  • Run and monitor Reports and Programs
  • Log out of Oracle Applications

Introduction to Oracle Applications R12

  • Explain the footprint of R12 E-Business Suite
  • Describe the benefits of R12 E-Business Suite
  • Describe R12 E-Business Suite architecture

Shared Entities and Integration

  • Explain shared entities within R12 E-Business Suite
  • Describe key integration points and business flows between products in E-Business Suite (EBS)
  • Identify Key Business Flows and products involved in E-Business Suite (EBS)

Fundamentals of Flexfields

  • Describe Flexfields and their components
  • Identify the steps to implement a Flexfield
  • Define value sets and values
  • Define Key Flexfields
  • Define Descriptive Flexfields

Fundamentals of Multi-Org

  • Define Multiple Organization (Multi-Org)
  • Describe the types of organizations supported in the Multi-Org model
  • Explain the entities of Multi-Org
  • Explain how Multi-Org secures data
  • Identify key implementation considerations for Multi-Org
  • Define Multi-Org Access Control
  • Explain Multi-Org preferences
  • Explain Enhanced Multiple-Organization Reporting
  • Explain the concepts of subledger accounting

Fundamentals of Workflow and Alerts

  • Explain Workflow concepts
  • Describe the benefits of Workflow

MODULE 2- GENERAL LEDGER

Oracle General Ledger Process 

  • Identify the steps required to complete the accounting cycle using Oracle General Ledger
  • Describe how Oracle General Ledger integrates with other Oracle eBusiness applications
  • Describe the integration of Oracle General Ledger with Oracle Subledgers & non-Oracle systems
  • Explain implementation considerations for setting up and using Oracle General Ledger and Oracle eBusiness Suite
  • Describe an overview of Accounting Setup Manager, currency concepts, budgeting, EPB, reporting & analysis

Basic Journal Entries 

  • Describe how journal entries are positioned in the accounting cycle
  • Describe the different Journal Posting options
  • Define how to perform Account Inquiries & Drilldown to Oracle Subledger Applications
  • Import journal entry information using the GL_INTERFACE table
  • Plan the key elements of Web Applications Desktop Integrator (Web ADI)
  • Define Web ADI setup options for key flexfields
  • Utilize Web ADI profile options, forms functions, menus, and responsibilities

Advanced Security

  • Manage Data Access Security for Legal Entities and Ledgers
  • Explain key Advanced Security setups and process
  • Manage Data Access Sets
  • Control security of Management Reporting

Multi-Currency

  • Explain Multi-Currency concepts
  • Use Currency Rate Manager
  • Perform Foreign currency journals Entry
  • Perform Revaluation of foreign currency balances
  • Translate functional balances into foreign currency
  • Describe overview of Secondary Tracking Segment
  • Use Foreign Currency Reports

Financial Reporting

  • Explain the positioning of Financial Reporting within the Oracle General Ledger business flow
  • Build basic reports
  • Use key elements of the Financial Statement Generator (FSG) for creating financial reports
  • Use Standard listing reports available for FSG report definitions
  • Create FSG Reports with XML Publisher
  • Use Web ADI for Financial Reporting
  • Explain key implementation issues regarding Oracle General Ledger financial reporting

Accounting Setup Manager

  • Describe the components of Ledger Processing options
  • Describe Secondary Ledgers & Reporting Currencies
  • Describe Accounting Setup considerations with one legal entity
  • Describe Accounting Setup considerations with multiple legal entities
  • Describe Accounting Setup considerations with no legal entities

Accounting Setups

  • Create Accounting Setups
  • Describe the various Subledger Accounting Options
  • Perform the Primary Ledger Setup steps
  • Describe Ledger Balancing Segment Value Assignments
  • Perform the Secondary Ledger Setup steps
  • Complete Accounting Setup

Advanced Journal Entries 

  • Create Recurring Journals
  • Formulate Mass Allocation Journals
  • Describe AutoAllocations and related implementation considerations
  • Explain AutoScheduling
  • Describe the Journal Scheduling process
  • Describe key issues and considerations when implementing Advanced Journal Entry
  • Describe the business benefits of using Oracle General Ledger’s Advanced Journal Entry functions

Consolidations

  • Explain overview of Consolidations and their positioning within the Oracle General Ledger business flow
  • Identify the key implementation issues regarding consolidations
  • Use the features and functionality of Global Consolidation System (GCS)
  • Use the elements of the Consolidation Workbench
  • Create eliminating entries
  • Use Standard reports and inquiry options available for consolidations Ledger
  • Describe the elements required to create a ledger within Oracle General Ledger
  • Describe the basic components of Accounting Setup
  • Describe the important elements for creating a Chart of Accounts structure
  • Creating a new Accounting Flexfield structure
  • Utilize the Account Hierarchy Manager to view and maintain Accounting Flexfield values

Summary Accounts

  • Explain summary accounts and how they are used in General Ledger
  • Define How Parent Values/ Rollup Groups are used in General Ledger
  • Determine how Summary Templates are used
  • Use Budgetary Control & maintain Summary accounts
  • Plan and maintain Summary Account structures

Financial Budgeting 

  • Explain the anatomy of a budget
  • Explain the components of budget accounting cycle
  • Define budget and budget organization
  • Explain Budget Entry methods
  • Apply Budget Rules
  • Transfer budget amounts
  • Perform budget review and correction
  • Translate budget balances
  • Review balances in Master/Detail budgets
  • Create budgets with Budget Wizards
  • Use available Standard budget reports
  • Plan Budget implementation requirements

Period Close

  • Explain the accounting cycle
  • Perform key steps in the close process
  • Perform journal import of subledger balances
  • Perform Subledger Reconciliation
  • Explain the Period Closing Process and Reports
  • Consolidate account balances