USA : +1 732 325 1626
IND : +91 800 811 4040
Mail ID : info@bigclasses.com

Pages

Online Training

Saturday, September 19, 2009

Oracle Apps DBA

Oracle Apps DBA

11i Install, Patch, and Maintain Oracle™ Applications

* Oracle™ Applications Install
* Overview of Oracle™ Applications
* Single-node Installation
* Multi-node Installation
* 11i Oracle™ E-Business Suite Architecture
* Oracle™ Applications Environment
* Oracle™ Applications File System
* Oracle™ Applications Database
* Advanced Configuration Options
* 11i Use Oracle™ Applications Utilities

* AD Administration
* Special Utilities
* AutoConfig
* License Manager
* Reporting Utilities
* Configuration Utilities

* 11i Patch and Maintain Oracle™ Applications

* Patch Wizard
* Auto Patch
* AM Timing Reports
* AM Applied Patches

* 11i Oracle™ Applications Advanced Topics

* Cloning Oracle™ Applications
* AM Rapid Clone

* Upgrade Oracle™ Applications
* Steps in the upgrade Process
* Considerations when Planning an Upgrade
* Preparing Products for Upgrade
* Running Rapid Install for the Upgrade
* Family Consolidate Upgrade Patches
* Overview of AutoUpgrade
* Using Auto Upgrade Screens and Menus
* Auto Upgrade: Behind the Scenes
* Auto Upgrade Database Phases
* Messages, Logs and Files
* Reviewing AutoUpgrade Status
* Handling a Failed Job
* Handling a Hanging Job or Dead Worker
* Acceptable AutoUpgrade Errors and Messages
* Overview of Patching
* The 11.5.x Maintenance Pack
* Required Functionality Patches
* AD Runtime Statistics Report
* AD Merge Patch The
* AD Administration Utility
* The Importance of the Postupgrade Tasks

System Administrator

* Oracle™ Applications Security
* Function Security

* Users
* Responsibilities
* Menus

* Data Security

* Objects
* Grants
* Permissions

* Oracle™ User Management

* Roles
* Delegated Administration
* Registration Process

* Auditing System Resources

* Sign On Audit
* Audit Trail

* System Management using Oracle™ Applications Manager

* Monitoring the System
* Diagnostics and Troubleshooting

* Managing Concurrent Programs and Reports
* Administering Concurrent Managers

* Generic Service Management
* Defining a Concurrent Manager
* Work Shifts
* Parallel Concurrent Processing

* Managing Profile Options
* Managing Printers
* Applications DBA Duties

* Resource Consumer Groups
* Cost-Based Optimization

* Form Personalization
* Oracle™ Applications Framework Personalization
* Oracle™ Workflow

* Workflow Processes
* Components
* Implementation

Oracle Apps Contents

Oracle Apps

Oracle Applications Modules

* Financial Applications
* Manufacturing Applications
* Supply-Chain Management Applications
* Human Resources Applications

Oracle Applications Features

* Application Features
* Oracle Workflow
* Oracle Applications Multi-Org
* Oracle Applications System Administration
* Third Party Software Compatable with Oracle Applications

Oracle Applications Architechture

* 11i Architecture

Implementation Methods

* Oracle Application Implementation Method
* Rapid Implementations
* Program Office
* Phased Implementations
* Case Studies

Effort and Cost

* Using the Number and Type of Applications to Estimate Costs
* Relative Complexity of Each Application
* Business Systems Complexity
* Minimizing Customizations and Extensions to Lower Costs
* Business Processes
* Other Projects in Process
* Capability of the Project Team

Project Management and Control

* Project Team Roles
* Issue-Resolution Techniques
* Implementing Status Reporting
* Meeting Minutes
* Red Flags
* Project Plan
* Project Scope
* Critical Path
* Quality Control Procedures
* TAR Tracking, Resolution, and Logging
* Impact of Other Projects

Getting Started

* Forming the Project Team
* Starting Quickly
* Selecting and Scheduling the Modules
* Typical Tasks, Deliverables, and Milestones

Analyzing the Project

* Project Analysis Overview
* Business Process Analysis
* Determining Your Reporting Needs
* Infrastructure Analysis
* Customizations
* Legacy Data and Conversion
* Typical Tasks, Deliverables, and Milestones of the Analysis Phase

Converting Analysis into Solutions

* Designing Customizations
* The Solution/Conceptual Design Document
* Estimating Customizations
* Managing the Phase
* Initial Project Documentation
* Preparing for System Test
* Performance Testing Preparation
* Designing the Support Organization

Enabling the System

* Customization
* Managing the Phase
* Some Alternatives to Customizations

Launching The New Systems

* Managing Change
* Transitioning to New Systems
* Supporting Production Operations

Using Oracle General Ledger

* Introduction to Oracle General Leger
* Relationship to Other Oracle Applications
* New Features
* Resolving Issues and Gaps
* Configuring the GL Application
* Processing Transactions
* Understanding Reports

Using Oracle Payables

* Relationship to Other Oracle Applications
* New Features
* Configuring the AP Application
* Processing Transactions
* Balancing the Subledger to the General Ledger
* Using Open Interfaces in This Application
* Using Oracle Cash Management

Using Oracle Receivables

* Introduction to Oracle Receivables
* Relationship to Other Applications
* New Features
* Resolving Common Issues and Gaps
* Configuring the AR Application
* Converting Data for Major Entities
* Processing Transactions
* Balancing the AR Application Internally
* Balancing the Subsidiary Ledger to the General Ledger
* Using Open Interfaces in This AR
* Understanding Key AR Reports

Using Oracle Assets

* Relationship to Other Applications
* New Features
* Critical Implementation Factors
* Converting Data for Major Entities
* Balancing the Subledger to the General Ledger
* Using Open Interfaces in This Application
* Understanding FA Key Reports

Using Oracle Projects

* Introduction to Oracle Projects
* Relationship to Other Applications
* New Features
* Critical Implementation Factors
* Configuring the PA Application
* Advanced Configuration Tasks and Extensions
* Converting Legacy Data
* Processing PA Transactions
* Project Reporting
* Troubleshooting Oracle Projects

Using Oracle Purchasing

* How Purchasing Relates to Other Applications
* New Features in Oracle Purcashing
* Critical Implementation Factors
* Configuring the Puschasing Application
* Converting Data for Major Entities
* Topics of Interest
* Understanding Key Purchasing Reports
* Troubleshooting Oracle Purchasing

Using Oracle Inventory

* Introduction to Oracle Inventory
* Oracle Inventory Relationships to Other Applications
* New Features in Oracle Inventory
* Critical Implementation Factors
* Configuring the Inventory Application
* Loading System Items
* Processing Inventory Transactions
* Additional Inventory Application Functions

Using Oracle Order Management

* Introduction to Oracle Order Management
* Oracle Order Management Relationship to Other Applications
* New Features in Oracle Order Management
* Configuring Order Management Application
* Processing Order Management Transactions
* Understanding Key Order Management Reports
* Troubleshooting Order Management

Using Oracle Engineering and Bills of Material

* Using Oracle Engineering
* Using Oracle Bills of Material
* Troubleshooting Oracle Engineering and Bills of Material

Using Oracle Cost Management

* Understanding the Structure of the Cost Management Application
* Cost Managements Relationship to Other Applications
* New Features in Oracle Cost Management
* Critical Cost Management Implementation Factors
* Configuring Cost Management Application
* Processing Cost Management Transactions
* Understanding Key Reports from Cost Management
* Troubleshooting Oracle Cost Management

Using Oracle Planning Applications

* Introduction to Oracle Planning Applications
* Using Oracle Master Scheduling/MRP
* New Features in Using Oracle Master Scheduling/MRP
* Critical Oracle Planning Implementation Factors
* Configuring Oracle Planning Application
* Processing Oracle Planning Transactions
* Using Supply Chain Planning
* Using Oracle Alerts with This Application
* Using Open Interfaces in Oracle Planning Application
* Best Practices in Oracle Planning Applications
* MRP Understanding Key Reports
* MRP Going Forward

Using Oracle Capacity

* Processing Oracle Capacity Transactions
* Understanding Key Oracle Capacity Reports
* Oracle Capacity Going Forward
* Troubleshooting Oracle Capacity Applications

Using Oracle Work In Process

* New Features in Oracle Work In Process Application
* Critical Implementation Factors in Oracle Work In Process Application
* Configuring the Oracle Work in Process Application
* Converting Data for Major Entities in Oracle Work In Process Application
* Processing Oracle Work in Process Transactions
* Balancing Oracle WIP to the General Ledger
* Using Open Interfaces in Oracle WIP Application
* Understanding Key Oracle WIP Reports
* Troubleshooting Oracle Work in Porcess Application

Implementing Oracle Human Resources and Oracle Payroll

* Critical HRMS Implementation Factors
* Common Unrealistic Project Expectations
* Historical Data Conversion Approaches
* Other Data Conversion Considerations
* Upgrading
* Complete Reinstall
* DateTrack Information
* Required Oracle HRMS Setup Steps
* Troubleshooting Oracle HRMS

Using Oracle Human Resources

* New Features in Oracle Human Resources
* Globalization Support
* Human Resources Self Service
* HR Tips
* Application Data Export
* Troubleshooting Oracle Human Resources

Using Oracle Payroll

* New Features in Oracle Payroll
* Payroll Processing
* Overriding Tax Information
* Processing State Quarterly Wage Listings
* W-2 Year-End Processing
* Regular Versus Supplemental Pay Runs
* Costing of Earnings
* Costing of Overtime
* Overtime FLSA Compliance
* 401(k) Calculations/Company Match
* 403(b) and 457 Deferred Compensation Elements
* Using Special Inputs Elements
* Generating Arrears for Nonrecurring Elements
* Retro Pay
* Tax Balance Adjustments
* Tax Only Earnings
* Costing and Transfer to General Ledger
* Laser Printing of Payroll Checks
* Oracle Fast Formula
* Year-to-Date Balance Conversion
* Third-Party Administrator Transfers
* Time and Attendance Integration with BEE
* Other Interfaces in Oracle Payroll
* Establishing Latest Balances
* Compensation Approaches
* Key Reports in Oracle Payroll
* Oracle Time Management Tables and Policies
* Troubleshooting Oracle Payroll

Using Oracle Advanced Benefits

* Introduction to Oracle Advanced Benefits
* Implementation Strategies for Oracle Advanced Benefits
* Compensation Objects
* Life Events
* Eligibility Profiles and Derived Factors
* Benefit Program Setup Example
* Imputed Income for Domestic Partner Benefits
* Using Imputed Income for Domestic Partner Benefits
* Flex Credits and Benefit Pools

Administering the Oracle Applications

* New Features for Administrators
* Understanding Security
* Maintaining Profile Options
* Understanding Concurrent Processing
* Understanding Printers
* Troubleshooting Oracle Administration

Using Oracle Workflow

* Skills Required to Use Workflow
* Target Users
* New Features in Oracle Workflow
* Understanding the Major Components of Workflow
* Using the Workflow Engine
* Using the Workflow Directory Services
* Creating a Workflow Process
* Diagramming the Workflow Process
* Creating Notification Activities
* Monitoring Workflow Processes
* Using the Workflow Administrator
* Considerations in Setting Up Workflow
* Setting Up a Data Store
* Predefined Workflows Embedded in Oracle Applications
* Troubleshooting Oracle Workflow

Understanding Multi-Org

* Multiple Organizations
* Understanding the Key Tables
* Critical Implementation Factors for Multi-Org
* Configuring the Application for Multi-Org
* Muti-Org Reporting
* Troubleshooting Multi-Org

Employment Market

* Overview of Employment Market
* Skills Needed to Become a Consultant
* Character Traits of a Good Consultant
* Consulting Advantages
* Consulting Disadvantages
* Support Jobs
* Product Development Jobs
* Sales/Marketing Jobs
* Recruiting Jobs
* Working for Oracle Corporation
* Working for Oracle Customers
* What Happened in the Early 2000s
* Oracle Corporation Is an Engine of Growth

Consulting Market

* Independent Consulting
* Smaller, Specialized Consulting Firms
* Larger, Diversified Consulting Firms
* Oracle Corporation Consulting

Implementation Checklist

* Plan and Initiate the Project
* Build and Configure Your System
* Transition to the New System
* Support the Production Systems

Oracle DBA Contents

Oracle DBA

Oracle Applications Overview

* Overview of Oracle Applications

Oracle Applications Modules

* Financial Applications
* Manufacturing Applications
* Supply-Chain Management Applications
* Human Resources Applications

Oracle Applications Features

* Application Features
* Oracle Workflow
* Oracle Applications Multi-Org
* Oracle Applications System Administration
* Third Party Software Compatable with Oracle Applications

Oracle Applications Architechture

* Architecture

Implementation Methods

* Oracle Application Implementation Method
* Rapid Implementations
* Program Office
* Phased Implementations
* Case Studies

Effort and Cost

* Using the Number and Type of Applications to Estimate Costs
* Relative Complexity of Each Application
* Business Systems Complexity
* Minimizing Customizations and Extensions to Lower Costs
* Business Processes
* Other Projects in Process
* Capability of the Project Team

Project Management and Control

* Project Team Roles
* Issue-Resolution Techniques
* Implementing Status Reporting
* Meeting Minutes
* Red Flags
* Project Plan
* Project Scope
* Critical Path
* Quality Control Procedures
* TAR Tracking, Resolution, and Logging
* Impact of Other Projects

Getting Started

* Forming the Project Team
* Starting Quickly
* Selecting and Scheduling the Modules
* Typical Tasks, Deliverables, and Milestones

Analyzing the Project

* Project Analysis Overview
* Business Process Analysis
* Determining Your Reporting Needs
* Infrastructure Analysis
* Customizations
* Legacy Data and Conversion
* Typical Tasks, Deliverables, and Milestones of the Analysis Phase

Converting Analysis into Solutions

* Designing Customizations
* The Solution/Conceptual Design Document
* Estimating Customizations
* Managing the Phase
* Initial Project Documentation
* Preparing for System Test
* Performance Testing Preparation
* Designing the Support Organization

Enabling the System

* Customization
* Managing the Phase
* Some Alternatives to Customizations

Launching The New Systems

* Managing Change
* Transitioning to New Systems
* Supporting Production Operations

Using Oracle General Ledger

* Introduction to Oracle General Leger
* �Relationship to Other Oracle Applications
* New Features
* Resolving Issues and Gaps
* Configuring the GL Application
* Processing Transactions
* Understanding Reports

Using Oracle Payables

* Relationship to Other Oracle Applications
* New Features
* Configuring the AP Application
* Processing Transactions
* Balancing the Subledger to the General Ledger
* Using Open Interfaces in This Application
* Using Oracle Cash Management

Using Oracle Receivables

* Introduction to Oracle Receivables
* Relationship to Other Applications
* New Features
* Resolving Common Issues and Gaps
* Configuring the AR Application
* Converting Data for Major Entities
* Processing Transactions
* Balancing the AR Application Internally
* Balancing the Subsidiary Ledger to the General Ledger
* Using Open Interfaces in This AR
* Understanding Key AR Reports

Using Oracle Assets

* Relationship to Other Applications
* New Features
* Critical Implementation Factors
* Converting Data for Major Entities
* Balancing the Subledger to the General Ledger
* Using Open Interfaces in This Application
* Understanding FA Key Reports

Using Oracle Projects

* Introduction to Oracle Projects
* Relationship to Other Applications
* New Features
* Critical Implementation Factors
* Configuring the PA Application
* Advanced Configuration Tasks and Extensions
* Converting Legacy Data
* Processing PA Transactions
* Project Reporting
* Troubleshooting Oracle Projects

Using Oracle Purchasing

* How Purchasing Relates to Other Applications
* New Features in Oracle Purcashing
* Critical Implementation Factors
* Configuring the Puschasing Application
* Converting Data for Major Entities
* Topics of Interest
* Understanding Key Purchasing Reports
* Troubleshooting Oracle Purchasing

Using Oracle Inventory

* Introduction to Oracle Inventory
* Oracle Inventory Relationships to Other Applications
* New Features in Oracle Inventory
* Critical Implementation Factors
* Configuring the Inventory Application
* Loading System Items
* Processing Inventory Transactions
* Additional Inventory Application Functions

Using Oracle Order Management

* Introduction to Oracle Order Management
* Oracle Order Management Relationship to Other Applications
* New Features in Oracle Order Management
* Configuring Order Management Application
* Processing Order Management Transactions
* Understanding Key Order Management Reports
* Troubleshooting Order Management

Using Oracle Engineering and Bills of Material

* Using Oracle Engineering
* Using Oracle Bills of Material
* Troubleshooting Oracle Engineering and Bills of Material

Using Oracle Cost Management

* Understanding the Structure of the Cost Management Application
* Cost Managements Relationship to Other Applications
* New Features in Oracle Cost Management
* Critical Cost Management Implementation Factors
* Configuring Cost Management Application
* Processing Cost Management Transactions
* Understanding Key Reports from Cost Management
* Troubleshooting Oracle Cost Management

Using Oracle Planning Applications

* Introduction to Oracle Planning Applications
* Using Oracle Master Scheduling/MRP
* New Features in Using Oracle Master Scheduling/MRP
* Critical Oracle Planning Implementation Factors
* Configuring Oracle Planning Application
* Processing Oracle Planning Transactions
* Using Supply Chain Planning
* Using Oracle Alerts with This Application
* Using Open Interfaces in Oracle Planning Application
* Best Practices in Oracle Planning Applications
* MRP Understanding Key Reports

Oracle 11g Contents

SQL 9i/10g and 11g

Introduction to RDBMS

What is New in the SQL Language?Oracle Database 11g Release 1 New Features in the SQL Language Reference

Introduction to Oracle SQL

* History of SQL
* SQL Standards
* How SQL Works
* Common Language for All Relational Databases
* Recent Enhancements

SQL Statements:

Types of SQL Statements

Constraints & Pseudocolumns

Operators

Functions

* About SQL Functions
* Single-Row Functions
* Aggregate Functions
* Analytic Functions
* Object Reference Functions
* Model Functions

Expressions

Conditions

Common SQL DDL Clauses
SQL Queries and Sub queries

SQL Statements: Working with Views and MATERIALIZED VIEW

SQL FAQs

PL/SQL 9i/10g and 11g

New PL/SQL Features for 11g Release 1 (11.1)

Overview of PL/SQL

Advantages of PL/SQL
Main Features of PL/SQL
Architecture of PL/SQL

PL/SQL Language Fundamentals

* Character Sets and Lexical Units
* Declarations
* Naming Conventions
* Scope and Visibility of PL/SQL Identifiers
* Assigning Values to Variables
* PL/SQL Expressions and Comparisons
* PL/SQL Error-Reporting Functions
* Using SQL Functions in PL/SQL
* Conditional Compilation

PL/SQL Data types

* Predefined PL/SQL Scalar Datatypes and Subtypes
* Predefined PL/SQL Large Object (LOB) Datatypes
* User-Defined PL/SQL Subtypes
* PL/SQL Datatype Conversion

Using PL/SQL Control Structures

* Overview of PL/SQL Control Structures
* Testing Conditions (IF and CASE Statements)
* Using the IF-THEN Statement
* Using the IF-THEN-ELSE Statement
* Using the IF-THEN-ELSIF Statement
* Using the Simple CASE Statement
* Using the Searched CASE Statement
* Guidelines for IF and CASE Statements
* Controlling Loop Iterations (LOOP, EXIT, and CONTINUE Statements)
* Using the Basic LOOP Statement
* Using the EXIT Statement
* Using the EXIT-WHEN Statement
* Using the CONTINUE Statement
* Using the CONTINUE-WHEN Statement
* Labeling a PL/SQL Loop
* Using the WHILE-LOOP Statement
* Using the FOR-LOOP Statement
* How PL/SQL Loops Repeat
* Dynamic Ranges for Loop Bounds
* Scope of the Loop Counter Variable
* Using the EXIT Statement in a FOR Loop
* Sequential Control (GOTO and NULL Statements)
* Using the GOTO Statement
* GOTO Statement Restrictions
* Using the NULL Statement

Using PL/SQL Collections and Records

Using Static SQL

Using Dynamic SQL

Using PL/SQL Subprograms

Using Triggers

Using PL/SQL Packages

Handling PL/SQL Errors

Tuning PL/SQL Applications for Performance

PL/SQL Language Elements

Oracle File Management

Oracle Utilities

Oracles Advanced PLSQL

Tuning Introduction

PL/SQL FAQs

* Data Definition Language (DDL) Statements
* Data Manipulation Language (DML) Statement
* Transaction Control Statement
* Session Control Statements
* System Control Statement
* Embedded SQL Statements

Basic Elements of Oracle SQL

* Datatypes
* Oracle Built-in Datatypes
* Rowid Datatypes
* Database Objects
* Schema Objects
* Nonschema Objects
* Schema Object Names and Qualifiers
* Schema Object Naming Rules
* Schema Object Naming Examples
* Schema Object Naming Guidelines
* Syntax for Schema Objects and Parts in SQL Statements
* How Oracle Database Resolves Schema Object References