Apps DBA 

Pre- requisites: 

• UNIX commands, Sqlplus basics, Oracle DBA 11g

Course Content: 

• Oracle E-Business Suite Overview
• Preparing For Your Installation
• Oracle E-Business Suite Components
• Environment Files, Control Scripts, and Languages
• Oracle E-Business Suite File System
• Oracle E-Business Suite Database
• Database Overview
• Advanced Configuration Options
• Using the AD Utilities
• AD Administration: Generate Applications Files
• Preliminary Tasks
• AD Administration: Maintain Applications Files
• Maintain Applications Files Menu
• AD Administration: Maintain Database Entities
• AD Administration: Compile/Reload Database
• Compile/Reload Database Entities Menu
• AD Administration: Non-Interactive Operation and Maintenance Mode
• Special Utilities
• AutoConfig
• License Manager
• Reporting Utilities
• Configuration Utilities
• AD Splicer Overview
• Patching and the Auto Patch Process
• Cloning Oracle E-Business Suite
• Principles and Terminology

Discuss different types of migration/upgrade scenarios.

 SAP 
----: WE OFFER  SAP TRAINING  ON  BELOW THE  MODULES :----

• SAP FICO (FINANCE & CONTROLLING)
• BPC(BUSINESS PLANNING &CONSOLIDATION)
• SAP HR (HUMAN RESOURCE),
• SHAREPOINT & SAP HANA,
• SD (SALES AND DISTRIBUTION),
• CRM –TECHNICAL & FUNCTIONAL (CUSTOMER RELATIONSHIP management) ,
• PP (production PLANNING) ,
• PLM (PLANT MAINTANANCE),
• MM (MATERIAL MANAGEMENT) ,
• SAP WM (WAREHOUSE MANAGEMENT),
• SAP EHS (EVIRONMENT HELTH AND SAFETY),
• PS (PROJECT SYSTEM),
• ABAP (ADVANCED BUSINESS APPLICATION programming),
• BI (BUSINESS INTELEGENCE),
• BW (BUSINESS WAREHOUSING)
• WM (WARE HOUSE MANAGEMENT)
• SCM (SUPPLY CHAIN MANAGEMENT),
• XI (EXCHANGE INFRASTRUCTURE),
• APO (ADVANCED PLANNER  AND OPTIMIZER)
• SAP BO (BUSINESS ONE OBJECTS)
• B1(BUSINESS ONE)
• BASIS, NETWEAVER
• SAP security
• WEBDYNPRO

// * SAP ALL MODULES TRAINING & CERTIFICATION * //

OBIEE 11g

            This course is designed for those professionals who are looking for Great career as Consultant in BI Technology. This course provides  solid foundation on OBIEE 11g. Participants will learn to design the Repository, Creating Answers/Analysis Requests, and Interactive dashboard, Delivers, OBIEE 11g/Fusion Middle ware Security and OBIEE-BI Publisher integration.

PART I: OVERVIEW

• General Data warehousing concepts
• Dimensional modelling basics
• Oracle Business Intelligence Application Overview
• Describing the Oracle Business Intelligence Applications Architecture and components
• BI Server
• BI Answers
• Interactive Dashboards
• Delivers

PART II: ADMIN TOOL AND RPD MODELLING

• Creating Repository Using Administrative Tool
• Repository Basics
• Building Physical Layer of Repository
• Building Physical Model and BMM Layer of a Repository
• Building the Presentation Layer of a Repository
• Testing & Validation of a Repository
• Calculations & Measures
• Creating Dimension Hierarchies
• Organising Presentation Layer
• Working with Initialisation Blocks and Variables
• Adding Multiple Sources
• Executing Direct Database Requests
• Working with Aggregates
• Creating Time Series Measures

PART III: DASHBOARD AND ANALYSIS

• Creating Interactive Dashboards using Answers
• Creating query and chart
• Working with Filters
• Working with Pivot Table
• Building Views and Charts in Requests
• Creating Interactive Dashboard
• Configuring Interactive Dashboards and prompts
• Configuring Guided Navigation Links
• Using Partitions and Fragments
• KPI & Score carding
• Oracle BI for MS-Office

PART IV: SCHEDULING AND DELIVERING

• Sending Alerts Using Delivers
• Configure Scheduler Schema
• Scheduler Configuration
• Creating Sample Request and Adding to Interactive Dashboard
• Creating and Delivering a Simple iBot
• Creating and Delivering a Conditional iBot

PART V: SECURITY FEATURES AND UPGRADE

• Authentication & Authorisation
• Object & Data Level Security
• Web catalogue Level Security
• Creating Users, Groups &Web groups
• Upgrading RPD/WEB CAT from a earlier release

Oracle BI Publisher

Oracle BI Publisher 11g (11.1.1.6.0)

Oracle BI Publisher is an enterprise reporting solution for Production Reporting. It is available as part of OBIEE suite, Standalone Enterprise Release as well integrated with most of the Oracle Enterprise Application as Oracle Fusion Application, Oracle eBusiness Suite (EBS 11i, R12), People Soft, Siebel CRM , JD Edwards and many more.

During this course, participant gets an Overview of the BI Publisher product, Set up, configuration Administration, Report Development and Report Scheduling.

Course Content PART I: Oracle BI Publisher 11g Overview

1. Overview of BI Publisher Enterprise Edition

2. Describing the Oracle BI Publisher Applications Architecture and components

3. Overview of Different Report Component (Layout, Data, Translation)

4. Desktop BI Publisher Desktop (Word Template Designer)

5. Designing First Report using Word Template Builder

PART II: Data Model and Report Designer Editor

1. Overview of Data Model, Data Model Editor

2. Data Model Components.

3. Working with different Data Source options.

4. Designing Simple and Master Detail Data Model

5. Working with Parameters, LOVs

6. Working with Event Triggers, Substitute variables

7. Understanding Data Model Properties.

8. Understanding Groups, Functions, Links, Aggregation

9. Understanding Bursting Definition.

10. Overview of Report Designer and Report creation process.

11. Understanding different Layout types (RTF, PDF, E-text, Excel, and Interactive)

12. Setting Run Time Properties

13. Style Templates & Sub Templates

14. Understanding Translation

PART III: Designing RTF Template using Word Template Designer

1. Create Simple Listing Report

2. Working with Groups

3. Working with Tables, Forms and Charts

4. Implementing conditional logic to handle complex layout

5. Formatting Numbers, Date and Currencies.

6. Defining Headers and Footers

7. Inserting Images and Charts

8. Implementing XPATH Commands in RTF

9. Working with Sub-Templates

10. Advance Report Layout

PART IV: Design Interactive Reports Using Layout Builder

1. Overview of BI Publisher Layouts

2. Designing Simple interactive Report

3. Designing a Master Detail Report Using Charts

PART V: Scheduling the Reports

1. Overview of BI Publisher Scheduler

2. Creating Report Jobs

3. Viewing and Managing Report Jobs

4. Viewing and Managing Report History

PART VI: Migration of Oracle Reports to BI Reports

1. Migration of Oracle Reports To BI Reports

2. Unit testing

3. Deployment of BIP Objects from one instance to another instance

PART VII: BI Publisher Administration

1. Introduction to Oracle BI Publisher Administration

2. Understanding the Security Model

3. Setting up Data Sources

4. Setting up Delivery Destinations

5. Defining Run-Time Configurations

6. Diagnostics and Performance Monitoring

7. Moving Catalogue Objects between Environments

8. Overview of Web logic Console and Enterprise Manager (EM) to Administrator BI Publisher

Who can be benefited?

BI Consultants

Oracle Application Consultants [Technical & Functional]

Data Warehouse consultants

Application Developers

Prerequisites:

Basic understanding with SQL 

  ORACLE APPS TECHNO-FUNCTIONAL

1) ERP Concepts

2) About Oracle Application ProjectsTypes Of Project

3) Oracle Application Positions Hierarchies.

4) Oracle Applications 11i/R12 Architecture

5) System Administration And Application Object Library (AOL)

6) Aim Documentation Preparation.

7) Reports 10g  In Oracle Applications

8) Flex Fields And Value Sets.

9) Oracle Application Interface

10) Inbound Interface

11) Outbound Interface

12) Conversions

13) Data Migration/Data Extractions

14) Forms 10g  In Oracle Applications.

15) Functional Concepts.

16) Release r12

SQL & PLSQL

SQL

•  INTRODUCTION TO SQL
• DDL COMMANDS
• DML COMMANDS
• DCL COMMANDS
• BASIC QUERIES
• SINGLE ROW FUNCTIONS
• GROUP FUNCTIONS (MORE ABOUT SQL)
• JOINS
• VIEWS
• SEQUENCES
• TRANSACTION CONTROL COMMANDS
• SYNONYM
• SET OPERATORS
• ROWID and ROWNUM
• INDEX
• ANALYTICAL FUNCTIONS 

PLSQL

• INTRODUCTION TO PL/SQL
• VARIABLES AND CONSTANTS
• CONDITIONS AND LOOPS 
• CURSORS 
• EXCEPTION HANDLING
• PROCEDURES
• USER DEFINED FUNCTIONS
• PACKAGES
• DATABASE TRIGGERS
• DYNAMIC SQLBULK COLLECT
• COLLECTIONS
• UTL FILE
• SQL * Loader