R12.x Oracle Financials Functional Foundation

This course will teach you how to use Oracle core financial applications. Expert instructors will help you understand how information flows though the major tables associated with business functions.

Learn To:

• 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.
• 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 the primary business functions of each Oracle Financial application.

Entity Relationship Diagrams

This course 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. Lectures are also supplemented with hands-on practices.

Goals of this Course

At the completion of this course, you'll be able to understand the major business functions associated with Oracle Financials Applications, as well as the associated application technology architecture. You'll identify the primary business functions of each Oracle Financials application; learn the basics of Multi-Org architecture and the use of Reporting Currencies.

Note:

This course is applicable if you've implemented Oracle E-Business Suite Release 12 or Oracle E-Business Suite 12.1.

Audience

• Functional Implementer
• Technical Administrator
• Technical Consultant
• Database Administrators

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 Subledger Accounting and Oracle E-Business Tax

• Introduction to Subledger Accounting
• Subledger Accounting Setup and Process
• Oracle E-Business Tax (eBTax) Description
• Oracle E-Business Tax Key Concepts
• Oracle E-Business Tax Process Flow

Oracle Trading Community Architecture

• Customer Data Management
• Customer Entity Relationship Diagrams (ERD’s) and Related Tables

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 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

Course Objectives

• Use key E-Business Suite tools
• Understand Oracle General Ledger tables, ERDs, and business functions
• Understand Oracle Inventory tables and business functions
• Describe the Oracle Financial applications
• 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
• Understand Oracle Subledger Accounting