Oracle 11i System Administration

5 days @ £1,795.00  
S7

Oracle 11i System Administration Course Overview

This course is designed to give delegates practical experience of administering an 11i system. The course covers the main examination topics of the Oracle exam #1Z0-232 Oracle 11i System Administration.

Skills Gained

The delegate will practise:

  • Creating and Administering Users and Responsibilities
  • Assigning Responsibilities to Users
  • Registering a Custom Group
  • Creating a Data Group and Associating Applications with Data Groups
  • Creating and Modifying Menus
  • Managing Users with Role Based Access Control
  • Managing Concurrent Programs and Reports
  • Administering Concurrent Managers
  • Managing Profile Options
  • Incorporating a Custom Program
  • Auditing System Resources
  • Setting Up and Managing Printers
  • Gathering Statistics for Cost Based Optimization
  • Monitoring the System with Oracle Applications Manager
  • Running Diagnostic and Troubleshooting Utilities from OAM
  • Administering Folders
  • Managing Document Sequences
  • Configuring the Online Help System
  • Defining Key and Descriptive Flexfields
  • Defining Value Sets
  • Configuring the Oracle Applications Framework Pages
  • Personalizing Forms
  • Viewing Workflow Notifications
  • Monitoring Workflow Processes
  • Purging Workflow Data

Who will the Course Benefit?

This Oracle 11i System Administration course is designed for Oracle 11i System Administrators, technical consultants and functional implementers.

Course Objectives

By the end of the Oracle 11i System Administration course, delegates will be able to manage users and system security, create and implement menus, control concurrent processing, set up and manage printers, set up and manage key and descriptive flexfields, configure framework pages, personalize forms and administer workflow and alerts.

Examinations

This course is suitable for delegates intending to take the Oracle #1Z0-232 Oracle 11i System Administration examination . The main examination topics of this exam are covered on the course.

Exams are not included as part of the course.

Before taking any exam, ensure you have the recommended experience.

Requirements

An understanding of Oracle Applications.

Follow-On Courses

NOTE: Course technical content is subject to change without notice.


Oracle 11i System Administration Training Course

Course Contents - DAY 1

Course Introduction

  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: SYSTEM ADMINISTRATION TASKS

  • Oracle Applications Suite
  • System Administration Tasks

Session 2: APPLICATION SECURITY

  • Overview of Application Security
  • Responsibilities
  • Create and Administer Users
  • Workshop Exercises

Session 3: DEFINE AN APPLICATION

  • Define an Application
  • Register an Oracle ID
  • Define a Data Group
  • Manage Function Security
  • Use the Navigator
  • Exclude Functions and Menus
  • Define a New Responsibility
  • Define a New Menu Structure
  • Modify an Existing Menu Structure
  • Use the Menu Viewer
  • Workshop Exercises

Oracle 11i System Administration Training Course

Course Contents - DAY 1 ( continued)

Session 4: ORACLE USER MANAGEMENT

  • Overview of Oracle User Management
  • Role Based Access Control
  • RBAC Setup Tasks
  • Create and Update Roles
  • Assign Permissions to Roles
  • Define Delegated Administration Privileges for Roles
  • Define Role Administration Privileges for Roles
  • Define Organization Administration Privileges for Roles
  • Role Inheritance
  • Workshop Exercises

Session 5: MANAGE CONCURRENT PROGRAMS AND REPORTS

  • Concurrent Processing
  • Standard Request Submission
  • Concurrent Manager
  • Submit Request Flow
  • Submit a New Request
  • Scheduling Options
  • Save a Schedule for Future Use
  • Completion Options
  • View Requests
  • Cancel or Hold a Request
  • Change Request Options
  • Phases of a Concurrent Request
  • System Administration Monitoring Privileges
  • Access and Manage Log Files
  • Group Concurrent Requests and Programs
  • Create Request Sets and Groups
  • Use a Request Set with a Code
  • Implement a Coded Request Group
  • Create the New Form Function
  • Add the Function to a Menu
  • Define Request Set Stages
  • Link Stages
  • Workshop Exercises

Oracle 11i System Administration Training Course

Course Contents - DAY 2

Session 6: ADMINISTER CONCURRENT MANAGERS

  • Concurrent Requests, Programs and Processes
  • Concurrent Processing Overview
  • Define a Concurrent Manager
  • Check the Status of a Concurrent Manager
  • Purge Concurrent Manager Tables
  • Define Workshifts
  • Assign Workshifts to a Manager
  • Concurrent Manager Specialization
  • Combined Rules
  • Specialization Rules
  • Combine Multiple Actions with Rules
  • Define and Use Request Types
  • Define and Process Conflicts Domains
  • Manage Concurrent Managers
  • Internal Monitor and ICM
  • Define a Transaction Manager
  • View Log and Output Files
  • Manage Parallel Concurrent Processing
  • Troubleshoot Concurrent Managers
  • Workshop Exercises

Session 7: MANAGE PROFILES

  • Profile Hierarchy Levels
  • Set Personal Profile Values
  • Set System Profile Options
  • Default User Profile Options
  • Audit Related Profile Options
  • Currency Related Options
  • Flexfield Related Options
  • Online Reporting Options
  • Personal Output Viewer Options
  • User Profile Options
  • Security SignOn Profile Options
  • Workshop Exercises

Session 8: INCORPORATE A CUSTOM PROGRAM

  • Integrate Custom Programs with Oracle Applications
  • Components of a Concurrent Program
  • Add a Custom Program to Oracle Applications
  • Identify the Executable
  • Create a Concurrent Program
  • Concurrent Program Parameters Window
  • Associate a Program with a Request Group
  • Submit the Concurrent Program
  • Workshop Exercises

Oracle 11i System Administration Training Course

Course Contents - DAY 2 ( continued)

Session 9: AUDIT SYSTEM RESOURCES

  • Audit Oracle Applications
  • Audit User Activity
  • Sign-On Audit Reports
  • Monitor Users Window
  • Audit Database Changes
  • Workshop Exercises

Session 10: MANAGE PRINTERS

  • Formatting Information
  • Print Definition Components
  • Define a Printer
  • Pass Print Arguments
  • Use Pasta
  • Workflow Exercises

Session 11: APPLICATIONS DBA TASKS

  • Cost Based Optimization
  • Run CBO Statistics Gathering Reports
  • Evaluate Network Performance
  • Workshop Exercises

Oracle 11i System Administration Training Course

Course Contents - DAY 3

Session 12: ORACLE APPLICATIONS MANAGER

  • OAM Setup
  • The OAM Site Map
  • The OAM Dashboard
  • Monitoring the System
  • Diagnostics and Troubleshooting
  • The Support Cart

Session 13: ADMINISTER FOLDERS

  • Assign a Default Folder to a Responsibility
  • Assign a Default Folder to a User
  • Assign Ownership of a Folder
  • Delete a Folder Definition
  • Workshop Exercises

Session 14: MANAGE DOCUMENT SEQUENCES

  • Document Sequences
  • Specify Sequence Information
  • Define a Document Sequence
  • Specify Document Category Information
  • Define Document Categories
  • Associate a Category with its Sequence
  • Use a Sequence with an Application
  • Workshop Exercises

Session 15: CUSTOMIZING ONLINE HELP

  • Customize Help Files
  • Help System Builder
  • Help Builder
  • Workshop Exercises

Session 16: FLEXFIELD OVERVIEW

  • Customize Oracle Applications with Flexfields
  • Flexfield Structures and Flexfield Segments
  • Validate Input Using Value Sets
  • Key and Descriptive Flexfields
  • Reference Fields
  • Oracle Applications Descriptive Flexfields
  • SRS and Flexfields
  • Flexfield Benefits
  • Store Flexfield Values in Database Tables
  • Flexfield Implementation Steps

Session 17: VALUE SETS

  • Validate Input Using Value Sets
  • Value Set Planning
  • Types of Value Set
  • Plan Value Sets
  • Define Value Sets
  • Value Hierarchies
  • Workshop Exercises

Oracle 11i System Administration Training Course

Course Contents - DAY 4

Session 18: DEFINE KEY FLEXFIELDS

  • Intelligent Keys
  • Key Flexfields
  • Key Flexfield Structures
  • Key Flexfield Application Tables
  • Key Flexfield Qualifiers
  • Additional Key Flexfields
  • Planning Decisions
  • Design the Key Flexfield Layout
  • Specify Default Values
  • Define Key Flexfields
  • Account Generator
  • Workshop Exercises

Session 19: ADDITIONAL FLEXFIELD OPTIONS

  • Overview
  • Cross Validation Rules
  • Shorthand Aliases
  • Security Rules
  • Workshop Exercises

Session 20: DEFINE FLEXFIELD OPTIONS

  • Plan a Descriptive Flexfield
  • Descriptive Flexfield Usage
  • Descriptive Flexfield Naming
  • Determine Available Resources
  • Additional Information
  • Organize Information by Usage
  • Isolate Common Information
  • Determine Different Contexts
  • Descriptive Flexfield Components
  • Plan Flexfields
  • Specify Flexfield Attributes
  • Define a Descriptive Flexfield
  • Workshop Exercises

Session 21: ADVANCED VALIDATION CAPABILITIES

  • Advanced Validation Capabilities
  • Advanced Validation Options
  • Table Validated Value Sets
  • Workshop Exercises

Oracle 11i System Administration Training Course

Course Contents - DAY 5

Session 22: CONFIGURE ORACLE APPLICATION FRAMEWORK PAGES

  • Branding
  • Customizing Look-and-Feel
  • Icons
  • Responsibilities and Menus
  • Messages
  • Lookup Codes
  • Style Sheets
  • Personalization of Screen Layout and Behavior
  • Configure the Login page for Oracle Applications
  • Personalize the E-Business Suite Home Page
  • Workshop Exercises

Session 23: FORM PERSONALIZATION

  • Overview of Form Personalization
  • Invoke Form Personalization
  • Access to Form Personalization
  • Trigger Events, Conditions and Rules
  • Context
  • Actions
  • Working with Strings
  • Testing
  • Recovery from Error
  • Form Personalization Example
  • Form Personalization Limitations
  • Advanced Concepts
  • Workshop Exercises

Session 24: WORKFLOW OVERVIEW

  • Workflow Overview
  • Oracle Workflow Versions
  • Traditional Workflow
  • Workflow Driven Processes
  • Event Based Workflow
  • Business Process Based Integration
  • Supported System Integration Types
  • Oracle Workflow Architecture and Components
  • Business Event System
  • Workflow Engine
  • Workflow Builder
  • Notification System
  • Directory Services
  • Workflow Monitor
  • Workflow Definitions Loader
  • Workflow XML Loader

Session 25: VIEW AND RESPOND TO NOTIFICATIONS

  • View and Respond to Notifications
  • Access Oracle Workflow Web Pages
  • View Notifications
  • Worklist
  • Notification Details
  • Find Notifications
  • Email Notifications
  • Email Response Methods
  • View an Email by Summary of Notifications
  • Automatic Notification Process
  • View Notification Rules
  • Define Notification Rules

Oracle 11i System Administration Training Course

Course Contents - DAY 5 ( continued)

Session 26: MONITOR WORKFLOW PROCESSES

  • Monitor Workflow Processes
  • Workflow Monitor
  • Access Workflow Processes
  • Workflow Administration Privileges
  • Find Workflow Processes
  • Review the Process List
  • Review the Notifications List
  • Filter Activities
  • Child Instances
  • Test Processes

Session 27: ORACLE ALERT OVERVIEW

  • Oracle Alert Process Overview
  • Exceptions
  • Event Alerts
  • Periodic Alerts
  • Action Type and Action Levels
  • Alert Implementation Steps

Follow-On Courses



       Home     Let Us Call You     Enquiry     Make Booking     Top

Make A Booking



Oracle User Group - Membership Benefits

Oracle User Group - Membership Benefits

 

MOD Career Transition

Ministry Of Defense - Career Transition Partnership

 

We have created our website to the following W3C standards, this helps makes our pages easier to use for you.

Valid HTML 4.01 Transitional

Valid CSS!

If you find a non-compliant page on our site, please let us know and we will endeavour to fix it immediately.
 

Publicly Scheduled
Training Locations
London centre:
6 Long Lane
Barbican
London
EC1A 9HF
UK

telephone:
+44 (0)20 7600NoSkype 6116
Manchester centre:
St James Court
30 Brown Street
Manchester
M2 1DH
UK
Birmingham centre:
The Enterprise Suite
9th Floor Centre City Tower
5-7 Hill Street
Birmingham
B5 4UA
UK
Bristol centre:
Apex House
Westerleigh Business Park
Turner Drive
Yate
Bristol
BS37 5YX
UK
Leeds centre:
Halsbury House
Chancellor Court
21 The Calls
Leeds
LS2 7EH
UK
Edinburgh centre:
16 St Mary's Street
Edinburgh
Scotland
B3 2HJ
UK
Please contact our London office for all enquiries.

telephone:
+44 (0)20 7600NoSkype 6116

or email:

info@
stayahead.com