R12 Oracle Financials Functional Foundation

What you will learn

Students will learn how to use Oracle core financial applications. They will also learn how information flows though the major tables associated with business functions. This course also covers Entity Relationship Diagrams (ERDs) and the key technology components of the E-Business Suite tools such as security and flexfields. Detailed information about the underlying architecture and tables is provided, and lectures are backed up with hands-on practices.

At the completion of this course, students will be able to understand the major business functions associated with Oracle Financial Applications, as well as the associated application technology architecture.

Learn To:
  • Identify the primary business functions of each Oracle Financial application
  • Describe the flow of application information through the major tables associated with business functions
  • Identify Oracle core financial applications
  • Understand the key technology components of the E-Business Suite
Audience
 Database Administrators
Functional Implementer
Technical Administrator
Technical Consultant

Prerequisites
 Knowledge of minimally one Oracle application
Query and display data using SQL*Plus
Knowledge of finance and accounting processes and procedures
R12 Oracle General Ledger Management Fundamentals
R12 Oracle Payables Management Fundamentals
R12 Oracle Inventory Management Fundamentals
R12 Oracle Purchasing Fundamentals

Course Objectives
 Use key E-Business Suite tools
Understand Oracle General Ledger tables, ERDs, and business functions
Understand Oracle Inventory tables and business functions
Understand Oracle Purchasing tables and business functions
Understand Oracle Payables tables, ERDs, and business functions
Understand Oracle Assets tables, ERDs, and business functions
Understand Oracle Trading Community Architecture tables, ERDs, and business functions
Understand Oracle Order Management tables, ERDs, and business functions
Understand Oracle Receivables tables, ERDs, and business functions
Describe the Oracle Applications Open Interface Model
Describe the Oracle Financial applications

Course Topics
Course Overview
 Identifying the primary business functions that can be performed using each Oracle Financial application
Multi-Org Architecture
Reporting Currencies

ERDs and Applications Technology
 Entity Relationship Diagram (ERD) Definition
E-Business Suite Technology Components
Security and Access Control
Flexfields
Profile Options
Concurrent Processing
Workflow and Business Events
E-Business Suite Tools

Oracle General Ledger
Major Business Functions of Oracle General Ledger
Ledger ERD (Entity Relationship Diagram) and Related Tables
Journal Entry ERD and Related Tables
Budget ERD and Related Tables
Journal Import Process, Related ERD, and Table Structure

Oracle Inventory
 Inventory Transaction Activities
Major ERD’s and Tables Used in Inventory Transactions
Inventory Open Interfaces and Application Program Interfaces

Oracle Purchasing
 Overview of Purchasing Activity From Requisition to Receipt of Goods
Major Tables Used in Purchasing and Receiving
Open Interfaces and Application Program Interfaces

Oracle Payables
Oracle Payables Major Features
Payables Entity Relationship Diagram
Open Interfaces
iSupplier Portal

Oracle Assets
 Asset Setup Entity Relationship Diagrams (ERD’s) and Related Tables
Addition and Mass Addition ERD’s and Related Tables
Depreciation ERD’s and Related Tables
Asset Open Interfaces and Application Programming Interfaces (API’s)

Oracle Trading Community Architecture
 Customer Data Management
TCA Customer Entity Relationship Diagrams (ERD’s) and Related Tables

Oracle Order Management
 Order Management Transactions and Entity Relationship Diagrams (ERDs)
Order Management Application Programming Interfaces (APIs) and Open Interfaces

Oracle Receivables
 Customer Invoice Entity Relationship Diagrams (ERD’s) and Related Tables
Receipt Entity Relationship Diagrams and Related Tables
Oracle Receivables Open Interfaces and Application Programming Interfaces (API’s)
Overview of Oracle iReceivables

Open Interfaces
 Overview of Open Interfaces
Application Open Interfaces
Data Conversion Process

Oracle Applications Architecture
 Oracle E-Business Suite Home Page
E-Business Suite HTML Interface
E-Business Suite Forms Interface
E-Business Suite Concurrent Processing
E-Business Suite Technology Stack
E-Business Suite Database Components
E-Business Suite File System Components

E-Business Suite Navigation
 Terminology
Searching
Concurrent Requests
Flexfields
Profile Options