R12.x Oracle Financials Functional Foundation

Course Description

This course will be applicable for customers who have implemented Oracle E-Business Suite Release 12 or Oracle E-Business Suite 12.1.Students learn how to use Oracle core financial applications. They also learn how information flows though the major tables associated with business functions. 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, and lectures are backed up with hands-on practices.At the completion of this course, students are able to understand the major business functions associated with Oracle Financials Applications, as well as the associated application technology architecture. Students can identify the primary business functions of each Oracle Financials application. They learn the basics of Multi-Org architecture and the use of Reporting Currencies. Students will understand the key technology components of the E-Business Suite.Learn To:Describe the flow of application information through the major tables associated with business functions Identify Oracle core financial applicationsUnderstand the key technology components of the E-Business SuiteIdentify the primary business functions of each Oracle Financial applicationDescribe the flow of application information through the major tables associated with business functionsIdentify the primary business functions of each Oracle Financial application

Skills Gained

• 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

Who Can Benefit

• 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

Syllabus

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