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

·       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