Oracle BI Applications 7.9.6: Implementation for Oracle EBS Ed 2

Duration : 4 Days (32 Hours)

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

The Oracle BI Applications 7.9.6: Implementation for Oracle EBS Ed 2 course offers an introductory understanding of building and deploying custom analytics solutions using the Oracle BI Applications platform on Oracle E-Business Suite data. Participants will gain insights into the architecture, data modeling, data mapping, and optimization processes involved in designing and implementing analytics solutions. The course also covers security measures and deployment considerations for successful integration with Oracle EBS. By the end of the training, attendees will be equipped to efficiently create complex reports and visualizations, leveraging the library of pre-built analytics to deliver valuable insights from Oracle EBS data.

Intended Audience:

  1. IT professionals and developers responsible for installing and configuring the Oracle BI Application 7.9.6 software.
  2. System administrators and technical team members familiar with Oracle EBS architecture and enterprise applications.
  3. Data analysts and business intelligence professionals interested in understanding the ETL processes and data modeling involved.
  4. Business users and analysts who want to learn how to query data and build dashboards using the Relational Warehouse.
  5. Data integration specialists and developers who need to define sources, targets, and mappings for Data Marts.
  6. BI administrators and support staff who will perform administrative tasks and troubleshoot issues in Oracle BI Applications.
  7. Implementation consultants and project managers involved in deploying Oracle BI Application 7.9.6 for Oracle EBS.

Learning Objectives of Oracle BI Applications 7.9.6: Implementation for Oracle EBS Ed 2:

1. Learn how to install and configure the Oracle BI Application 7.9.6 software.
2. Gain an understanding of the Oracle EBS architecture and architecture of the Oracle BI Applications.
3. Understand the loading processes involved and how to design and manage an ETL Control.
4. Learn how to configure the Relational Warehouse to enable users to query the data and build Dashboards.
5. Understand the connectors and how to define sources, targets, and mappings, and the process to build Data Marts.
6. Become familiar with the Oracle BI Applications tools and how to perform administrative tasks.
7. Learn best practices for Implementation, Troubleshooting and Production Support.
8. Get hands-on experience in configuring and deploying the Oracle BI Application 7.9.6 for Oracle EBS.

 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

Oracle BI Applications 7.9.6: Implementation for Oracle EBS Ed 2 Course Prerequisites:

The course does not have any prerequisites. It is suitable for those who have some familiarity with the Oracle Business Intelligence technology stack and Oracle E-Business Suite.

Discover the perfect fit for your learning journey

Choose Learning Modality

Live Online

  • Convenience
  • Cost-effective
  • Self-paced learning
  • Scalability


  • Interaction and collaboration
  • Networking opportunities
  • Real-time feedback
  • Personal attention


  • Familiar environment
  • Confidentiality
  • Team building
  • Immediate application

Training Exclusives

This course comes with following benefits:

  • Practice Labs.
  • Get Trained by Certified Trainers.
  • Access to the recordings of your class sessions for 90 days.
  • Digital courseware
  • Experience 24*7 learner support.

Got more questions? We’re all ears and ready to assist!

Request More Details

Please enable JavaScript in your browser to complete this form.

Subscribe to our Newsletter

Please enable JavaScript in your browser to complete this form.