R12.2.9 Oracle Applications System Administrator Fundamentals

Introduction

• Course Objectives
• Overview
• Oracle E-Business Suite System Administration
• Oracle E-Business Suite Security
• Concurrent Processing in Oracle E-Business Suite
• Oracle Applications Manager
• Oracle Workflow
• Personalizations in Oracle E-Business Suite
• Summary

Oracle E-Business Suite System Administrative Responsibilities

• Objectives
• System Administrative Responsibilities
• System Administration Responsibility
• System Administrator Responsibility
• Functional Administrator and Functional Developer Responsibility
• Integrated SOA Gateway Responsibility
• Summary

Introduction to Oracle E-Business Suite Security

• Objectives
• Successive Layers of Access Control
• Increasing Flexibility and Scalability
• Function Security
• Data Security
• Oracle User Management Layers of Access Control
• Role Based Access Control (RBAC)
• Delegated Administration
• Provisioning Services
• Self Service and Approvals
• Introduction to Single Sign-On
• Simplified User Management
• Centralized Account Provisioning
• On Demand User Creation
• Automatic Linking of User Accounts
• Summary

Introduction to Function Security

• Objectives
• Overview of Function Security
• Defining a New Application User
• Applications
• Using Responsibilities
• Responsibility Components
• Responsibility Creation Process
• Defining a New Responsibility
• Defining a Menu
• Identifying Existing Menu Structures
• Menu Guidelines
• Creating a Menu using the Menus Window in Forms
• Creating a Menu using the HTML-based Menus Page
• Modifying an Existing Menu Definition
• Securing Functions
• Navigator Menus
• The Menu Viewer
• Viewing Node Properties in the Menu Viewer
• Adding a Custom Form Function
• Passable Forms Parameters
• Query-Only Forms
• Form Window Name Changes
• Help Target Changes
• List of All Submit Request Parameters
• Summary

Introduction to Data Security

• Objectives
• Introduction to Data Security
• Data Security Components – Objects
• Grants
• Permissions and Permission Sets
• Data Security Policies
• Example of a Data Security Policy
• Summary

Introduction to User Management

• Objectives
• What Is Oracle User Management?
• Who Is Oracle User Management Intended For?
• Access Control Model
• Successive Layers of Access Control
• Function Security
• Responsibilities
• Data Security
• Role Based Access Control (RBAC)
• Role Categories and Inheritance Hierarchies
• Delegated Administration
• Delegating to Proxy Users
• Provisioning Services
• Self-Service and Approvals
• Login Assistance
• Summary

Implementing Oracle User Management

• Objectives
• Implementing Oracle User Management
• Steps for Implementing Oracle User Management
• Introduction to Roles
• Examples of Roles
• Defining Roles: Data Security Policies
• Defining Roles: Assigning a Single Responsibility and All Its Functions
• to a Role
• Assigning a Single Responsibility to a Role and Granting Specific Functions to a Role
• Defining Roles: Assigning Multiple Responsibilities to a Role
• Role Inheritance Hierarchies
• Role Categories
• Permissions and Permission Sets
• Assigning Permissions to Roles
• Advantages of Roles Over Responsibilities
• Phase II: Define Roles
• Steps for Creating Roles: Define a Role Category
• Steps for Creating Roles: Create a Role within the Role Category
• Steps for Creating Roles: Place Role in Role Inheritance Hierarchy
• Steps for Creating Roles: Assign Permissions to Roles
• Steps for Creating Roles: Assign Role to a New Person
• Steps for Creating Roles: Test the Role
• Delegated Administration
• What Is Delegated Administration?
• User Administration Privileges
• User Administration Privileges (continued)
• Role Administration Privileges
• Seeded Permissions for User Administration
• Managing Roles with Role Administration
• Seeded Permissions for Role Administration
• Organization Administration Privileges
• Registering External Organization Contacts
• Seeded Permissions for Organization Administration
• Delegated Administration vs. Traditional System Administration
• Phase III: Setting Up Delegated Administration
• Steps for Implementing Delegated Administration: Set Up User Administration for a Role
• Steps for Implementing Delegated Administration
• Registration Processes
• Registration Processes: Core Components
• Self-Service Account Requests
• Requests for Additional Access
• Account Creation by Administrators
• Phase IV: Creating Registration Processes
• Steps for Creating Registration Processes: Provide Required
• Description Information
• Steps for Creating Registration Processes: Enter Runtime Execution
• Information
• Steps for Creating Registration Processes: Enter Eligibility Information
• Steps for Creating Registration Processes: Register Subscriptions to Business Events
• Steps for Creating Registration Processes: Set Profile Options (Optional)
• Steps for Creating Registration Processes: Optionally Set Login Page UI
• Attributes
• Steps for Creating Registration Processes: Test as Customer Administrator
• Proxy Users
• Oracle User Management Security Reports
• Creating, Inactivating, and Reactivating User Accounts
• Resetting User Passwords
• Self-Service Features
• Login Assistance
• Summary

Introduction to Concurrent Requests

• Objectives
• Concurrent Requests, Programs, and Managers
• Business Needs for Concurrent Processing
• Business Needs for Standard Request Submission
• Definitions
• Submit Request Flow
• Submit a New Request
• Using Parameters
• Defining a Submission Schedule
• Defining Completion Options (Forms UI)
• Defining Completion Options (HTML-based UI)
• Request ID
• Reprinting a Report
• Use the Requests Window to View and Change Requests
• How to Use the Requests Window (Forms-based UI)
• How to Use the Requests Page (HTML-based UI)
• Additional Tasks for Requests
• Additional Tasks for Requests (Continued)
• Viewer Options Window
• Canceling a Request
• Holding a Request
• Changing Request Options
• Four Phases of a Concurrent Request
• Pending Phase
• Running Phase
• Completed Phase
• Inactive Phase
• System Administrator Monitoring Privileges
• Review Log Files
• Managing Log Files and Tables
• Purge Request Results
• Summary

Managing Concurrent Requests

• Objectives
• Grouping Concurrent Programs and Requests
• Creating a Request Group
• Using a Request Group with a Code
• Submitting Requests: Form Compared with Responsibility
• Implementing a Coded Request Group
• Customization Example
• Creating the New Form Function
• Passable Request Parameters for Request Groups
• Adding the Function to the Menu
• Using a Request Group Code as an Argument
• Customizing the Submit Requests Window
• List of All Submit Request Parameters
• Controlling Access to Concurrent Programs using RBAC
• Enabling Access to Concurrent Programs using RBAC
• Enabling Access to Concurrent Programs using RBAC, continued
• Controlling Access to Viewing Requests using RBAC
• Defining a Request Set
• Request Set Stages
• Stage Status
• Linking of Stages
• Defining Request Sets Step 1: Enter Request Set Name
• Defining Request Sets Step 2: Define a Stage
• Defining Request Sets Step 3: Enter Requests for Stage
• Defining Request Sets Step 4: Enter Request Parameter
• Defining Request Sets Step 5: Link Stages
• Submitting a Request Set
• User Request Set Privileges
• System Administrator Request Set Privileges
• Summary

Administering Concurrent Managers

• Objectives
• Concurrent Requests, Programs, and Processes
• Overview of Concurrent Processing
• Generic Service Management (GSM)
• Defining a Concurrent Manager
• Defining Work Shifts
• Balancing Process Workload Over Time
• Work Shift Hierarchy
• Concurrent Managers: Program Libraries
• Assigning Workshifts to a Manager
• Specializing a Concurrent Manager
• Specialization Rules
• Action Types
• Specializing a Concurrent Manager: Combined Rules
• Combining Multiple Actions Within Rules
• Concurrent Request Types
• Using Request Types
• Conflicts Domains
• Processing Conflicts Domain
• Control Functions of Concurrent Managers (Forms-based UI)
• Managing Concurrent Processing with Oracle Applications Manager
• Activating and Deactivating Concurrent Managers in Oracle Applications
• Manager
• Internal Monitor and ICM
• Defining a Transaction Manager
• Monitoring Concurrent Requests in Oracle Applications Manager
• Concurrent Processing Charts in Oracle Applications Manager
• Concurrent Processing Activity Reports
• Viewing Log and Output Files
• Managing Parallel Concurrent Processing
• Summary

Introduction to Oracle Applications Manager (OAM)

• Objectives
• What is Oracle Applications Manager?
• Benefits of Oracle Applications Manager
• Oracle Applications Manager Integrates with …
• Management Pack for Oracle E-Business Suite
• Integration with Oracle Enterprise Manager 11g Fusion Middleware Control
• Summary

System Monitoring in Oracle Applications Manager

• Objectives
• Navigation in OAM
• Applications Dashboard
• Applications Dashboard Overview
• Applications Dashboard Applications System Status
• Applications Dashboard Configuration Changes
• Applications Dashboard Web Components Status
• Applications Dashboard System Alerts
• Applications Dashboard System Alerts, Metrics, and Logs
• Applications Dashboard User Initiated Alerts
• Applications Dashboard Performance
• Applications Dashboard Critical Activities
• Applications Dashboard Critical Activities Setup
• Applications Dashboard Business Flows
• Applications Dashboard Security
• Monitoring Oracle E-Business Suite Security Setup – Diagnostic Tests
• Applications Dashboard Software Updates
• Site Map
• Site Map Administration
• Host Management
• Host Management – Status
• Host Management – Configuration
• Application Services
• Concurrent Requests
• Workflow
• Site Map Monitoring
• Database Status Details
• Monitoring Forms
• Forms Runaway Processes
• Forms Sessions
• Forms Runtime Processes
• Database Initialization (init.ora) Parameters
• Custom Reporting Utilities SQL Extensions
• Site Map Maintenance
• Site Map Diagnostics and Repair
• Monitoring Oracle E-Business Suite Security
• Setting Up Oracle Applications Manager
• Dashboard Configuration and Alerting Setup
• Setting Up Dashboard Configuration and Alerting
• Knowledge Base Setup
• Concurrent Requests Setup
• Signon Audit Setup
• Summary

Oracle Applications Manager – Diagnostics and Troubleshooting

• Objectives
• Diagnostics and Troubleshooting in Oracle Applications Manager
• Diagnostics and Repair
• Troubleshooting Wizards
• Concurrent Manager Recovery Wizard
• Service Infrastructure Wizard
• Generic Collection Service (GCS) and Forms Monitoring Wizard
• CP Signature
• Dashboard Collection Wizard
• Support Cart
• Summary

Managing Profile Options

• Objectives
• Personal Profile Values
• System Profile Options – Profile Hierarchy Types
• Profile Hierarchy Levels – Security
• Profile Hierarchy Levels – Organization
• Profile Hierarchy Levels – Server
• System Profile Options
• Profile Categories
• Searching for Profile Options and Profile Option Values
• Using User Profile Values as Defaults
• Auditing-Related Profile Options
• Currency-Related Options
• Flexfield-Related Options
• Online Reporting-Related Options
• Personal Output Viewer Options
• User-Related Concurrent Request Profile Options
• Security Signon Profile Options
• Summary

Introduction to Oracle Workflow

• Objectives
• Enabling E-Business
• Inter-Enterprise Business Processes
• Traditional Workflow
• Workflow-Driven Business Processes
• Sample Workflow Process
• Event-Based Workflow
• Subscription-Based Processing
• System Integration with Oracle Workflow
• Business Process-Based Integration
• Supported System Integration Types
• Designing Applications for Change
• Designing Applications for Integration
• Summary

Oracle Workflow Components

• Objectives
• Oracle Workflow Architecture
• Oracle Workflow Components
• Workflow Engine
• Workflow Processes
• Supported Process Constructs
• Oracle Workflow Builder
• Business Event System Architecture
• Advanced Queuing, an Enabling Technology
• Oracle Database Communication Alternatives
• Accessing Oracle Workflow Web Pages
• Oracle Workflow Home Pages
• Notification System
• Worklist Web Pages
• E-Mail Notifications
• Directory Services
• Directory Services Roles
• Status Monitor Web Pages
• Workflow Definitions Loader
• Workflow XML Loader
• Workflow Manager
• Service Components
• Oracle Workflow Documentation
• Summary

Workflow Tasks for the System Administrator

• Objectives
• Administrator Monitor
• Viewing Workflows in the Administrator Monitor
• Viewing Activity History in the Administrator Monitor
• Viewing a Status Diagram in the Administrator Monitor
• Viewing Responses in the Administrator Monitor
• Viewing Workflow Details in the Administrator Monitor
• Viewing Error Information in the Administrator Monitor
• Viewing Child Workflows in the Administrator Monitor
• Administering Notifications
• Viewing Notifications from a Web Browser
• Notification Details
• Reassigning Notifications
• Administrator Search for Notifications
• Vacation Rules
• Oracle Workflow Manager
• Service Components
• Oracle Workflow Manager
• Service Components
• Service Component
• Accessing Service Components in Oracle Workflow Manager
• Managing Service Components
• Service Component Container Logs
• Service Component Startup Modes
• Agent Listeners
• Notification Mailers
• Outbound Notification Mailer Processing
• Inbound Notification Mailer Processing
• Notification Mailer Setup
• Connecting to Mail Servers Through SSL
• SMTP Authentication
• Notification Mailer Basic Configuration
• Notification Mailer Advanced Configuration
• Advanced Configuration – Define
• Advanced Configuration – Details
• Advanced Configuration – E-mail Servers
• Advanced Configuration – Message Generation
• Advanced Configuration – Schedule Events
• Advanced Configuration – Tags
• Advanced Configuration – Test
• Advanced Configuration – Review
• Component Details for Notification Mailers
• Notification Mailer Throughput
• Handling Notification Mailer Errors
• Testing Mailer URL Access
• System Status
• Workflow System Status
• Workflow Status in Oracle Applications Manager
• Work Items
• Completed Work Items
• Background Engines
• Purging Workflow Data
• Workflow Purge APIs
• Control Queue Cleanup
• Queue Propagation
• Agent Activity
• Searching Messages on an Agent
• Summary

SOA and Web Services for the System Administrator

• Objectives
• Service-Oriented Architecture
• Comparing Methods – Challenges
• Web Services
• SOA in Oracle E-Business Suite
• Architectural Changes in Oracle E-Business Suite Integrated SOA Gateway
• Release 12.2
• Product Dependencies
• Oracle E-Business Suite Integrated SOA Gateway
• Oracle Integration Repository
• Service Provider: Expose Oracle E-Business Suite and Custom Interfaces as Web Services
• High-Level Overview of Service Development
• Assigning User Roles
• Performing Administrative Tasks
• Accessing Oracle Integration Repository
• Searching and Viewing Integration Details
• Managing Service Life Cycle Activities: SOAP
• Generating SOAP Services
• Service Generation with Interaction Patterns
• Deploying SOAP Services
• Undeploying, Retiring, and Resetting Services
• Activating Retired SOAP Services
• Managing Service Life Cycle Activities: REST
• Deploying REST Services
• Undeploying REST Services
• Performing Administrative Tasks
• Authentication for SOAP-based Web Services
• Authorization Through Security Grants
• Authorization Through Security Grants: Both SOAP and REST Services
• Authorization to Verify Execution Privileges
• Performing Administrative Tasks
• Composite Service Enablement Process
• Administering Composite Service – BPEL
• Performing Administrative Tasks
• Understanding Custom Interfaces and Services
• Administering Custom Integration Interfaces and Services
• Performing Administrative Tasks
• Logging Configuration for Web Services
• Viewing and Searching Existing Configurations
• Adding a New Log Configuration
• Modifying an Existing Log Configuration
• Performing Administrative Tasks
• Service Monitor: A Web Service Auditing and Monitoring Tool
• Searching SOAP Messages
• Viewing SOAP Requests and Responses
• Viewing Service Processing Logs
• Purging SOAP Messages, Audits, and Logs
• Performing Administrative Tasks
• Service Invocation Framework (SIF)
• Architecture Overview
• Setup Tasks
• Implementing Event Driven Service Invocation
• Runtime Invocation Process Flow
• Setting Profile Options
• Supported Web Service Clients
• Running Diagnostic Tests
• Summary

Auditing System Resources

• Objectives
• Auditing Oracle E-Business Suite
• Auditing User Activity
• Sign-On Audit Profile Option
• Sign-On Audit Reports
• Signon Audit Forms Report
• Signon Audit Concurrent Requests Report
• Signon Audit Responsibilities Report
• Signon Audit Unsuccessful Logins Report
• Signon Audit Users Report
• Purge Audit Records
• Monitor Users Window
• Auditing Database Changes
• Steps for Setting Up AuditTrail
• Identify Tables and Columns to Audit
• Create an Audit Group
• Audit Tables Window
• Identifying the Schema to be Audited
• Enabling Audit Processing
• Audit Shadow Tables
• Shadow Table Views
• Summary

Managing Printers

• Objectives
• Oracle Print Definition Components
• Relationships of the Printer Components
• Formatting Information
• Defining Printers
• Finding Existing Printer Types
• Registering a New Printer
• Defining a New Printer Type
• Printing with Pasta
• Setup for Basic Printing with Pasta
• The pasta.cfg file
• Example of Setting Margins with pasta.cfg
• Modifying an Existing Printer Type to Use Pasta
• Generating Other Formats using the Preprocessing Option
• Using Pasta with BI Publisher
• Other Customization Materials for Oracle E-Business Suite Printing
• Other Sources of Information for Oracle E-Business Suite Printing
• Summary

Overview of Flexfields

• Objectives
• Benefits of Flexfields
• Modifying Oracle E-Business Suite
• Key and Descriptive Flexfields
• Flexfield Structures and Flexfield Segments
• Segment Prompts and Value Descriptions
• Validating Input Using Value Sets
• Using Flexfield Value Security
• Differences Among Similarly-Named Features
• Key Flexfields
• Intelligent Keys
• Oracle E-Business Suite Key Flexfields (Partial List)
• Descriptive Flexfields
• Using Descriptive Flexfields
• Using Reference Fields
• Using Different Contexts: Asset Category Flexfield
• Oracle E-Business Suite Descriptive Flexfields (Partial)
• Standard Request Submission (SRS) and Flexfields
• Storing Flexfield Data Internally
• Implementing a Flexfield – Steps
• Summary

Overview of Personalizations

• Course Objectives
• Test Access To Personalizations Before Production Deployment
• Concepts: Pages
• Concepts: Items
• Examples of Oracle Forms Personalizations
• Oracle Forms Personalizations
• Examples of OA Framework Personalizations
• User Personalizations
• Administrator-seeded Personalizations
• Personalizations vs. Extensions
• Benefits of Personalizations
• Benefits of Extensions
• Summary

Appendix – Overview of Folders

• Objectives
• Folders: Definition
• Administering Folders: Topics
• Assigning a Default Folder to a Responsibility
• Assigning a Default Folder to a User
• Assigning Ownership of a Folder
• Deleting a Folder Definition
• Summary