Download PDF
of this course

R12.x Oracle Financials Functional Foundation (R12.xFFF)

  • Overview
  • Who Should Attend
  • Certifications
  • Prerequisites
  • Objectives
  • Content
  • Schedule
Course Overview

Duration: 5 Days

Price: SGD 5,275.00

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.

 

Who Should Attend

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

Course Certifications

This course is part of the following Certifications:

Prerequisites

Required Prerequisites:

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

Suggested Prerequisites:

  • R12.x Oracle General Ledger Management Fundamentals

 

Course Objectives

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

Course Content

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 ID: R12.xFFF


Show Schedule for 1 Month  3 Months  All 
Date Country Location Register