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