Introduction

R12.x Oracle Financials Functional Foundation This course covers Entity Relationship Diagrams (ERDs) and the key technology components of the E-Business Suite tools, such as security and flex fields.

Prerequisties

• All attendees should have a basic knowledge of Fundamentals of System Administration.

Course Content

1. Course Overview

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

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

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

4. Oracle Inventory

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

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

6. Oracle Payables

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

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

8. Oracle Trading Community Architecture

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

9. Oracle Order Management

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

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

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

12. E-Business Suite Navigation

• Terminology
• Searching
• Concurrent Requests
• Flexfields
• Profile Options