Announcements



Free Seminar on IT
Career in 30 Days

Read More



PMP Exam Preparation Course

Read More



Learn Oracle From Oracle Guru!! Oracle 11g DBA

Read More

Free Orientation Workshop 11g DBA

Posted on : 24-12-2009 | By : admin | In : Oracle Training

Tags: , , , ,

0

learn oracle from oracle guru

Oracle 11g Database Administrator

Posted on : 09-12-2009 | By : admin | In : Oracle Training

Tags: , , , ,

0

oracle-11g-guru

Free Oracle 10g SQL Certification Training

Posted on : 08-10-2009 | By : admin | In : Oracle Training

Tags: , , , , ,

0

Alliance Training and Solutions Offers
Free Oracle 10g SQL Certification
Training

Class Schedule

Start Date
16th October 2009

Days
Mon-Wed-Fri

Time
6:00 PM To 8:00PM

Course
Oracle 10g SQL

Cost
Absolutely Free

Quick Registeration

Your Name (required)

Your Email (required)

Contact Number (required)

Introduction to Oracle 10g SQL

Audience:

  • Application Developers
  • Business Intelligence Developer
  • Database Administrators
  • End Users
  • Portal Developer

Required Prerequisites:

  • Familiarity with Data Processing Concepts and Techniques
  • Ability to use a graphical user interface (GUI)

Course Objectives:

  • Retrieve row and column data from tables with the SELECT statement.
  • Employ SQL functions to generate and retrieve customized data.
  • Run data manipulation statements (DML) to update data in the Oracle Database 10g.
  • Control user access and manage schema objects
  • Search data using advanced sub queries

 

Oracle R12 System Administrator Fundamentals

Posted on : 26-08-2009 | By : admin | In : Oracle Training

Tags: , , ,

0

Audience:

  • Application Developers
  • Functional Implementer
  • Support Engineer
  • Technical Administrator

Suggested Prerequisites:

  • Navigate Oracle Applications Release 12

Course Objectives:

  • Implement function security
  • Implement Oracle User Management
  • Implement flexfields
  • Manage the Oracle E-Business Suite with Oracle Applications Manager
  • Describe Oracle Workflow
  • Understand concurrent processing
  • Describe diagnostics and troubleshooting tools for Oracle E-Business Suite
  • Define profile option values
  • Set up auditing
  • Set up printing
  • Manage folders

Course Topics:

Function Security

  • Users
  • Custom Applications
  • Menus
  • Responsibilities
  • Functions

Data Security

  • Objects
  • Grants
  • Permissions and Permission Sets
  • Data Security Policies

Oracle User Management

  • Access Control Model
  • Role Based Access Control
  • Delegated Administration
  • Self-Service and Approval features

Profile Options

  • Personal Profile Values
  • System Profile Values
  • Profile Hierarchy Levels
  • Profile Categories

Auditing System Resources

  • Auditing User Activity
  • Signon Audit

Printers

  • Printer Components
  • Printing with the Pasta printing feature
  • Using Pasta with Oracle XML Publisher

Oracle Applications Manager (OAM)

  • Benefits of Oracle Applications Manager
  • OAM Dashboard
  • OAM Site Map
  • System Monitoring
  • Diagnostic Tools in OAM
  • Support Cart

Concurrent Programs and Requests

  • Lifecycle of a Concurrent Request
  • Managing Concurrent Requests
  • Request Sets
  • Viewing Request Output
  • Defining a Custom Concurrent Program

Administering Concurrent Managers

  • Generic Service Management (GSM)
  • Concurrent Managers
  • Concurrent Manager Workshifts
  • Conflict Domains
  • Internal Concurrent Managers
  • Internal Monitors
  • Transaction Managers
  • Parallel Concurrent Processing

Oracle Workflow

  • Business Processes
  • System Integration with Oracle Workflow
  • Workflow Architecture
  • Workflow Engine
  • Workflow Builder
  • Notification System
  • Workflow Manager
  • Directory Services

Flexfields

  • Key Flexfields
  • Descriptive Flexfields
  • Value Sets
  • Validation of Flexfield Segment Values

Folders

  • Folder Definitions
  • Assigning Folders to Users and/or Responsibilities

Online Help System

  • Customizing Help Files
  • Help System Utility
  • Help Builder

<<Back

Oracle R12 System Administrator

Posted on : 26-08-2009 | By : admin | In : Oracle Training

Tags: , , ,

0

Administrators of the Oracle Applications environment are expected to deliver high system availability and high performance to their end-users. Oracle E-Business Suite R12 System Administrator Certified Experts can effectively manage the Oracle R12 Applications environment and architecture. They also exhibit proven competency in foundational skills required to highlight the key parameters necessary to analyze system activity and performance.

.Certification Path:

Module No. of Exam Paper Exam Fee
Module I I R12 Oracle: System Administrator US$ 195/-

Training cost: PKR 30,000.00 inclusive of course material hands on form requirements exam guide & dumps.

Training cost: One Month or 5 Days Corporate Package.

Oracle R12 Install Patch and Maintainence

Posted on : 26-08-2009 | By : admin | In : Oracle Training

Tags: , , ,

0

Audience:

  • Database Administrators
  • Functional Implementer
  • Technical Administrator
  • Technical Consultant

Required Prerequisites:

  • Understanding of the three-tier software architecture as used by Oracle Applications
  • Experience of using relational database management systems
  • Basic knowledge of database administration tasks
  • Basic knowledge of system administration tasks

Course Objectives:

  • Install Oracle Applications
  • Apply patches to an Oracle Applications system
  • Run standard Oracle Applications maintenance utilities
  • Describe Oracle Applications architecture
  • Describe key features of the Oracle Applications database
  • Gain an overview of Oracle Applications
  • Understand and use AutoConfig
  • Understand and use License Manager
  • Clone Oracle Applications
  • List advanced configuration options

Course Topics:

Oracle Applications Overview

  • Oracle E-Business Suite Home Page
  • HTML Interface
  • Forms Interface
  • Oracle Applications Architecture
  • Oracle Applications Technology Stack
  • Product Families
  • Product Dependencies
  • Vision Demo Database

Preparing for an Installation

  • Overview of Rapid Install
  • Release 12 Platform Support
  • System Requirements
  • Creating Operating System Accounts
  • Setting Up Stage Area
  • Specifying an Installation Environment
  • Selecting Configuration Parameters
  • Rapid Install Log Files

Performing an Installation

  • Overview of Basic Installation Procedure
  • Simplest Installation
  • More Typical Installation
  • Standard Installation Steps
  • Overview of Express Installation
  • Express Installation Steps

Finishing an Installation

  • Logging In to Oracle Applications
  • Changing Default Passwords
  • Configuring Database Initialization Parameters
  • Reviewing Security Practices
  • Implementing Product and Country-Specific Functionality
  • Configuring Client Software
  • Carrying out Conditional Tasks
  • Backing Up Oracle Applications

Oracle Applications Components

  • Oracle Applications Multi-Tier Architecture
  • Oracle Homes Architecture
  • Oracle Applications Technology Layer
  • Oracle Applications DBA
  • Oracle Application Object Library
  • Oracle Applications Utilities
  • Oracle Applications Framework
  • Oracle Applications Manager

Environment Files, Control Scripts, and Languages

  • Environment Files
  • Application Tier Server Control Scripts
  • Modifying Environment Files
  • Oracle Applications Languages
  • Character Sets
  • Globalization and Country-Specific Functionalities
  • Dates and Numbers
  • National Language Support (NLS)

Oracle Applications File System

  • Database Tier File System
  • Application Tier File System
  • Product Directories
  • APPL_TOP Directories
  • Common Components Directory
  • Java Files and Directories
  • Applications Technology Stack Directory
  • Database Directories

Oracle Applications Database

  • Oracle Applications Database Objects
  • Database Schemas and Oracle Applications Product Schemas
  • Overview of Database Features
  • Monitoring Features
  • Performance Features
  • Scalability Features
  • Business Intelligence Features
  • Database Tier Server Process Scripts

Advanced Configuration Options

  • Shared Application Tier File System
  • Load Balancing
  • Network Features

Oracle Applications AD Utilities

  • Overview of the AD Utilities
  • Running the AD Utilities
  • Command Line Arguments
  • Parallel Processing
  • Distributed AD
  • Log Files
  • Maintenance Mode
  • Restricted Mode

AD Administration

  • Generate Applications Files Tasks
  • Maintain Applications Files Tasks
  • Maintain Database Entities Tasks
  • Compile/Reload Database Entities Tasks
  • Non-Interactive Operation and Maintenance Mode

Special Utilities

  • AD Controller
  • Reviewing Worker Status and Resolving a Failed Worker
  • Restarting a Failed Patch Process
  • Restarting a Terminated Worker
  • Running AD Relink

AutoConfig

  • Context Files
  • AutoConfig Tasks
  • AutoConfig Operation
  • Running AutoConfig
  • AutoConfig Log Files
  • Rolling Back an AutoConfig Session
  • Running AutoConfig In Test Mode
  • Editing Parameters

License Manager

  • Accessing License Manager
  • Registering Products
  • Registering the E-Business Suite
  • Registering Component Applications
  • Registering Individual Products
  • Registering Country-Specific Functionalities
  • Registering Languages
  • License Manager Reports

Reporting Utilities

  • Introduction to Reporting Utilities
  • AD Configuration
  • AD File Identification
  • AD Job Timing Report

Configuration Utilities

  • Introduction to Configuration Utilities
  • AD Splicer
  • File Character Set Converter

Patching and the AutoPatch Process

  • Patch Types and Terminology
  • Patch Components
  • Downloading Patches from OracleMetaLink
  • AutoPatch Operation
  • AutoPatch Features
  • Applying a Patch
  • Reducing Patching Downtime
  • Patch Wizard

Running AutoPatch

  • AutoPatch Setup
  • AutoPatch Usage and Prompts
  • Patch File Name and Location
  • AutoPatch Messages
  • Patch History
  • Timing Report
  • Log Files
  • Follow-Up Tasks

OAM Timing Reports

  • Overview
  • Timing Reports Main Page
  • AutoPatch Timing Details
  • Tracking a Patch Session
  • AD Administration Timing Details
  • Job Timing Report
  • Phase Information Report
  • Exceptions Report

Other Patching Topics

  • AutoPatch Modes
  • AutoPatch Command Line Arguments and Options
  • Java Release Infrastructure and Java File Patching
  • Deploying Patches
  • Merging Patches with AD Merge Patch

Applied Patches Information

  • Applied Patches Information and AutoPatch Modes
  • Accessing Applied Patches Information
  • Applied Patches: Simple and Advanced Searches
  • File History: Simple and Advanced Searches
  • Applied Patches Reports

Cloning Oracle Applications

  • Principles and Terminology
  • Prerequisite Steps
  • Cloning Phases
  • Prepare the Source System
  • Copy Source System Files to Target System
  • Configure the Target System
  • Finishing Tasks
  • Advanced Cloning Options

<<Back

Oracle R12 Apps. DBA Training

Posted on : 26-08-2009 | By : admin | In : Oracle Training

Tags: , , ,

0

Oracle professionals demonstrate the complete set of skills that are required for working independently as an Applications Database Administrator Certified Professional. Not only does an Oracle Applications Database Administrator assume the role of a database administer, but also focuses on administering many of the components for the Oracle Applications Release R12 as well as database versions Oracle10g and Oracle11g. Effectively managing Oracle Applications requires an understanding of the underlying architecture, configuration including, monitoring, performance tuning, troubleshooting, and patching.

Certification Path:

R12-Apps-DBA

Module No. of Exam Paper Exam Fee
Module I I R12 Oracle: Install, Patch, and Maintain Oracle Applications US$ 195/-

Training cost: PKR 30,000.00 inclusive of course material hands on form requirements exam guide & dumps.

Training cost: One Month or 5 Days Corporate Package.

Oracle R12 Advance Supply Chain Planning Fundamentals

Posted on : 26-08-2009 | By : admin | In : Oracle Training

Tags: , , , ,

0

Audience:

  • Functional Implementer
  • End Users
  • Project Manager

Required Prerequisites:

  • R12 Oracle E-Business Suite Essentials for Implementers

Suggested Prerequisites:

  • Basic Planning Knowledge
  • Basic knowledge of Bill of Material principles
  • R12 Oracle Inventory Management Fundamentals

Course Objectives:

  • Describe Oracle Advanced Supply Chain Planning product
  • Use Planner Workbench
  • Create unconstrained plans
  • Describe demand and supply
  • Describe how to create a supply chain
  • Review collections
  • Analyze unconstrained plan results
  • Describe constrained plan
  • Analyze enforce capacity constraints plan results
  • Analyze decision rule plan results
  • Analyze enforce demand due dates plan results
  • Describe optimized plans
  • Describe global forecasting
  • Simulate plan changes
  • Describe planning strategies

Course Topics:

Advanced Supply Chain Planning

  • Planning business issues
  • Oracle Advanced Supply Chain Planning
  • Plan types
  • Implementation progression
  • Planning business flow
  • Planning data flow

Planning Data and Planner Workbench

  • Data for planning
  • Planner Workbench
  • Researching data for planning
  • Planning results
  • Planner strategies
  • Copy plans

Unconstrained Plans

  • Planning concepts
  • Creating plans

Demand and Supply

  • Demand types
  • Sales orders
  • Forecast consumption
  • Supply types

Modeling the Supply Chain

  • Enterprise
  • Material
  • Resource
  • Sourcing
  • Suppliers
  • Calendars, lead times, and time fences
  • Transportation

Collections

  • Collections
  • Collection exceptions

Analyzing Unconstrained Plans

  • Exceptions
  • Personal queries
  • Unconstrained exception messages
  • Recommendations

Constrained Plans

  • Constrained plans
  • Constraints
  • Demand priority rules
  • Aggregation levels
  • Advanced details
  • Calendar
  • Plan options

Queries

  • Personal queries
  • Public queries

Constrained – Enforce Capacity Constraints Plans

  • Constrained plans
  • Exceptions
  • Other information
  • Details

Constrained – Enforce Capacity Constraints with Decision Rules Plan

  • Constrained plans
  • Plan options
  • Decisions
  • Concepts

Constrained – Enforce Demand Due Dates Plans

  • Constrained plans
  • Exceptions

Cost-Based Optimized Plans

  • Plan options
  • Concepts
  • Objectives
  • Penalties
  • Constraints and key indicators
  • Plan differences

Global forecasting

Integrating ASCP

  • Production Scheduling
  • Strategic Network Optimization
  • Demantra

Planning Strategies

  • Simulation
  • Planning strategies

<<Back

Oracle EBS R12 Advance Supply Chain Planning

Posted on : 26-08-2009 | By : admin | In : Oracle Training

Tags: , , , ,

0

The ability to execute a plan is the difference between success and failure. Moving to an Advanced Planning System such as ASCP often enables a change in the planning process and allows a company to drive greater disciplines in other departments to get the most out of their planning process. Oracle EBS R12 Advanced Supply Chain Planning Certified Expert Consultants can help an organization evaluate, plan, configure and introduce the new planning environment into the organization.

Oracle EBS R12 Advanced Supply Chain Planning Certified Expert Consultants can present an integrated set of services that can assist the customer in driving real value from the medium term decision making, and make the best use of the supply chain resources.


Certification Path:

R12-supply-chain-planning

Module No. of Exam Paper Exam Fee
Module I I E- Business Essentials US$ 95/-
Module II II Advance Supply Chain Planning Fundamentals US$ 195/-

Training cost: PKR 42,000.00 inclusive of course material hands on form requirements, exam guide & dumps.

Duration: One Month or 7 Days Corporate Package.

Oracle R12 Order Management Fundamentals

Posted on : 26-08-2009 | By : admin | In : Oracle Training

Tags: , , , ,

0

Audience:

  • Functional Implementer

Required Prerequisites:

  • Navigating Oracle Applications
  • E-Business Suite Essentials for Implementers
  • Navigating Oracle Applications 11i Self-Study CD Course
  • R12 Oracle E-Business Suite Essentials for Implementers

Suggested Prerequisites:

  • Inventory Management Fundamentals
  • Financials Functional Foundation
  • R12 Oracle Inventory Management Fundamentals
  • R12 Oracle Financials Functional Foundation

Course Objectives:

  • Create and use price lists, modifiers, qualifiers, and price books
  • Explain shipping flows within the order-to-cash lifecycle
  • Set up and use shipping entities to perform shipping-related activities
  • Set up multiple organization access control for Oracle Order Management
  • Define subinventories, units of measure, and items
  • Create available-to-promise rules
  • Define customers, invoice information, and credit checking
  • Explain tax-related setup steps
  • Set up profile options and system parameters
  • Set up processing constraints, defaulting rules, and transaction types
  • Use scheduling and workflow
  • Define holds
  • Purge orders
  • Manage exceptions
  • Execute the order-to-cash lifecycle with different order types

Course Topics:

Overview of Oracle Order Management

  • Overview of Oracle Order Management
  • What is Oracle Order Management?
  • Order Capture and Order Fulfillment
  • Oracle Order Management Capabilities
  • Order to Cash Lifecycle
  • Integration with Other Products

Order Entities and Order Flows

  • Order to Cash Lifecycle with Standard Items
  • Order to Cash Lifecycle with PTO Models and PTO Kits
  • Drop Shipments
  • Drop Shipments Across Ledgers
  • Back-to-Back Orders
  • Sales Agreements
  • Negotiation Agreement
  • Approve Sales Agreement

Multiple Organization Access Control Setup

  • Organization Structure in Oracle Applications
  • Multi-Org Access Control (MOAC)
  • Using MOAC in Oracle Order Management
  • Setting Up MOAC

Oracle Inventory Setup for Oracle Order Management

  • Receipt to Issue Lifecycle
  • Inventory Organizations
  • Setting Up Locations
  • Inter-organization Shipping Networks
  • Unit of Measure Conversions
  • Order Management Item Attributes
  • Item Relationships

Oracle Receivables Setup for Oracle Order Management

  • Overview of Trading Community Architecture
  • Key Customer Related Concepts in TCA
  • Adding Customers in Order Management
  • Defining Payment Terms
  • Defining Territories in Receivables
  • Defining Invoice Sources (Batch Source) – Automatic Transaction Numbering

Oracle Order Management Setup Steps

  • Overview of Quick Code or Lookup Types
  • Overview of Transaction Types Window
  • Workflow in Transaction Types
  • Setting up Processing Constraints
  • Defining Defaulting Rules
  • Setting up Versioning and Audit History
  • Auto-Schedule Profile Option
  • Defining Credit Usage Rule Sets

Holds, Order Purge, and Exception Management Setup

  • Seeded Holds
  • Generic Holds
  • Order and Quote Purge
  • Purge Sets

Basic Pricing Setup

  • Overview of Pricing in the Order to Cash Process
  • Creating a Price List
  • Secondary Price List
  • Copy Price List
  • Price List Maintenance: Overview
  • Add Items to Price List
  • Implementation Steps: Setting Key Profile Options

Overview of Shipping Execution

  • Shipping Execution Flow
  • Delivery and Delivery Lines
  • Trips and Stops
  • Delivery Leg
  • Ship Confirm

Shipping Execution Setup

  • Granting Roles To Users
  • Freight Carriers
  • Transit Times
  • Delivery Compliance Screening
  • Running Pick Release
  • Pick Slip Grouping Rule
  • Auto create Deliveries
  • Release Sales Orders for Picking Window

<<Back