Oracle Discoverer Administration for the E-Business Suite

Request more details:

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
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