Course : Oracle Financials

Course ID: DB-ORFA
Prerequisites:Database, SQL and Application ge Concepts

Section- 1

11i eBusiness Suite Navigation & Essentials for Implementers

Application Navigation:
  • Understand the architecture of eBusiness Suite
  • Understand benefits of eBusiness Suite
  • Describe the key business flows and integration among products in the eBusiness Suite.
  • Describe the core financial and other related products.
  • Introduce to web resources (OTN…)
  • How to access (Log on and off) and navigate within Oracle Applications?
  • Use forms, menus and tool bar.
  • Learn to enter data, retrieve information in the form of a query, maintain data, and how to use online help.
  • SRS (standard report submission), Monitoring and concurrent processing.
  • Personal user profile options
  • Using form attachments.

Section- 2

Essential Concepts:
  • Identify the components that comprise an Oracle Application system
  • Explain basic application integration Identify Entities that are shared between multiple applications and how they shares information between Applications
  • Explain basic System Administration terminology
  • Explain how profile options work
  • Define key and descriptive flexfields
  • Customize the presentation of data using folders
  • Explain the Multi-Org structure
  • Multi-Org organizational model
  • Data security by application
  • Cross organization reporting
  • Explain reporting options in Multi-Org
  • Explain the basic components of workflow and Workflow Builder.
  • Identify the role of workflow as it relates to Oracle Applications, Notification System and Directory Services.
  • Explain basic alert terminology
  • Understand difference between Oracle Workflow and Oracle Alerts
  • DBI (Daily Business Intelligence) with E-Business Suite
  • Release 11i10 footprint

Section- 3

11i Financial Applications Overview

  • General Ledger Overview
    Set of Books
    Journal Entries
    Multi-Currency Functionality

  • Payables Overview
    Expense Reports
    Expense Report Processing and iExpenses
    Invoice Payments
    Payables Transfer to GL
    Daily Business Intelligence
    Oracle iSupplier Portal Invoices
    Supplier and Supplier Site
    Invoice Approval and Validation

  • Receivables Overview
    Autoinvoice/Manual Invoices
    Invoice API
    GL Interface
    Daily Business Intelligence
  • Assets Overview
    Asset Books
    Manual and Quick Additions
    Mass Additions
    Asset Adjustments
    Group Assets
    Journal Entries
  • Business Suite Overview
    Key Business Flows/Forecast to Plan
    Procure to Pay
    Demand to Build
    Campaign to Order/Click to Order/Order to Cash
    Contract Renewal
    Request Resolution
    Project to Profit
    People to Paycheck
  • Procure to Pay Overview
    Procure to Pay Flow/Purchasing Integration
    Procure to Pay Lifecycle/Oracle Procure to Pay Process
    RFQs and Quotations/Requisitions
    Purchase Orders
  • Suppliers Overview
    Enter/Update Supplier Base
    Key Reports
    Merge Suppliers
    Implementation Considerations
    New feature in 11i10
  • Purchasing Overview
    Purchasing Process/Purchasing Integration
    Procurement Integration
    Purchase Requisitions/Request for Quotations (RFQ)
    Sourcing Rules
    Purchase Orders
    Oracle Advanced Pricing Integration Implementation Considerations
    New feature in 11i10
  • Order to Cash Overview
    Order Processing
    Shipping Execution
  • Customers Overview
    Profile Classes
    Customer Information
    Customer Account Relationships
    Merge Parties or Customer Accounts
    Implementation Considerations
    New feature in 11i10
  • Order Management Overview
    Order Entry/Order Scheduling and Booking
    Drop Shipment, Internal Orders, Order Import, Configurator
    Order Management
    Daily Business Intelligence
    New Features for 11i10
  • Internet Expenses Overview
    Lease Management in the Oracle E- Business Suite
  • Internal Controls Manager Overview
    Benefits of Oracle Internal Controls Manager

Section- 4

Oracle General Ledger

  • Overview
    Identify the General Accounting Process utilizing the Oracle eBusiness General Ledger Application Identify the steps required to complete the Accounting cycle using Oracle General Ledger Understand how Oracle General Ledger integrates with other Oracle eBusiness applications Understand the major functional areas contained within Oracle General Ledger Anatomy of an Oracle budget Identify Key implementation issues
  • Set of Books
    Chart of Accounts Overview
    Creating a Chart of Accounts
    Calendar and Currency
    Creating a Set of Books
    Identify the elements required to create a Set of Books within Oracle General Ledger
    Understand the attributes, options and required settings to define the Accounting Flexfield
    Using Hierarchical Security Support
    Define accounting calendars
    Enable predefined currencies
    Define a General Ledger Set of Books
    Utilize the ADI Account Hierarchy Editor to view and maintain accounting flexfield values
    Identify the key implementation issues regarding creating a Set of Books in Oracle General Ledger Using Account Hierarchy Manager
    Using Enhanced Account Hierarchy
    Manager Security
    Using the Consolidation Enhancements for Alternative Accounting Representations
  • Journal Entries
    Understand where journal entries are positioned in the accounting cycle
    Identify the types and components of journal entries
    Account Inquiry
    Enter manual journal entries
    Reversing Journal Entries
    Post journal entries using various available options
    Using Journal Reference Date
    Perform an account inquiry
    Drill down to Oracle subledger applications
    Reverse journal entries
    Use the ADI Journal Wizard to create journal entries
    Import journal entry information using the GL_INTERFACE
    Identify the Setup Options to process journal entries
    Identify reports, listings and inquiry options available for journal entries
    Segment Value Security for Journals Reports
    Identify the Profile Options necessary to process journal entries
    Identify the Key Implementation issues regarding Oracle General Ledger journal entries
  • Multi-Currency
    Identify where Multi-Currency is positioned within the Oracle General Ledger business flow
    Define additional currencies
    Define conversion rate types and enter conversion rates
    Understand the Oracle General Ledger revaluation process and the streamlined revaluation process
    Understand the Oracle General Ledger translation process
    Identify reports and listings available regarding Multi-Currency
    Identify Profile Options settings required to process multiple currencies
    Identify the Key Implementation issues regarding Oracle General Ledger multiple currencies
  • Intercompany and Global Intercompany System (GIS)
    Set up and use intercompany balancing
    Set up and use global Intercompany system
  • Consolidations
    Identify where Consolidations is positioned within the Oracle General Ledger business flow
    Identify the features and functionality of the Global Consolidation System (GCS)
    Understand the elements of the Consolidation Workbench
    Process consolidation elimination entries
    Identify consolidation reports and inquiries available
    Identify the key implementation issues regarding Oracle General Ledger consolidations
  • Budgeting
    Identify the key elements of the Oracle budgeting process
    Define a budget
    Create budget organizations
    Using the ADI Budget Wizard to enter budget amounts
    Perform budget inquiries
    Identify budget reports and listings
    Identify the key implementation issues regarding Oracle General Ledger budgeting

  • Encumbrance Accounting
    Encumbrance accounting concepts, setup and implementation.
  • Financial Reporting
        Financial Reporting Overview, Financial Reporting Options, FSG Required Compenents,
    FSG Optional Compenents and FSG Reprting Options.
    Identify the basic report building concepts
    Create basic FSG report definitions
    FSG Hierarchical Security Support
    FSG Report Set Enhancements
    Fiscal Year-End Amount Type in FSG Reports
    Utilize the report wizard of ADI to create FSG report definitions
    Identify the key implementation issues regarding Oracle General Ledger financial reporting
  • ADI
    Application Desktop Integrator Journal Entries ADI Account Hierarchy Editor, Set up ADI security and applications
    database linking
    Set up the ADI toolbar, general and language options
    Identify profile options available in ADI
    Perform diagnostic system checks for ADI
  • Financial Reporting Options
    Understand the financial reporting options available in the Oracle eBusiness Applications
    Identify the capabilities and differences between the various financial reporting options

Secton- 5

Oracle Payables 11i

Procure to Pay Lifecycle Overview

Describing the procure to pay process flow
Describing the key areas in the procure to pay process
Describing how the procure to pay process fits into the Oracle eBusiness suite of applications
Understand the Payables process flow within the Oracle eBusiness suite of applications

Payables Overview

Describing the Payables process flow and Identify the key areas in the Payables process
Identifying Payables integration points
Identifying Payables open interfaces


Understand how Oracle products use supplier info'
Defining suppliers
Defining supplier sites
Identifying key reports
Using setup options
Identifying implementation considerations


Entering invoices and invoice distributions
Import invoices or invoice information to create invoices in Payables
Applying prepayments and advances
Matching invoices to purchase orders
Applying and releasing holds
Understanding invoice approval workflow
Validating invoices for payment
Enter expense report templates

Quick Invoices

Using Quick Invoices
Entering invoice records
Entering purchase order matched invoice records
Entering price corrections
Finding and modifying invoice records
Adding invoice records
Creating invoices from invoice records


Describing the process of issuing payments
Setting up bank accounts
Processing single payments

Processing payment batches

Processing stop and void payments
Reconcile accounts payable transactions for the period

Expense Reports and Credit Cards

Describing the expense report process
Entering expense report templates
Entering expense reports
Applying advances
Identifying key expense related reports
Setting up credit card programs

Period Close

Describing the period closing process in Payables and Purchasing
Reconciling accounts payable transactions for the period

Invoice Tax

Setting up supplier tax information
Describing supplier and supplier sites regions
Identifying tax validations
Entering taxes on invoices
Identifying tax types, tax codes, and tax groups
Submitting invoice validations
Using tax control methods
Identifying tax code defaults
Identifying the withholding tax process
Using withholding tax options
Processing manual withholding tax invoices
Creating withholding tax invoices
Processing automatic withholding tax invoices

Section- 6

11i Oracle Receivables

Overview of Oracle Receivables Process

Overview of Receivables Process Describe the overall order to cash process lifecycle, from Order Entry through Bank Reconciliation. Discuss the key areas in the Order to Cash Life Cycle Overview of the Transaction Process
Overview of Other Invoice Operations
Overview of Adjustments
Overview of the AutoInvoice Process
Overview of the Receipts and Remittances Overview of Collections and Tax Describe Bank Reconciliation and Understand Cash Forecasting

Manage Parties and Customers Accounts

Party Model Overview
Profile Classes
Multiple Sites and Business Purposes: Centralized and Decentralized Example
Data Quality Management
Dun & Bradstreet Integration
Merge Parties or Customer Accounts
Required Setup Steps for Customers

Order to Cash Lifecycle Overview

Order to Cash Lifecycle Overview
Over of Application Integration
Customer Entry Methods
Order Management Process
Pricing Process
Shipping Process
AutoInvoice Process
Receivables Process

Process Invoices

Oracle Receivables Overview
Transaction Overview
Invoice Entry Methods
Entering Sales Credits
Creating Invoice Batches
Creating Debit Memos and Creating Adjustments
Voiding Transactions
Reports and Printing Transactions

Process Invoices Using AutoInvoice

AutoInvoice Process and Integration
Defining Transaction Batch Sources
Defining Transaction Flexfields
Determining Tax Liability
Managing AutoInvoice System Options
Correct Errors Overview
AutoInvoice Exception Handling Windows

Implement Customer Invoicing

Required Setup Steps for Transactions
Auto Accounting
Payment Terms
Remit-to Addresses
Accounting Rules
Setting Up Document Sequencing
Setting Up Gapless Transaction Numbering
Consolidated Billing Invoices

Manual Receipts

Overview of Receipts
Creating Batches
Applying Receipts to an Invoice
Criteria for Mass Applying Receipts
Applying Cross Currency Receipts
Entering Discounts

Implement Receipts

Overview of Receipt Setup
Types of Receivables Activities
Receipt Class, Payment Method and Bank Account Relationship
Defining Bank Accounts
Defining Receipt Classes
System Options for Accounting
Profile Options
Functional Security

Tax Accounting Process

Order Management Global Taxes Overview
Receivables Global Tax Overview
Value Added Tax Overview
US Sales Tax Overview
Tax Partner Process Overview
Other Taxes in Oracle Applications
Tax Setup Steps
Defining Tax Preferences, Defaults and Rules

Period Close Process

Period Closing Process
Overview of Ordering to Period Closing
Standard Reports
Reconciling Inventory Transactions
Running Revenue Recognition
Transferring to the General Ledger
Running the Journal Import Program
Mapping Receivables Transactions to General Ledger Categories

Section- 7

System Administrator

Oracle Applications Security

Function Security


Data Security


Oracle User Management

Delegated Administration
Registration Processes

Auditing System Resources

Sign On Audit
Audit Trail

System Management using Oracle Applications Manager

Monitoring the System
Diagnostics and Troubleshooting

Managing Concurrent Programs and Reports

Administering Concurrent Managers

Generic Service Management
Defining a Concurrent Manager
Work Shifts
Parallel Concurrent Processing

Managing Profile Options

Managing Printers

Form Personalization
Oracle Applications Framework Personalization

Section- 8

Application Object Library (AOL)

Overview of AOL.

Overview of Application Object Library and developers responsibilities.

Oracle Workflow

Defining Workflow Processes

Planning a Workflow Process
Diagramming a Workflow Process
Defining Item Type Attributes and Lookup Types
Defining Messages and Notification Activities
Defining Function Activities
Defining Event Activities

Monitoring Workflow Processes

Testing Workflow Processes
Reviewing the Status of Workflow Processes

Viewing and Responding to Notifications

Extending Oracle Applications

OA Framework
Review Forms and Reports Customizations.
Custom Library.How to extend Oracle Applications without customization, the million dollar question?

Upgrading Oracle Applications.

Upgrade an existing Oracle Applications installation to Release 11i
Determine the pre upgrade setup tasks required for an upgrade
Perform post-installation setup tasks

Daily Business Intelligence

Overview of Oracle DBI. Illustrate how to create custom dashboards, reports, KPIs, and dimensions.

SOA and Oracle Fusion:

Overview of Oracle SOA architecture.
Overview of Oracle Fusion.
Future directions of Oracle E-Business Suite.


Each Day includes Theory and Lab practice

  • Examples based on theory
  • Exercises