Oracle - Course Details

11iFFF 11i Financials Functional Foundation

Oracle Course Description:
In this course, students will learn the basics regarding the table functionality of the core Oracle Financials Applications, including Oracle General Ledger, Oracle Purchasing, Oracle Payables, Oracle Inventory, Oracle Receivables, Order Management, and Oracle Assets, and will focus on identifying the flow of application information through the major tables and describe the resultant major business functions associated with these Applications.
Oracle Course Duration:
5 DAYS
Oracle Course Target Audience:
Database Administrators,Functional Implementer,Technical Consultant
Oracle Course Prerequisite:
Knowledge of minimally one Oracle application,Knowledge of finance and accounting processes and procedures,Query and display data using SQL*Plus
Course Content:
  • Course Overview

    • Oracle Financial applications
    • Primary business functions
    • Oracle Financials Applications Integration
    • Data Flow Among Applications
    • Default Account Sources
    • Multi-Org Architecture
    • Multiple Reporting Currencies

  • Applications Basics

    • Basic Applications tools
    • Applications Security model
    • Concurrent processing
    • Flex fields
    • Alerts
    • Workflow

  • ERDs and Applications Technology

    • Entity Relationship Diagrams (ERDs)
    • Applications Technology ERDs

  • Oracle General Ledger

    • Major business functions of Oracle General Ledger
    • Oracle General Ledger entity relationship diagrams related to its major functions
    • Major tables by business function

  • Oracle Inventory

    • Inventory transaction activities
    • Major tables used in inventory transactions
    • Open interfaces and application program interfaces for inventory

  • Oracle Purchasing

    • Purchasing activity from requisition to receipt of goods
    • Major tables used in purchasing and receiving
    • Running a query in SQL*Plus against the appropriate database tables to review a purchase order and receipt for a given item
    • Open interfaces and application program interfaces for purchasing

  • Oracle Payables

    • Oracle Payables entity relationship diagram
    • Major tables by business function
    • Major columns in each of the major tables
    • Supplier Open Interface
    • iSupplier Portal

  • Oracle Assets

    • Oracle Assets entity relationship diagram
    • Major tables by business function
    • Major columns in each of the major tables

  • Oracle Order Management

    • Order Management process flow
    • Major tables used in Order Management
    • Open interfaces and APIs for Order Management

  • Oracle Receivables

    • Process by which Oracle Receivables generates customer invoices and manages customer receivables
    • Oracle Receivable entity relationship diagrams
    • Major tables by business function and the major columns
    • Process by which Receivables data is transferred to the general ledger
    • Deduction Management and Oracle iReceivables

  • Open Interfaces

    • Benefits of using open interfaces
    • Oracle Applications Open Interface Model
    • Managing your open interface processing

  • Development Topics

    • Interface options available within Oracle Applications
    • Solid standards for using these interfaces

  • Applications Architecture

    • Oracle E-Business Suite homepage
    • Self-Service interface
    • Professional interface
    • Architectural, database, and file system components
    • Oracle Applications and the Applications Technology stack
    • Component Applications
    • Product Dependencies