11i Financials Functional Foundation

Prerequisites:

- Knowledge of minimally one Oracle applicatios
- Query and display data using SQL*Plus
- 11i Navigate Oracle Applications

Recommended:

- Knowledge of finance and accounting processes and procedures
- 11i Financial Applications Overview
- 11i System Administrator Fundamentals

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.

Course Objectives

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

Who Should Attend

- Database Administrators
- Technical Consultants
- Functional Implementers

Please call for course dates.

This course includes the following modules:

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