Oracle BI Applications 7.9.6: Implementation for Oracle EBS Ed 2

Oracle BI Applications 7.9.6: Implementation for Oracle EBS Ed 2 Certification Training Course Overview

Oracle BI Applications 7.9.6: Implementation for Oracle EBS Ed 2 training course is designed for implementation team members responsible for performing extract, transform and load (ETL) routines from Oracle E-Business Suite (EBS). This course provides step-by-step procedures for installing, designing, customizing and configuring Oracle Business Intelligence (BI) Applications and Oracle Business Intelligence Warehouse (OBAW).
  • Administrator
  • Analyst
  • Architect
  • Developer
  • Implementer

Oracle BI Applications 7.9.6: Implementation for Oracle EBS Ed 2 (32 Hours) Download Course Contents

Live Virtual Classroom 1700
Group Training Date On Request
1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here
Hire Our Trainers! Click here

Course Modules

Module 1: Oracle Business Intelligence Applications Overview
  • Exploring Oracle Business Intelligence (BI) Applications
  • Exploring the key components of Oracle BI Applications
  • Exploring Oracle BI Applications integration with transactional applications
Module 2: Oracle Business Intelligence Applications Architecture Overview
  • Exploring the Oracle BI Applications logical architecture
  • Exploring the process flow of building the data warehouse
  • Employing the recommended deployment options to maximize data warehouse performance
  • Exploring the core components supporting the Oracle Business Analytics Warehouse (OBAW) and the functions performe
Module 3: Oracle Business Analytics Warehouse Content
  • Exploring the content of the Oracle Business Analytics Warehouse (OBAW)
  • Exploring OBAW tables
Module 4: Installing and Configuring Oracle BI Applications and Related Components
  • Identifying the installation prerequisites
  • Configuring DAC
  • Configuring Informatica Workflow Manager
Module 5: Understanding the ETL Process
  • Exploring the extract, transform, and load (ETL) process used to load the Oracle Business Analytics Warehouse (OBAW)
  • Identifying the differences between a full load and an incremental load of the OBAW
  • Identifying the applications and mechanisms used to support the ETL process
Module 6: Working with Informatica Designer
  • Identifying the Informatica repository objects used to configure the Oracle Business Analytics Warehouse (OBAW)
  • Navigating the set of tools in Informatica Designer used to configure Informatica repository objects
Module 7: Working with Informatica Workflow Manager
  • Navigating Informatica Workflow Manager
  • Running workflows and sessions using Informatica Workflow Manager
  • Monitoring workflows using Informatica Workflow Monitor
Module 8: Exploring SDE and SIL Mappings
  • Describing the differences between Source Dependent Extract (SDE) and Source Independent Load (SIL) mappings
  • Identifying typical objects and their mechanics in SDE and SIL mappings
Module 9: Working with the Data Warehouse Administration Console (DAC)
  • Using the tools and views of the Data Warehouse Administration Console (DAC)
  • Describing DAC objects, how they relate to each other, and their roles in the Oracle Business Analytics Warehouse (OBA
Module 10: Configuring Analytical Applications
  • Performing preload configuration steps that apply to Oracle Business Intelligence Applications deployed with any source
  • Configuring general ledger account hierarchies using general ledger accounting flexfield value set definitions
  • Mapping Oracle general ledger natural accounts to group account numbers
  • Creating a new metric in the repository after adding a new group account number
Module 11: Customizing DAC Metadata and Running and Execution Plan
  • Creating custom metadata objects in the DAC
  • Running a DAC execution plan and monitoring the results
Module 12: Customizing the Oracle Business Analytics Warehouse (OBAW)
  • Identifying and describing customization types and scenarios associated with OBAW
  • Applying OBAW customization best practices
Module 13: Adding Columns to an Existing Dimension Table
  • Completing the steps in a Type I customization of the OBAW
  • Adding a column to an existing dimension table in the OBAW and populating it with data
Module 14: Adding a New Dimension in OBAW
  • Performing the customization steps for adding a new dimension to the Oracle Business Analytics Warehouse
Module 15: Integrating Security for Oracle BI Applications
  • Exploring the types of security in Oracle Business Intelligence Applications
  • Describing how Oracle BI integrates with the Oracle Fusion Middleware security platform
  • Identifying how BI Application object and data security integrate with EBS responsiblities
Module 16: Managing OBAW Performance
  • Exploring strategies for increasing extract, transform, and load (ETL) and query performance
  • Identifying common performance bottlenecks
  • Configuring servers to optimize ETL and query performance
Download Course Contents

Request More Information

Course Prerequisites
  • Working knowledge of Informatica PowerMart or PowerCenter
  • Basic knowledge of SQL
  • Experience in Business Intelligence
  • Knowledge of Dimensional modeling, and database design

Upon completion of this course; you will be able to:

  • Customize and extend the OBAW
  • Manage the security and performance of Oracle BI Applications
  • Customize DAC metadata
  • Explore Oracle Business Intelligence Applications foundational concepts and architecture
  • Install and configure Oracle BI Applications
  • Explore the prebuilt extract, transform, and load (ETL) metadata for Oracle BI Applications
  • Use the Data Warehouse Administration Console (DAC) to run ETL routines to populate the OBAW
  • Explore Oracle Business Analytics Warehouse (OBAW) foundational concepts and architecture