Oracle 11i Essentials for Implementers

Course Introduction

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

Session 1: INTRODUCTION

• Introduction to Oracle 11i Applications
• Shared Entities and Integration
• Introduction to System Administration
• Introduction to Flexfields
• Introduction to Oracle Workflow and Alerts
• Introduction to Business Intelligence

Session 2: NAVIGATION

• Login and Logout of Oracle
• The Navigator Functions Tab
• The Navigator Top Ten List
• The Navigator Documents Tab
• The Navigator Processes Tab
• Oracle Window Features and Terminology
• Oracle Form Features and Terminology
• Flexfields
• Icons
• Enter Data
• Find Data
• Attachments
• Folders
• Profile Options
• Oracle Help

Session 3: INTRODUCTION TO ORACLE 11i APPLICATIONS

• Oracle Applications Suite
• Internet Computing Architecture
• Product Suites
• Forms Server and Forms Client
• File System
• Introduction to System Administration Tasks
• System Monitoring in Oracle Applications Manager
• Form Personalization
• Personalize Oracle Applications Framework Pages

Session 4: SHARED ENTITIES AND INTEGRATION

• Shared Entities
• Key Business Cycles in eBusiness Suite
• CRM Application Foundation (JTA)
• Key Business Flows
• Changes to Architecture in Release 12

Session 5: INTRODUCTION TO SYSTEMS ADMINISTRATION

• Overview of Application Security
• Responsibilities
• Define a New Applications User
• Define an Application
• Register an Oracle ID
• Data Groups
• Application Oracle ID Pairs
• Data Groups and Application Object Library
• Relate Data Groups to Forms and Programs
• Applications, Forms and Programs
• Application Oracle ID Pairs
• Manage Function Security
• Use the Navigator
• Navigator Menu Displays
• Exclude Functions and Menus
• Create and Alter Responsibilities
• Define and Modify Menus
• Additional Flexfield Options
  • Cross Validation
  • Shorthand Aliases
  • Security Rules
• Manage Profiles
• Manage Concurrent Programs and Reports

Session 6: INTRODUCTION TO FLEXFIELDS

• Flexfield Overview
• Customize Oracle Applications with Flexfields
• Flexfield Components
• Customize the Flexfield Appearance
• Validate Input Using Value Sets
• Value Sets with Flexfields
• Key and Descriptive Flexfields
• Key Flexfields
• Intelligent Keys
• Accounting Flexfield Example
• Descriptive Flexfields
• Reference Fields
• Oracle Applications Descriptive Flexfields
• SRS and Flexfields
• Flexfield Benefits
• Store Flexfield Values in Database Tables
• Flexfield Implementation Steps
• Value Set Planning
• Types of Value Sets
• Value Set Attributes
• Format Validation
• Format Types
• Format Translatable Value Sets
• Values Validation
• Define Value Sets
• Predefined Value Set
• Select a Value Set for Value Definition
• Define Values for a Value Set
• Alter Value Definitions
• Value Hierarchies
• Define Value Hierarchies and Qualifiers
• Intelligent Keys
• Key Flexfields
• Oracle Application Key Flexfields
• Oracle Applications Descriptive Flexfields

Session 7: INTRODUCTION TO R12 MULTI-ORG ACCESS CONTROL

• Benefits of R12 MOAC
• R12 MOAC Setup and Process
• R12 Multi-Org Reporting

Session 8: INTRODUCTION TO ORACLE WORKFLOW AND ALERTS

• Workflow Overview
• Oracle Workflow with Oracle Applications
• Example Workflow Processes
• Workflow Concepts
• Oracle Workflow Components
• Supported Process Constructs
• Extending the Code
• Item Types
• Processes
• Functions
• Notifications and Messages
• Attributes
• Lookup Types
• Standard Activities
• Applications Integration
• What can be Customized?
• Notification System
• View Notifications from a Web Page
• Email Notifications
• Workflow Monitor
• View and Respond to Notifications
• Grant Worklist Access
• Define Vacation Rules
• Monitor Workflow Processes
• Purge Workflow Data
• Workflow Data
• Workflow Purge APIs
• WF_PURGE APIs
• Purge Obsolete Workflow Runtime Data
• Purge Parameters
• Oracle Alerts
• Oracle Alert Process Overview
• Exceptions
• Event Alerts
• Periodic Alerts
• Action Types
• Action Levels
• Alert Implementation Steps

Session 9: INTRODUCTION TO BUSINESS INTELLIGENCE

• Versions
• Daily Business Intelligence fundamentals
  • Terminology
  • Daily Business Intelligence for Financials
  • Common Concepts
• Fusion Business Intelligence Fundamentals
• Fusion Integration points with e Business Suite
• Fusion Terminology
• Fusion Intelligence for e Business Suite
• Guided Navigation
• Key Performance Indicators
• Oracle BI Components
• Requests (Reports)
• Star Schema
• Subject Areas
• Web Catalog
• Navigation
• Fusion Financial Intelligence

Session 10: WORKSHOP EXERCISES

• Application Security
• Define an Application
• Manage Concurrent Programs and Reports
• Manage Profiles
• Administer Folders
• Define Key Flexfields
• Additional Flexfield Options
• Define Descriptive Flexfields
• View the Workflow Monitor
• View Workflow Worklists
• Test a Workflow Process