Oracle BI Applications

Oracle BI Applications



    Course duration : 15-20 hours  Version:


    1.     Oracle BI Applications Architecture

    • Oracle BI Applications components overview
    • Oracle BI Applications architecture overview
    • Oracle BI Applications product lifecycle overview

    2.     Installing Oracle Business Intelligence Applications

    • Preinstallation and deployment requirements
    • Installing Oracle BI Applications prerequisites
    • Installing Oracle BI Applications
    • Performing post-installation system set up tasks

     3.    Understanding the ETL Process

    • ETL phases and processing overview
    • Using ODI Studio to explore prebuilt ETL metadata
    • Full ETL and incremental ETL
    • Change capture
    • ETL versus ELTFunctional Configuration for Oracle BI Applications

    4.     Administering and maintaining data load parameters Functional Configuration for Oracle BI Applications

    • Functional configuration overview
    • Terminology related to Oracle BI Applications configuration
    • Configuration Manager overview
    • Functional Setup Manager overview
    • Creating an implementation project
    • Assigning configuration tasks to developers

    5.     Administering and Maintaining Functional Configuration Data

    • Functional configuration data overview
    • Administering
    • Administering and maintaining reporting parameters

    6.     Managing Load Plans

    • Defining, generating, executing, and monitoring load plans
    • Troubleshooting and restarting load plans
    • Managing load plan parameters

    7.     Customizing the Oracle Business Analytics Warehouse

    • Customization types and scenarios overview
    • Overview of category1 and category 2 customizations
    • Impact of patches on customizations
    • Applying an update strategy

    8.     Building a Category 1 Customization

    • Adding columns to existing tables in the OBAW
    • Creating custom ETL mappings for a category 1 customization
    • Enabling versioning for a category 1 customization
    • Generating DDL scripts for a category 1 customization
    • Creating and executing a load plan for a category 1 customization

    9.     Building a Category 2 Customization

    • Adding a new dimension table to the OBAW
    • Creating custom ETL mappings for a category 2 customization
    • Enabling versioning for a category 2 customization
    • Generating DDL scripts for a category 2 customization
    • Creating and executing a load plan for a category 2 customization

    10.     Oracle BI Applications Security

    • Tools used to manage Oracle BI Applications security
    • Oracle BI Applications security levels
    • Exploring default security settings for Oracle BI Applications
    • Exploring ODI security

    Oracle Business Intelligence Applications Online Training

    Total Number of Hours: 20-25Hrs  Version:7964

    1.   Oracle BI Apps Overview

    • What is BI and why organizations need BI
    • BI Architecture
    • Oracle BI Apps Functional Architecture
    • Oracle BI Apps Technical Architecture
    • Analytics supported By BI Apps
    • Overview of Components Involved in BI Apps
    • ETL Architecture
    • Data Extracting and Loading Process
    • OBIA Security Integration

    2.  Oracle BI Apps Installation and Configuration

    • BI Apps Implementation Methodology
    • Pre Requisites (Software and Hardware)
    • Installation Overview(Methodology)
    • Meta Data Configurations
      • OBIEE
      • Informatica
    •  Global Configurations of BI Apps

    3.  Human Resource Analytics

    • Human Resource Analytics specific Configuration
    • Physical Data Model Overview
    • Logical Data Model Overview
    • Configuration points

    4.  Supply Chain Management

    • Supply Chain Management Analytics specific Configuration
    • Physical Data Model Overview
    • Logical Data Model Overview
    • Configuration points

    5.  Financials

    • Financials Specific configuration
    • Physical Data Model Overview
    • Logical Data Model Overview
    • Configuration points

     6.  Naming Standards

    • ETL Naming Standards
    • OBIEE Naming Standards

    7.   Load Strategies

    • Full Load
    • Incremental Loads

    8.    Delete process

    9.    Slowly Chaining Dimensions

    10.   Customization Best Practices

    • Customization Best Practices with real time examples
    • Upgrade Strategies
    • Customization Example
    • Trouble Shooting

    11.     BI APPS Security Implementation

    • Overview on DAC (Data warehouse Administration Console)
    • Architecture
    • Overview on DAC Client
    • Integrating Informatica with DAC
    • Integrating Databases(Physical Data Sources) with DAC
    • Creating Oracle Business Analytics warehouse for BI Apps
    • Source System Containers
    • Development process in DAC
      • Physical Folder
      • Logical Folder
      • Source System Folders
      • Task Phases
      • Subject Areas
      • Execution Plan
      • Task Groups
      • Configuration Tags
    • Source System Parameters and Task Level Parameters
    • Manage the Execution Sequence
    • Scheduling and Email Configurations
    • Managing the Target Table
    • Managing the Index on tables through DAC
    • Managing the Incremental and Full load based on the Refresh Dates.
    • Monitoring of execution Plans
    • Import/export of DAC Metadata
    • Handling ETL Failures with DAC
    • Navigating the  DAC Interface and looking into all options

    Write a Review

    Your email address will not be published. Required fields are marked *

    Course Reviews


    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    • 1 month

    Drop us a query

    Job Support

    Course Features

    Live Instructor-led Classes

    This isn't canned learning. Its dynamic, its interactive, its effective

    Expert Educators

    Only the best or they're out. We are constantly evaluating our trainers

    24&7 Support

    We never sleep. Need something answered at 3 am? No Problem

    Flexible Schedule

    You don't learn as per our calendar. We work according to yours.

    Customized Training's

    The most part self-managed and adaptable to suit a person's particular adapting technology needs

    Priority Based Training's

    Real-time Scenario based Assignments and Case Studies


    This web site or team is not associated with SAP AG or any other product. We are providing this service absolutely for Education and Training purpose only. We charge for the support services only, not for the actual SAP System access. All SAP Systems operate under INITIAL evaluation license. All trademarks mentioned on this web site belongs to their owners. We do not share or distribute ANY personal information we collect on this web site. For any additional information


    +91 9989754807