Oracle R12 System Administration

Oracle R12 System Administration

5 days @ £2,195.00 exc. VAT 

Course Code: FSAR12

25 Years - The IT Training specialist

Upcoming Scheduled Events - next 12 months

Location Start Date Spaces Book
London 13 Nov 2017 Spaces StayAhead - Course Running Book
London 29 Jan 2018 Spaces StayAhead - Course Running Book
London 09 Apr 2018 Spaces StayAhead - Course Running Book
London 04 Jun 2018 Spaces StayAhead - Course Running Book
View Further Dates

Location Start Date Spaces Book
London 30 Jul 2018 Spaces StayAhead - Course Running Book
London 24 Sep 2018 Spaces StayAhead - Course Running Book

S9

Oracle R12 System Administration Course Overview

This Oracle R12.x System Administration course is designed to give delegates practical experience of administering an Oracle R12 system.

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
  • 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 course is designed for Oracle R12 System Administrators, technical consultants and functional implementers.

Course Objectives

By the end of this Oracle R12 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.

Requirements

An understanding of Oracle Applications.

Follow-On Courses

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


Oracle R12 System Administration Training Course

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
  • The Layers of Access Control in Oracle Application Security
  • Define Function security
  • Define Data Security
  • Responsibilities
  • Create and Administer Users

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

Session 4: ORACLE USER MANAGEMENT

  • Overview of Oracle User Management
  • Implement 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 Roles and Assign Responsibilities to Roles
  • Define Organization Administration Privileges for Roles
  • Role Inheritance
  • Self Service Features

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

Oracle R12 System Administration Training Course

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

Session 7: MANAGE PROFILE OPTIONS

  • 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

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

Session 9: AUDIT SYSTEM RESOURCES

  • Methods of Auditing Oracle Applications Performance and resources
  • Set Audit Related Profile Options
  • Audit Oracle Applications
  • Audit User Activity
  • Run Audit Related Reports
  • Monitor Users Window
  • Audit Database Changes

Session 10: MANAGE PRINTERS

  • Understand Printing Concepts
  • Pasta Printing Concepts
  • Formatting Information
  • Print Definition Components
  • Define Printer Types
  • Use Pasta

Session 11: APPLICATIONS DBA TASKS

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

Oracle R12 System Administration Training Course

Session 12: DIAGNOSTICS AND TROUBLESHOOTING WITH ORACLE APPLICATIONS MANAGER

  • Overview of OAM
  • OAM Setup
  • The OAM Site Map
  • The OAM Dashboard
  • Monitoring System Performance and Components
  • Monitor Critical Activities, Business Flows and Security Issues
  • Monitor Oracle Forms Sessions
  • Manage Hosts
  • Use the Diagnostics Summary Page and Troubleshooting Wizards
  • Use 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

Session 14: CUSTOMIZING ONLINE HELP

  • Customize Help Files
  • Help System Builder
  • Help Builder

Session 15: 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 16 VALUE SETS

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

Oracle R12 System Administration Training Course

Session 17: 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

Session 18: ADDITIONAL FLEXFIELD OPTIONS

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

Session 19: 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

Session 20: ADVANCED VALIDATION CAPABILITIES

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

Oracle R12 System Administration Training Course

Session 21: 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

Session 22: 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

Session 23: WORKFLOW OVERVIEW

  • Workflow Overview
  • Oracle Workflow Versions
  • Traditional Workflow
  • Workflow Driven Processes
  • Event Based Workflow
  • The Required Steps to Setup Workflow
  • The Optional Steps to Setup 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 24: 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

Session 25: 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 26: ORACLE ALERT OVERVIEW

  • Oracle Alert Process Overview
  • Exceptions
  • Event Alerts
  • Periodic Alerts
  • Alert Implementation Steps
Home Let Us Call You Enquiry

Place A booking





Print Friendly



Course Reviews

The Trainer was wonderful, very professional and instructions were easy to follow.

Floria - IS Technical Specialist - Systems


A very good trainer, very patient, approachable and happy to ask any questions.

Georgina - Junior Oracle Apps Analyst - Broadcasting


Trainer was very knowledgeable and patient. Looking forward to trying out all I have learned on this course.

Lynne - Group Systems Accountant - Utilities


More Course Reviews....

It was a great course and has proved very informative explaining many things I didn't understand previously. The location and facilities around were wonderful and I have thoroughly enjoyed my visit to StayAhead. My tutor was excellent. Great course. Three people on the course was an excellent number of delegates.

Roz - IT Applications Consultant - Government


This was my first introduction in to the world of Oracle Applications. I found Marian to be very knowledgable, she kept the pace of the course to a pace I was comfortable with and was a very good tutor. I look forward to attending my course on patching, installation and maintenance in Feb. Thanks for being a great trainer :-)

Ben - Production Services Analyst


The lecturer was extremely helpful and happy to answer questions and had excellent product knowledge.

Judy - ERP Analyst - Broadcasting


All Course Reviews....


Book further course dates
StayAhead Locations

If the course you require is not scheduled at your preferred centre, please contact us on 020 7600 6116 or sales@stayahead.com to enquire if we can accommodate your venue requirements.


Quick Search...


New Search
Enquiry
StayAhead Promo 7


Oracle User Group - Membership Benefits

Oracle User Group - Membership Benefits

Course Certification

Our independent Oracle, Solaris & Red Hat Linux curriculums helps prepare delegates for official certification.

Programming, Java, Web Dev, SQL, NoSQL, MySQL & MariaDB

Linux, Red Hat, Oracle Linux, SUSE & LPI

UNIX, Solaris, AIX & HP-UX

UNIX 
AIX 
HP-UX 

GDPR, Business Analysis, ITIL & Prince2

See what our clients say . . .

Having previously undertaken a similar course in the past I expected this course to not be especially beneficial, however this was not the case at all. I have garnered some very useful new skills and knowledge. The trainer's subject knowledge and delivery are a credit to himself and Stayahead. I was constantly engaged and rarely found myself requiring a repeat of the coursework but when needed he was more than helpful in explaining where I was struggling.

Laurence - Operations Support - Finance - September 2017

More Reviews

+44 (0)20 7600 6116
Cookies Policy
Copyright © 2017 StayAhead Training Ltd
sales@stayahead.com