Course Description

Prepare to pass exam: Oracle E-Business Suite R12.1 General Ledger Essentials

The Oracle E-Business Suite 12 Financial Management Certified Implementation Specialist: Oracle General Ledger certification will help you build a functional foundation in E-Business Essentials. Certify your ability to access and navigate the R12 E-Business Suite, enter data, retrieve information in the form of a query and access online help to give yourself an edge against other candidates in the job market.

You will also develop a deeper understanding of Oracle General Ledger. Building these skills will allow you to perform simultaneous accounting for multiple reporting requirements and access and process data for multiple ledgers and legal entities at the same time. This is done using the power of ledger sets. OPN Members earning this certification will be recognized as OPN Certified Specialists, which helps their companies qualify for the Oracle E-Business Suite Financial Management Specialization.

Prepare to pass the Oracle E-Business Suite R12.1 General Ledger Essentials exam with a thorough understanding of key topics like General Ledger setup, journal entries, consolidation, and reporting. Practice with relevant study materials to ensure success on your certification journey.

Enhance your skills by mastering essential concepts such as multi-currency, budgeting, and period close processes in Oracle E-Business Suite R12.1 General Ledger. Gain hands-on experience with General Ledger functionalities to effectively manage financial operations. With dedicated preparation, you’ll be ready to ace the certification exam.

Exam topics covered

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

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