11i Financials Functional Foundation

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.This course will also teach the Applications Basics and will center on how to use the basic Applications tools to find information, as well as describe concurrent processing, flex fields, alerts, and Oracle Workflow Builder. Students will learn how to read and understand Entity Relationship Diagrams (ERDs), and Oracle Applications' Applications Technology ERDs.This course will convey the benefits of using open interfaces and how they are utilized in Oracle Applications, the basic importing needs, and the Oracle Applications Open Interface Model. This course will also address the standards for using these interfaces.Basic technical functionality of the core Financials applicationsTechnical overview of Oracle General Ledger, Purchasing, Payables, Receivables, Inventory, Order Management, Customers, and AssetsMajor business functions associated with the financial applicationsFlow of application information through major tables

Skills Gained

• Describing the Oracle Financials applications
• Identifying the primary business functions that can be performed using each Oracle Financials application
• Describing the Oracle Financials applications integration and data flow among applications
• Over viewing the default account sources, multi-organization architecture, and the use of Multiple Reporting Currencies

Who Can Benefit

• Database Administrators
• Functional Implementer
• Technical Consultant

Prerequisites

• Knowledge of minimally one Oracle application
• Knowledge of finance and accounting processes and procedures
• Query and display data using SQL*Plus

Syllabus

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