Monday, 25 July 2016

Oracle DBA LIVE DEMO @ APEX [ By Real Time Expert ] for online trainnig

Oracle DBA LIVE DEMO @ APEX [ By Real Time Expert ]
Tuesday, July 26, 2016
11:00 pm  |  India Time (Mumbai, GMT+05:30)  |  1 hr
USA TIME : Same day, @ 12:30 pm CST or 1:30 pm EST

FOR FREE DEMO contact us at:

Email :

Phone/WhattsApp : +91-(868) 622-2553 

Friday, 22 July 2016

Oracle Apps DBA online training New batch starting from next week Real time training by working faculty ...


FOR FREE DEMO contact us at:

Email :

Phone/WhattsApp : +91-(868) 622-2553 


  1. Instructor lead online training by Real time working faculty   

  2. Software  or lab access will be provided for unlimited hours

  3. Good quality Material will be provided

  4. Real time assignments to get hands on experience 

  5. Interview and job oriented training by exceptionally good trainers 

​Course Content ​​   

Infrastructure setup

  • Installation of Virtual workstation

  • Installation of OEL Operating system

  • OEL Oracle Enterprise Linux

  • Disk Druid configuration

  • Manual partitions

  • Assigning  static ip to Ethernet

  • Time zone selection

  • Root user password configuration

  • Packages selection

  • Post installation configuration

  • Login to the OS

  • Installing Virtual tools

  • Sharing of Folders from host OS to virtual OS

  • Cloning of OS in virtual workstation

  • Start and Shut of OS

Pre installation configuration

  • EBS software stage

  • Db tier

  • Apps tier

  • Edit the host file

  • Group creation

  • User creation

  • Ownership permission

  • Set password

  • Rpms installation

EBS single node installation

  • Execute the rapid wiz

  • Install Oracle application

  • New configuration port no

  • Database node configuration

  • Select necessary options

  • Final installation

  • Post installation steps

  • Bash profile configuration

  • DB tier bash profile

  • Apps tier bash profile

  • Login to url

  • verify

EBS multi node installation

  • Prepare the 2 node OS

  • Perform pre installation

  • Execute rapid wiz on first node

  • Select db tier node

  • Select Apps tier node

  • Edit services

  • OPMN

  • Web entry point

  • Web application services

  • Batch process service

  • Other service

  • run the rapid wiz on 2nd node

  • Save load configuration file

  • Bash profile configuration

  • Login to URL

  • Verify

EBS File system

  • Database environment file

  • Db context file

  • control scripts

  • C,R,D files

  • Application environment file

  • context file

  • Db connectivity file

  • control scripts Apps tier

  • AD utilities

  • Apache server configuration file

  • Form sever configuration file

Manage EBS Service

  • Db tier service

  • Traditional method

  • Control script service

  • Listener service

  • Apps tier service

  • Apps Control scripts

  • Individual service

  • Apache server

  • Forms server

  • CMS server

  • Application listener

  • OPMN Service

  • OC4J Service

  • OC4J oacore - html based

  • OC4J forms

  • OC4J oafm - web service

  • Oracle http service


  • Patch concepts

  • one of patch

  • single patch

  • mini patch

  • family patch

  • maintenance patch pack

  • Pre requisite patch

  • Patch tool kit

  • adpatch,adctrl,adadmin.adautocfg,admrgpch

  • Maintenance mode

  • Apply the patch

  • Driver file

  • Disable maintenance mode

  • Verify patch

  • Merging patch concept

System Admin

  • User creation

  • Password reset

  • Account lock and unlock

  • Profile

  • Assign profile to users

  • Monitor application users

  • Terminate application user

  • Create responsibility

  • Assign responsibility to user

  • Compile custom application

  • Printer configuration

  • Ad admin

  • Auto config

  • Custom manager

  • Report

  • Request set


  • Online and Offline cloning

  • Multiple scenario

  • Single node to single node

  • single node to multi node

  • multi node to single node

  • multi node to multi node

  • Verify

  • Db tier adpreclone

  • Apps tier clone

  • Prepare the target system

  • pre configuration

  • Run

  • Copy db tier and apps tier

  • tar statement

  • perform

  • Monitor statement

  • Bash profile configuration

  • Post cloning steps

  • Verify

Up Gradation

  • Ebs upgrade from 11i to R12

  • Prepare 11i ebs system

  • db 9i to 10g

  • Apps 11i to R12

  • Apply latest IOP

  • Apply AD Patch

  • Apply IOP patch

  • Install 10g software

  • configure env file

  • apply patch set

  • Run dbua to upgrade

  • Enable autoconfig

  • Listener config

  • start application service

  • Test application

  • Apps tier upgrade

  • Run rapdiwiz R12

  • upgrade file system

  • startup with R12

  • Apply R12 AD Patch

  • Apply maintenance patch pack

FOR FREE DEMO contact us at:

Email :

Phone/WhattsApp : +91-(868) 622-2553 

Teradata DBA | Developer instructor lead online training from India and USA


Online training by Best institute at Best price - Real time working faculty

FOR FREE DEMO contact us at:

Email :

Phone/WhattsApp : +91-(868) 622-2553 


  1. Instructor lead online training by Real time working faculty   

  2. Software  or lab access will be provided for unlimited hours

  3. Good quality Material will be provided

  4. Real time assignments to get hands on experience 

  5. Interview and job oriented training by exceptionally good trainers 

Courses offered in Teradata  

  • Teradata DBA online training
  • Teradata Developer online training 

FOR FREE DEMO contact us at:

Email :

Phone/WhattsApp : +91-(868) 622-2553 


Thursday, 21 July 2016

Best Hyperion online training by expert from India

Hyperion  Online training by Best institute at Best price - Real time working faculty

FOR FREE DEMO contact us at:

Email :

Phone/WhattsApp : +91-(868) 622-2553 


  1. Instructor lead online training by Real time working faculty   

  2. Software  or lab access will be provided for unlimited hours

  3. Good quality Material will be provided

  4. Real time assignments to get hands on experience 

  5. Interview and job oriented training by exceptionally good trainers 

Course Content 

Hyperion course offered -


2.      Hyperion Financial Data Quality management

3.      Hyperion Financial Reporting

4.      Hyperion Planning  




Hyperion Course content for All 4 courses

1.     HYPERION ESSBASE course content  

· Essbase Overview

- Multidimensional Analysis

- Oracle's Enterprise Performance Management System

- Essbase

- Production Environment Components

· Designing Applications and Databases

- Creating Applications and Databases

- Creating Outlines

· Designing Data Descriptor Dimensions

- Data Descriptor Dimensions Overview

- Designing Time Dimensions

- Designing Scenario Dimensions

- Outline Calculations

- Designing Accounts Dimensions

- Testing Outline Calculations

· Optimizing Data Descriptor Dimensions

- Creating Member Aliases

- Dimension Types

- Creating Period-to-Date Totals

- Dynamic Calc Members

- Enhancing Accounts Dimensions

- Optimizing Data Storage

· Developing Dimension Designs

- Business View Dimensions Overview

- Attributes in Database Design

- Combining Business Views

- Developing Label Outlines

· Creating Basic Dimension Build Rules Files

- Rules Files Overview

- Creating Dimension Build Rules Files

- Configuring Dimension Maintenance Settings

· Creating Advanced Dimension Build Rules Files

- Advanced Dimension Build Rules Files Overview

- Creating Shared Members

- Manipulating Fields

- Creating User-Defined Attributes

- Creating Attribute Dimensions with Rules Files

· Loading Data

- Data Load Overview

- Creating Data Load Rules Files

- Selecting and Rejecting Records

- Capturing New Members

· Getting Started with Smart View

- Navigating Smart View

- Connecting to Data Sources

- Creating Ad Hoc Grids

- Setting the Point of View

- Associating Data Sources with Worksheets

- Creating Free-Form Grids

· Creating Reports with Smart View

- Updating Essbase Data

- Integrating Essbase Data with Microsoft Office

- Creating Shared Database Perspectives


2.     Hyperion Financial Reporting  course content  

1.Financial Reporting Overview

•Oracle's Enterprise Performance Management System

•Oracle's BI Suite Enterprise Edition Plus

•Financial Reporting Features and Architecture

•Financial Management Data Sources

2.Navigating Reports in Workspace

•Workspace Overview

•Setting Preferences

•Browsing the Repository

•Searching for Items

•Previewing and Printing Reports

3.Interacting with Reports in Workspace

•Annotations Overview

•Creating, Viewing, and Replying to Annotations

•Integrating Reports into Microsoft Office Applications

4.Navigating Reports in Reporting Studio

•Reporting Studio Overview

•Opening Reports

•Previewing and Printing Reports

5.Creating Basic Reports

•Report Creation Overview

•Creating Reports and Grids

•Selecting Members for Rows and Columns

•Setting the Point of View

•Adding Rows or Columns

•Saving Reports

6.Applying Advanced Member Selections

•Lists Overview

•Selecting Members by Using Lists

•Selecting Members by Using Functions

•Selecting Members for the Page Axis

7.Customizing Grids

•Selecting Database Connections in Reports

•Attaching Documents to Reports

•Displaying Line-Item Details

•Setting Up Expansions to Display Detail Data

•Adding Related Content Links to Reports

8.Formatting Cells and Grids

•Formatting Cells

•Formatting Grids

•Suppressing Data

•Applying Conditional Formatting in Grids

•Setting Up Pages

9.Creating Report Objects

•Adding Text Boxes and Images

•Saving Report Objects

•Inserting Saved Report Objects

•Designing Headers and Footers

•Designing Row and Column Templates

10.Adding Text Functions

•Text Functions Overview

•Inserting Text Functions

•Common Text Functions

11.Adding Auto Calculations and Mathematical Functions

 •Auto Calculations Overview

•Mathematical Functions

•Mathematical Operators in Expressions

•Formulas Overview

•Common Mathematical Functions

Creating Books

•Books Overview

•Previewing and Printing Books

•Changing the Book Point of View

•Importing Files into the Repository

•Creating Books

•Changing the Appearance of Books

Creating Batches

•Working with Batches

•Scheduling Batches

•Scheduling Batch-Bursting Options

•Monitoring Batch Schedules

Managing Items in the Repository

•Managing User Points of View

•Creating E-Mail Links

•Managing Repository Items

•Managing Database Connections

•Setting Permissions for Repository Items


3.     Hyperion Financial Management

1.Introduction to Financial Management

   * About Enterprise Performance Management

2.HFM Basics

   * Dimensions

   * Define Application Profile

   * Create application

3.Loading Metadata from a File

   * About Metadata Load Files

   * Loading Metadata

   * Manage Metadata

   * Prepare own Metadata

4.Configuring Accounts and Custom Dimensions

   * About Accounts and Custom Dimensions

   * Setting Up Account Types and Hierarchies

   * Setting Up Accounts and Custom Dimensions

   * Intercompany Account and Other Account Properties

5.Setting Up Entities, Calendars, and Scenarios

   * Setting up Entities

   * Setting Up Calendars

   * Setting Up Scenarios

6.Loading Data

   * Loading Data Files

   * Extracting Data

   * Copying and Removing Data

7.Creating Tasklist and Data Forms

   * About Data Forms

   * Accessing the Form Builder

   * Defining the Point of View

   * Defining Columns and Rows

   * Setting Row and Column Options

   * Exporting Data to Spreadsheets

8.Entering Data Using Data Grids

   * About Data Grids and Accessing Data Grids

   * Changing the Grid Layout and Display

   * Selecting Members for Dimensions

   * Selecting Members

   * Saving Grid Settings

   * Entering Data and Filling Multiple Cells

   * Spreading and Calculating Data

   * Adding Cell Text and Line-Item Detail

9.Creating Member Lists in Financial Management

   * About Member Lists

   * System and User-Defined Member Lists

   * Creating Member Lists

   * Identifying Member Lists in a File

   * Creating Static Member Lists

   * Creating Dynamic Member Lists for the Entity Dimension and Other Dimensions

   * Loading and Extracting Member Lists

10.Entering Intercompany Data

   * About Intercompany Transactions

   * Intercompany Account Balances

   * Elimination Process

   * Plug Accounts

   * Intercompany Eliminations and the Value Dimension

   * Setting Up Entities and Accounts for Intercompany Data

   * Creating and Running Intercompany Matching Reports

11.Adjusting Data with Journals

   * About Journals and Journal Benefits and Adjusting Data

   * Journals Review Process and the Value Dimension

   * Multiple Journal Postings, Accessing Journals and Opening Periods for Journal Entry

   * Creating Journal Templates and Journal Balance Types

   * Creating Journals and Entering Journal Data

   * Creating, Previewing, Running and Viewing Adjustments with the Entity Details Report

   * Setting Journal Report Properties and Selecting Columns and Filters

   * Saving Journal Reports Locally and Remotely

12.Running Consolidations and process management

   * Consolidation Process and Percentages

   * Entering Consolidation Information Using Ownership Management

   * Running Consolidations

   * Checking Consolidation Status

   * Data Translation

   * Entering Exchange Rates

13.Analyzing Data Using Smart View

   * About Smart View

   * Smart View Installation and Components

   * Connecting to a Data Source

   * Entering Data with Web Data Forms

   * Functions in Smart View


   * About Rules and Rules Syntax

   * Rule Types and Rules Files

   * Objects and Functions in Rules

   * Assigning Values to Accounts

   * Account Expressions

   * Setting Values for Multiple Accounts

   * Subcubes, Data Retrieval, and Rules

   * Loading and Extracting Rules



4.     Hyperion Financial Data Quality management  course content  

1. Product Orientation

•   Oracle's Enterprise Performance Management System

•   Benefits and Features of FDM

•   ERP Integrator

•   Processing Data Overview

2.Navigating FDM

•   Accessing FDM

•   Working with the POV

•   Locking Out Users for Maintenance

•   Running Reports

•   Viewing Graphical Timelines

3.Creating FDM Applications

•   About FDM Applications

•   Creating Applications

•   Managing Applications

4.Integrating Applications

•   Integration Overview

•   Importing, Registering, and Configuring Adapters

•   Adding Machine Profiles

•   Configuring Application Settings

•   Configuring Integration Settings

•   Testing Integrations

•   Setting Up Standard Reports and Templates


5.Setting Up Control Tables and Locations

•   Viewing Control Tables

•   Managing Control Tables

•   Viewing Locations

•   Managing Locations

•   Setting Location Attributes

•   Searching Control Trees

6.Setting Up Mapping Tables

•   Mapping Dimension Members

•   Building Maps

•   Map Types

•   Processing Order

•   Building Maps Externally

•   Copying Maps

•   Sharing Dimension Maps

•   Setting Up Conditional Mapping

Building Import Formats

•   About Import Formats

•   Creating Import Groups

•   Creating Import Formats

•   Assigning Import Formats

•   Adding Import Expressions




7.Loading Data

•   About Loading Data

•   Importing Source Data

•   Working with Records

•   Validating Dimension Mappings

•   Loading Data to Target Systems

•   Drilling into Data

•   Drilling Through from Target Applications

8.Building Validation Rules

•   About Validation Rules and Reports

•   Creating Validation Rule Groups

•   Creating Validation Rules

•   Creating Validation Rules with Validation Editor

•   Assigning Validation Rules to Locations

•   Checking Validation Rules

9.Setting Up Validation Entities

•   About Validation Entities

•   Creating Validation Entity Groups

•   Creating Validation Entities

•   Assigning Validation Entity Groups to Locations

•   Verifying Consolidations

10.Processing Batch Files

•   About Batch Processing

•   Setting Up Batch-Load Files

•   Processing Batches

•   Creating Batch Scripts

•   Scheduling Batch Scripts in Task Manager

11.Creating Logic Accounts

•   About Logic Accounts

•   Creating Logic Groups

•   Creating Simple Logic Accounts

•   Creating Complex Logic Accounts

•   Assigning Logic Groups to Locations

12.Loading FDM Journals

•   About FDM Journals

•   Creating Journal Templates

•   Adding Metadata Tags

•   Loading Journal Templates

13.Loading Data with Multiload Files

•   About Multiload Files

•   Creating Multiload Excel Templates

•   Creating Multiload Text Files

•   Loading Multiload Files

•   Viewing Errors

14.Setting Up Security

•   About FDM Security

•  Security Levels

•   Setting Up Object Security

•   Setting Up User Security

•   Locking and Unlocking the Local POV Mode

•   Setting Up Report Group Security

15.Working with Financial Controls

•   About Financial Controls

•   Creating Controls Groups, Sections, and Questions

•   Deleting and Restoring Controls Groups, Sections, and Questions

•   Assigning Reviewer, Submitter, and Proxy Rights

•   Accessing Financial Controls

•   Selecting Application Settings for Financial Controls

16.Working with Import Scripts

•   About Scripting in FDM

•   Working with Scripting Components

•   Creating Import Scripts

•   Assigning Import Scripts to Import Formats

•   Applying Scripting Functions to Import Scripts

•   Working with Temporary Variables

•   Manually Executing Custom Custom Web Scripts

17.Working with Import Integration Scripts

•   About Import Integration Scripts

•   Creating Import Integration Scripts

•   Assigning Import Integration Scripts to Import Formats




18.Working with Event Scripts

•   About Event Scripts

•   Creating Event Scripts

•   Changing Import Formats Dynamically


FOR FREE DEMO contact us at:

Email :

Phone/WhattsApp : +91-(868) 622-2553