Oracle Applications 11/11i: Financials & Administration
Back to Main Page

Course Description

In this course, the trainee will be introduced to the architecture and components of Oracle Applications. The trainee is exposed to the systems administration tasks and activities of Oracle applications on the technical side and on the functional side, the financial modules like General Ledger (GL), Accounts Payable (AP) and Accounts Receivable are covered.

Course Objectives

Intended Audience

Prerequisites

Course Contents

Architecture and Administration of

Oracle Applications

A. Overview of Oracle Applications

  • Overview and architecture of Oracle Applications and typical installation

B. Components of Oracle Applications

  • User interface components
  • Concurrent processing
  • Flexfields: Types and Usage
  • Additional tools and help system

C. Usage of Oracle Applications

  • Navigation principles
  • Data entry and retrieval methods
  • Customizing data access and profiles
  • Submit reports and concurrent programs

D. Application Security

  • Create users and responsibilities
  • Define data groups
  • Customize Menus

E. Manage Concurrent Programs, Reports and Managers

  • Report groups and sets
  • Concurrent programs and processing
  • Define concurrent managers
  • Manage processing files and tables

F. Manage Printer and Profiles

  • Customize and Manage printers
  • Manager User and system profiles

Oracle Payables

A. Defining Oracle Payables

  • Defining quick codes, terms and tolerances for invoice processing
  • Defining payment processing
  • Processing expense reports
  • Defining financial and system options
  • Defining open periods
  • Defining report sets and formats

B. Vendor Management

  • Enter and manage vendor information
  • Review and merge vendors
  • Creating reports on vendors

C. Invoice Processing

  • Processing invoices
  • Batch invoices
  • Details of invoice payments
  • Petty cash management
  • Invoice matching to purchase orders
  • Expense reports
  • Importing invoices
  • Approval issues in invoicing
  • Inquiry into invoices
  • Reporting on invoices

D. Invoice Payments

  • Invoice payments: Methods and Schedules
  • Payments batches
  • Manual payments
  • Payment reconciliations
  • Defining quick codes, terms and tolerances

E. Journal Entries

  • Creating a set of books
  • Opening and closing accounting periods
  • Entry and transfer of accounting details
  • Review posted invoices and payments
  • Review unposted journal entries
  • Intercompany accounting

F. Prepayments

  • Identification and processing of prepayments
  • Choosing and applying prepayment types
  • Employee advances processing
  • Monitor and adjust prepayments

G. New Feature of Release 11i

Oracle General Ledger

A. The Accounting Cycle

  • Complete the accounting cycle
  • Create and review journal entries
  • Reporting on journal details
  • Balance translations

B. Journal Entries

  • Enter manual and statistical journals
  • Journal import
  • Reversal of journals
  • Mass allocations
  • Convert foreign journals

C. Budgeting

  • Define budgeting Periods
  • Post and review budgeting journals
  • Enter budget rules and formulas
  • Mass budget journals and formulas
  • Master/detail budgets

D. Setting Up of General Ledger

  • Create value sets and qualifiers
  • Cross-validation rules
  • Defining accounting segments and hierarchies
  • Defining currencies and accounting calendar
  • Chart of accounts and suspense accounts
  • Translations and Revaluations
  • Consolidate Set Of Books
  • Journal Import
  • Automatic Posting

Oracle Receivables

A. Define Receivable Types

  • Define Transaction Types
  • Define Sales People
  • Define Tax Codes & Rates
  • Define Tax Table Relationship with General Ledger

B. Set up Financial systems

  • Set up books
  • Setup systems options
  • Profile options set up
  • Quick codes creation
  • Document sequence

C. Customer Management

  • Customer Profiles and Options
  • Customer Master Records
  • Inquiry and Reporting on Customer Accounts
  • Customer relationships and Merge
  • Adjustment Approval Limits

D. Transactions

  • Set up transaction info.
  • Enter and process invoices
  • Enter & apply payments
  • Set up collection method
  • Enter activities & follow up

E. Cash Management

  • Remittance Banks
  • Details of Receipts – Classes and Sources
  • Cash Receipts Posting and Sources

F. New Feature of Release 11i