Oracle Discoverer Administration for the E-Business Suite

This course has been superseded

We suggest the following instead:
Oracle R12 e-Business Suite courses

Course Description

This practical course covers the Oracle 10g Discoverer Administration Edition and its use with the R12 E-Business suite. The course provides everything needed to successfully administer Discoverer Desktop, Plus and Viewer Editions, allowing users to create and edit reports on various modules within Oracle Applications The first day will give an overview into all aspects of Discoverer Administration on stand-alone machines; with the second day connecting to a Release 12 instance and a pre-defined End User Layer. This workshop session will allow delegates to look at pre-built Business Areas based on specific modules, and then allow the creation of new Business Areas and reports. This will expand the skill set provided by the first session and allow delegates to focus on those modules they are most interested in
2 days
Contact us for pricing
 

Prerequisites

Oracle 10g Discoverer Desktop or Plus

Who Should Attend

Data Administrators
Oracle Discoverer Administrators
System Administrators
Discoverer Superusers

Introduction

Product Overview
Product Basics

Development

End User Layer (EUL) Creation
EUL Development
Business Area Development

Features

Customising items
Joining tables
Calculation items
Filtering with conditions
Registering PL/SQL Functions

Warehouse Techniques

Custom Folders
Complex Folders
Operating multiple Business Areas
Managing Folders

Security

Privileges
Data Security

Performance

External Summaries
Internal Query Statistics
Internal Manual Summaries
Automatic Summary Management

Maintenance

Business Area Maintenance
EUL Maintenance / Management
Import / Export Techniques
Live Distribution
Validation

The E-Business Suite EUL

Connection to an Application EUL
Applications Security
Oracle Applications Business Views
Applications Users and Responsibilities
Sysadmin tasks
Business Area and Report Migration
Seeded Business Areas
Secure Views
eTRM
Tips for matching form data to the base tables
OracleDiscovererOracle Business IntelligenceOracle Business Intelligence DiscovererOracle Discoverer