ORACLE Trainings

  • Curriculum
  • OVERVIEW
  • Oracle 10g
  • Oracle Developer 11g
  • Oracle Finance
  • Advanced SQL
  • Oracle HRMS
  • Oracle Manufacturing
  • Oracle Application DBA
  • Oracle 11g DBA
  • Oracle Inventory
Introduction to Oracle 10g Level 1 Training

Oracle 10g Level1 Training Overview

In this database administration course students gain the skills necessary for basic day-to-day administration of an Oracle10g database. This Oracle training class is the starting points for Oracle database administrators and also sets the foundation for advanced administrator training and certification.

The class target audience is Oracle database administrators. Additionally, senior database developers will benefit from an understanding of the architecture of the Oracle database with which they interface.

Oracle 10g Level1 Training Class Goals

  • Learn to install Oracle software and create new databases.
  • Explore the database architecture, including memory, process and data structures, and the management of those structures.
  • Learn to manage database files.
  • Learn to manage security policies and procedures, including administration of user accounts, roles, privileges and profiles.
  • Learn to use advanced self-tuning and self-management capabilities, including Oracle-Managed Files, database Advisors and other components of the Management Framework.
  • Learn to monitor performance, troubleshoot problems, and resolve lock and conflict issues.
  • Learn to use the Oracle Enterprise Manager and SQL interfaces for administration tasks.
  • Learn to control database support services, including iSQL*Plus, the Database Control, Oracle Net and others.
  • Learn about basic backup and recovery structures and strategies.
  • Explore operating system-specific considerations for Unix, Linux and MS Windows.

Oracle 10g L1 Courseware

    1. Installing Oracle 10G Database Software
      1. Identify Database System Requirements
      2. The Optimal Flexible Architecture (OFA)
      3. Configure the Installation Environment
      4. Installation Using the Universal Installer
      5. More About Enterprise Manager
    2. Exploring the Oracle Database Architecture
      1. General Database Architecture
      2. Database Instance Memory Architecture
    3. Database Instance Process Architecture
      1. About the Instance Process Architecture
      2. Instance Background Processes
      3. Sql Execution Processes
    4. Creating an Oracle Database
      1. Create a Database
      2. Configure & Drop a Database
      3. Manage DBCA Templates
      4. Manually Creating a Database
    5. Controlling the Database Environment
      1. Starting & Stopping Database Control
      2. Starting & Stopping Isql*Plus
      3. Starting & Stopping the Database Listener
      4. Starting & Stopping the Database
      5. More About the Database Files
      6. Handling Parameter Files & Parameter Settings
    6. Storage Structures: Tablespaces
      1. About Tablespaces
      2. Tablespace Management
    7. Storage Structures: Data Files & Temp Files
      1. Managing Data Files
      2. Managing Temp Files
      3. About Oracle-Managed Files (OMF)
    8. Undo Management
      1. About Undo Space Management
      2. Configure Undo Management
      3. Guarantee Undo Retention
      4. Monitor Undo Space
      5. Use the Undo Advisor
    9. Database Security
      1. Database System Privileges
      2. Database Object Privileges
      3. Audit Database Activity
      4. Register For Security Updates
    10. Administering Users
      1. Create & Manage Database Accounts
      2. Grant & Revoke Database Privileges
      3. Resource Limits Via Profiles
      4. Password Management Via Profiles
      5. About Role-Based Security
    11. Managing Data: Loading Data With Sql Loader
      1. About the Database Utilities
      2. Using the Loader
      3. Understanding the Loader Process
      4. Control File Options
      5. Direct Path Loads
    12. Managing Data: Exporting & Importing Data
      1. Create Directory Objects
      2. EXPDP
      3. IMPDP
    13. Oracle Net Services
      1. What Is Oracle Net Services?
      2. Oracle Net Manager
      3. Listener Configuration
      4. Listener Administration
      5. Lsnrctl Commands
      6. Configuring Client Parameters
      7. Isolating the Problem
      8. Oracle Trace Assistant
      9. Network Troubleshooting Utilities
    14. Monitoring & Resolving Lock Conflicts
      1. About Latches & Locks
      2. More About Latches
      3. More About Locks
    15. Backup & Recovery Concepts
      1. About Database Backup & Recovery
      2. About Redo Data
      3. Redo Log File Maintenance
      4. Managing the Archive Options
      5. More About the Control File
    16. Storage Structures: Advanced Tablespaces (if time allows)
      1. More About Temporary Tablespaces
      2. About Temporary Tablespace Groups
      3. More About Permanent Tablespaces
      4. More About Bigfile Tablespaces
      5. More About the SYSAUX Tablespace
    17. Oracle Shared Servers (if time allows)
      1. Shared Servers Architecture
      2. Configuration Of Shared Server Mode

Module I [SQL]

  • Retrieving Data Using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables
  • Using Subqueries to Solve Queries
  • Using the Set Operators
  • Manipulating Data
  • Using DDL Statements to Create and Manage Tables
  • Creating Other Schema Objects

 

Module II [Oracle 11g: PL/SQL Fundamentals]

  • Introduction to PL/SQL
  • Explain the need for PL/SQL
  • Explain the benefits of PL/SQL
  • Identify the different types of PL/SQL block
  • Output messages in PL/SQL
  • Declaring PL/SQL Variables
  • Recognize valid and invalid identifiers
  • List the uses of variables, declare and initialize variables, use bind variables
  • List and describe various data types using the %TYPE attribute
  • Writing Executable Statements
  • Identify lexical units in a PL/SQL block
  • Use built-in SQL functions in PL/SQL and sequences in PL/SQL expressions
  • Describe when implicit conversions take place and when explicit conversions have to be dealt with
  • Write nested blocks and qualify variables with labels
  • Write readable code with appropriate indentation
  • Interacting with the Oracle Database Server
  • Create PL/SQL executable blocks using DML and transaction control statements
  • Make use of the INTO clause to hold the values returned by a SQL statement
  • Writing Control Structures
  • Identify the uses and types of control structures (IF, CASE statements and expressions)
  • Construct and identify loop statements
  • Apply guidelines when using conditional control structures
  • Working with Composite Data Types
  • Create user-defined PL/SQL records
  • Create a record with the %ROWTYPE attribute
  • Create an INDEX BY table and INDEX BY table of records
  • Describe the differences among records, tables, and tables of records
  • Using Explicit Cursors
  • Distinguish between usage of implicit and explicit cursors, use SQL cursor attributes
  • Declare and control explicit cursors, use simple loops and cursor FOR loops to fetch data
  • Declare and use cursors with parameters
  • Lock rows with the FOR UPDATE clause and reference the current row with the WHERE CURRENT OF clause
  • Handling Exceptions
  • Define PL/SQL exceptions
  • Recognize unhandled exceptions
  • Handle different types of exceptions (pre-defined exceptions, non-predefined exceptions and user-defined exceptions)
  • Propagate exceptions in nested blocks and call applications
  • Creating Stored Procedures and Functions
  • Differentiate between anonymous blocks and subprograms
  • Create a simple procedure and invoke it from an anonymous block
  • Create a simple function
  • Create a simple function that accepts a parameter
  • Differentiate between procedures and functions

Module III [Oracle 11g: Forms & Reports]

  • Introduction to Oracle Forms Developer and Oracle Forms Services
  • Running a Forms Developer Application
  • Creating LOVs and Editors
  • Creating Additional Input Item
  • Creating Noninput Items
  • Creating Windows and Content Canvases
  • Working with Other Canvas Types
  • Introduction to Triggers
  • Working in the Forms Developer Environment
  • Creating a Basic Form Module
  • Working with Data Blocks and Frames
  • Working with Text Items
  • Producing Triggers
  • Debugging Triggers
  • Adding Functionality to Items
  • Run Time Messages and Alerts
  • Query Triggers
  • Validation
  • Navigation
  • Transaction Processing
  • Writing Flexible Code
  • Sharing Objects and Code
  • Introducing Multiple Form Applications
  • Creating a Menu Module
  • Managing Menu Modules
  • Programming Function Keys
  • Building Multiple Form Applications
  • Defining Data Sources
  • Working with Record Groups
  • Using Database Objects in Forms Applications

Oracle Finance on E-Business Suite R12

Duration: 50 Hours

Pre Requisite: Basic Knowledge Finance

Training Type: In-Class / Online

R12 E-Business Suite Essentials for Implementers

  • Overview of Essentials for Implementers
  • Navigating in R12 Oracle Applications
  • Introduction to R12 Oracle Applications
  • Shared Entities and Integration
  • Fundamentals of System Administration
  • Standard request submission (SRS)
  • Fundamentals of Multiple-Organization and
  • Multiple-Organization Access Control
  • (MOAC)
  • Fundamentals of Oracle Work-flow & Alerts
  • Fundamentals of Daily Business Intelligence
  • and Oracle Fusion Business Intelligence

R12 Oracle General Ledger Management Fundamentals

  • Oracle General Ledger Process
  • Accounting Setup Manager
  • Ledger
  • Basic Journal Entries
  • Using Accounting Setup Manager
  • Summary Accounts
  • Advanced Journal Entries
  • Advanced Security
  • Financial Budgeting
  • Consolidations
  • Period Close
  • Financial Reporting

R12 Oracle Payables Management Fundamentals 

  • Procure to Pay Overview
  • Payables Overview
  • Suppliers
  • Invoices
  • Payments
  • Expense Reports and Credit Cards
  • Period Close
  • 1099 Reporting
  • Transaction Taxes in Payables
  • Withholding Tax
  • Advances and Progressive Contract
  • Financing

R12 Oracle Receivables Management Fundamentals 

  • Order to Cash Lifecycle Overview
  • Overview of Oracle Receivables Process
  • Manage Parties and Customer Accounts
  • Process Invoices Using Auto-Invoice
  • Process Invoices
  • Bill Presentment Architecture
  • Credit Management
  • Implement Customer Invoicing
  • Receipts
  • Implement Receipts
  • Tax Processing
  • Period Closing

R12 Oracle Cash Management Fundamentals

  • Oracle Cash Management Overview
  • Cash Management Security
  • Setting Up Oracle Cash Management
  • Creating Bank Accounts
  • Bank Transfers
  • Managing Bank Statements
  • Reconciling Bank Statements
  • Cash Pools
  • Cash Positioning
  • Cash Forecasting
  • Accounting Events
  • Balances and Interest

R12 Oracle Asset Management

Fundamentals

  • Overview of Oracle Asset Management
  • Asset Controls Setup
  • Asset Books
  • Asset Categories
  • Mass Asset Additions
  • CIP Asset Additions
  • Asset Adjustments and Maintenance
  • Depreciation
  • Asset Retirements
  • Asset Accounting
  • Asset Inquiry and Reporting
  • Tax Accounting
Introduction to Advanced SQL with Oracle Training
Advanced SQL with Oracle Training Overview

This Oracle SQL training class helps students master SQL using an Oracle database and prepares students for a PL/SQL course. Note that this course is an Oracle SQL course, not a PL/SQL course.

Advanced SQL with Oracle Training Class Goals
  • Learn to create Users and Schemas.
  • Learn to use pseudo-columns and functions.
  • Learn to write simple and correlated subqueries.
  • Learn to write simple and complex joins.
  • Learn to use ROLLUP and CUBE.
  • Learn to use SET operators.
  • Learn to use character and non-character SQL functions.
  • Learn to write INSERT, UPDATE, and DELETE statements.
  • Learn to create tables.
  • Learn to use keys and constraints to protect data integrity.
  • Learn to use views, indexes, sequences, and synonyms.
Advanced SQL With Oracle Courseware
  1. Users and Schemas
    1. Introduction to Users and Schemas
    2. Definitions and Client Tools
    3. SQL Developer Login
    4. About the HR Schema
    5. Sample Schemas
    6. HR Schema Entities
    7. Creating An Application Schema
    8. Exercise: Create a User
  2. Pseudo Columns & Functions
    1. Using The Dual Table
    2. Functions
    3. Exercise: Use the SYSCONTEXT function
    4. Pseudo-Columns
    5. Using Rowid
    6. Using Rownum
    7. Exercise: Use ROWNUM
  3. Using Subqueries
    1. Simple Subqueries
    2. Definition
    3. Nested Subquery
    4. Inline Views
    5. Subquery in the HAVING clause
    6. Correlated Subqueries
    7. Scalar Subquery
    8. Exercise: Subqueries
  4. Joining Tables
    1. Review of Joins
    2. Equijoins
    3. Inner Joins
    4. Outer Joins
    5. Cross Joins
    6. Reflexive Join
    7. Non-Key Join
    8. Natural Joins
    9. Semijoins and Antijoins
    10. Using Named Subqueries
    11. Exercise: Join Exercises
  5. Enhancing Groups With Rollup & Cube
    1. About Group Processing
    2. EMP_DETAILS_VIEW
    3. Simple GROUP BY
    4. ROLLUP Function
    5. GROUPING Function
    6. Using Cube
    7. Exercise: Practice GROUP BY, ROLLUP and CUBE
  6. Using Set Operators
    1. Set Operators Defined
    2. Relationship to Mathematical Set Theory
    3. Restrictions on Set Operators
    4. Exercise: Set Operators Exercise
  7. Conditional Processing
    1. The DECODE Function
    2. The Case Expression
    3. Exercise: Conditional Processing
  8. SQL Functions (Character)
    1. What Are SQL Functions?
    2. Character Functions
    3. CONCAT
    4. LENGTH
    5. INSTR
    6. REPLACE
    7. UPPER
    8. LOWER
    9. INITICAP
    10. LPAD
    11. RPAD
    12. TRIM
    13. TO_CHAR
    14. SOUNDEX
    15. Regular Expressions
    16. Exercise: Character Functions
  9. SQL Functions (Non-Character)
    1. Numeric Functions
    2. The TO_CHAR Function with numbers
    3. Date/Time Functions
    4. Date Format Functions
    5. Date Arithmetic Functions
    6. Null Value Functions
    7. Exercise: SQL Non-Character Functions
  10. SQL Data Manipulation Language
    1. The INSERT Statement
    2. INSERT Statement Categories
    3. The UPDATE Statement
    4. The DELETE Statement
    5. Transactions
    6. Complex Table References
    7. The MERGE statement
    8. Exercise: Data Manipulation Language (DDL)
  11. SQL Data Definition Language
    1. About SQL DDL
    2. Create Table Statement
    3. Populate the table
    4. Alter Table Statement
    5. Drop Table Statement
    6. CREATE TABLE using SELECT
    7. Truncate Table Statement
    8. Exercise: Data Definiton Language (DDL)
  12. Data Integrity Using Constraints
    1. About Constraints
    2. Unique Key
    3. Primary Key
    4. Referential Integrity
    5. Check Constraint
    6. Defining Constraints On Existing Tables
    7. Enabling & Disabling Constraints
    8. Renaming & Dropping Constraints
    9. Validate New Transactions Only
    10. Deferred Enforcement
    11. Constraint Exceptions
    12. Constraints And Views
    13. Exercise: Create Constraints Exercise
  13. Database Objects: Overview
    1. Database Objects
    2. Exercise: All Object Types
  14. Database Objects: Views
    1. Creating Views
    2. Updating View Data
    3. INSERT and UPDATE Statements
    4. DELETE Statements
    5. Exercise: Creating a View
  15. Database Objects: Indexes
    1. Types of Indexes
    2. Index Characteristics
    3. Index Usage
    4. Exercise: Index Exercise
  16. Other Database Objects
    1. Sequences
    2. Synonyms
    3. Stored Procedures, Functions and Triggers
    4. Exercise: Sequence and Synonym Exercise
Introduction to Oracle Apps Functional HRMS

Core HR:

Core HR System Administration

    • Responsibility
    • User Management
    • Menu
    • Functions
    • Flex fields
    • SIT and EIT
    • Security
    • Lookups
    • Value sets
    • Working with Custom responsibility

Core HR Setups

    • Person Types
    • Assignment Status
    • Work Structure
    • Locations
    • Business Group
    • Organizations
    • Organization Hierarchy
    • Jobs
    • Position
    • Grades

1. Direct Grades
2. Indirect Grades

    • Recruitment
    • Workforce management ( Hiring – Transfer / Promotion / Terminating )
    • Performance management ( Competence management / Appraisal )

Payroll:

  • Earning and Deduction Elements
  • Salary Basis
  • Payment Methods
  • Consolidation Set
  • Payroll
  • Payroll run with the entry values
  • Payroll run using the Input values
  • Payroll run with the Data base items
  • Using Global values
  • Proration
  • Retro Pay
  • Advanced Pay
  • Rollback
  • Rollback Run
  • Retry Run
  • Fast Formulas

SSHR:

Oracle applications Functional HRMS

  • What  is Self Service HR
  • Different Users in SSHR
  • Key Features
  • Approvals in SSHR
  • Functions of SSHR
  • Working with Employee and Manager Self Services
  • Configuration and Security  in SSHR

iRecruitment:

Benefits of iRecruitment
Process Flow of iRecruitment
Vacancies & Job Posting

    • Learning about Vacancies
    • Default Job Posting Descriptions
    • Creating Vacancies
    • Posting Vacancies to multiple Recruiting Sites
    • Managing Vacancies

Site Visitors & Registered Users

    • Using Site Visitor Functionality
    • Searching for Jobs
    • Registering in iRecruitment
    • Creating User Account details include a resume online
    • Applying & monitoring jobs applications

Candidate Processing

    • Learn about different search options
    • Searching the Prospect Pool, Resumes, and Individuals
    • Processing candidates and using different options
    • Inviting applicant to apply for job

Working with Applicants

    • Viewing Applicants details
    • Progressing Applicants
    • Creating Offers for applicants
    • Managing Offers
    • Hiring Applicants

OLM:

  • Different OLM Users
  • Configuration and Security  in OLM
  • Menus and Responsibilities
  • Profile Options
  • Enrollment Status
  • Delivery Mode
  • Administration and Organization
  • Define Location
  • Define Training Organization
  • Catalog  Management
  • Define Catalog Hierarchical Structure
    • Catalog
    • Sub Catego
    • Class

Oracle applications Functional HRMS

  • Delivery Modes
  • Session
  • Sub Sessions
    • Define Learning Path
    • Resource Management
    • Define  Training Resource Key Flex-Field
    • Define Resources
    • Booking Resources

 

1. Business Process Identification

There are different business flows as well as module clusters that a student intends to learn. The combinations are as follows.

  1. Oracle Supply Chain or Distributions :
    1. Oracle Inventory (Mandatory)
    2. Oracle Purchasing (Mandatory)
    3. Oracle Order Management (Mandatory)
    4. Oracle Internet Procurement (Optional)
    5. Oracle Internet Supplier (Optional)
    6. Oracle Sourcing (Optional)
  1. Oracle Manufacturing or Discreet Manufacturing :
    1. Oracle Inventory (Mandatory)
    2. Oracle Purchasing (Mandatory)
    3. Oracle WIP (Mandatory)
    4. Oracle BOM (Mandatory)
    5. Oracle Engineering (Mandatory)
  1. Oracle Procure-To-Pay Cycle
    1. Oracle Inventory (Mandatory)
    2. Oracle Purchasing (Mandatory)
    3. Oracle Accounts Payables (Mandatory, with purchasing essentials)
    4. Oracle Internet Procurement (Optional)
    5. Oracle Internet Supplier (Optional)
    6. Oracle Sourcing (Optional)
  1. Oracle Order-To-Cash
    1. Oracle Inventory (Mandatory)
    2. Oracle Purchasing (Mandatory)
    3. Oracle Order Management (Mandatory)
    4. Oracle Accounts Receivables (Mandatory)

Note: We will be able to take up all the modules except detailed Accounts payables and Accounts Receivables

Oracle Applications DBA Workshop On Oracle E-Business Suite R 12

Course Pre-requisite: Oracle 10g or 11g DBA Knowledge Duration: 1 Month
Software Requirement: Oracle EBS R12, Oracle Enterprise Linux 5.5

Activities:

Day 1:

Understanding the Concept of Enterprise Resource Planning The Famous Three Tier Architecture

Understanding the Applications Components

Introduction to Database Server, Apache Web Server, Form Server, Report Server, Concurrent Manager Serer and other Server

Day 2:

Preparing the Environment of EBS R12 Installation Understanding the software and hardware requirements Installation of Oracle Enterprise of Linux 5.5 for EBS R12 Demonstration of downloading EBS software

Staging the software System Setup for Installation Performing the Installation

Day 3:

Finishing the Installation

Verifying the Oracle Applications Installation

For OCA and OCP

Module 1: Introduction to Oracle 11g SQL Chap 1: Introduction to Oracle 11g and SQL

Uniqueness of Oracle Database Suite

Time line of Oracle database and versions

Structure Query Language Overview (On Demand)

Fundamental of DBMS (On Demand)

Use of SQL

Format and Types of SQL and Other SQL

Oracle and SQL Relevance

SQL vs. SQL* Plus vs. SQL Developer

Chap 2: Writing Basic SQL Commands:

List of capabilities of SQL Select Statements Writing First SELECT statement

Selecting all or specific columns in Oracle Tables

Sorting Table Data from SELECT Statement using ORDER BY clause Selecting specific rows using SELECT command using WHERE BY clause Using ampersand (&) substitution variable in SELECT commands

Chap 3: Single Row SQL Functions:

Oracle Inventory
11i Receipt to Issue Overview
[  ] Describe the Receipt to Issue process
[  ] Explain the various ways of receiving Inventory and the types of Inventory receipts
[  ] Transfer and issue inventory
[  ] Explain the key integration points between inventory and other Oracle Applications

Duration: 1 hour

11i Defining Inventory Organizations
[  ] Describe the multi-organization structure in Oracle Applications
[  ] Describe a sample organizational structure
[  ] Describe the structure of an inventory organization
[  ] Use organizations to model an enterprise

Duration: 1 hour

11i Defining and Maintaining Items
[  ] Explain and define items
[  ] Explain organization assignments
[  ] Define Units of Measure
[  ] Explain and define item attributes and status codes

Duration: 1.5 hour

11i Defining and Maintaining Items
[  ] Define Item Master Organization
[  ] Define items and templates using your own part-numbering scheme
[  ] Enable attributes in item templates
[  ] Define item deletion constraints
[  ] Identify the setup options and implementation considerations

 

11i Inventory Controls
[  ] Create Subinventories
[  ] Explain the subinventory-locator relationship
[  ] Define revision control
[  ] Define lot control
[  ] Generate serial numbers
[  ] Describe Implementation Considerations
[  ] Explain Locator flexfield structure

Duration: 1 hour

11i Transaction Concepts
[  ] Define Transactions
[  ] Explain how transactions integrate with Oracle Applications
[  ] Explain the Oracle Inventory transaction flow
[  ] Define key transactions concepts
[  ] Explain Mobile Transactions

Duration: 1 hour

11i Transaction Setup
[  ] Define Transaction Managers, Transaction Types, and Transaction Reasons
[  ] Define a customized transaction
[  ] Explain Shipping Methods and Inter-organization shipping network
[  ] Define Movement Statistics and parameters
[  ] Define Inventory Account Aliases
[  ] Set Up Move Orders
[  ] Use Alerts, Notifications and Reports
[  ] Set up transaction Profile Options
[  ] Define implementation considerations for transactions

Duration: 2 hour

11i Issue and Transfer of Material
[  ] Explain Transaction Flows and Inventory Transactions
[  ] Define transaction options and restrictions
[  ] Perform Subinventory transfer
[  ] Perform a Miscellaneous transaction
[  ] Perform Inter-organization transfers
[  ] Enter and manage Receipts
[  ] Explain Receiving reports
[  ] Explain the Move order process flow
[  ] Perform Move orders
[  ] Perform transactions using a mobile device
[  ] Manage Shipments

Duration: 2 hour

11i Replenishment Concepts
[  ] Describe Inventory and Order planning
[  ] Describe Inventory Forecasting
[  ] Describe Oracle Inventory replenishment
[  ] Explain how mobile devices can be used for replenishment

Duration: 1 hour

11i Replenishment
[  ] Explain the various methods of Forecasting
[  ] Explain the steps for Reorder-point planning
[  ] Explain the Min-max planning process flow
[  ] Perform replenishment counting
[  ] Generate kanban cards
[  ] Set up available to promise (ATP)
[  ] Perform ATP checks
[  ] Set up inventory planning and forecasting profile options
[  ] Identify Implementation Considerations

Duration: 1 hour

11i Inventory Accuracy Concepts
[  ] Define ABC Analysis
[  ] Define Cycle Counting
[  ] Define Physical Inventory
[  ] Use Mobile Devices for inventory accuracy

Duration: 1 hour

11i Inventory Accuracy
[  ] Perform ABC Analysis
[  ] Create and run an ABC compile
[  ] Describe cycle count approval tolerance
[  ] Perform Cycle Count
[  ] Enter and approve cycle count
[  ] Perform Count Adjustments and Approvals

Duration: 1 hour

Total Duration 13 -14 Hours.

Oracle Purchasing
Procure to Pay Lifecycle Overview
[  ] Describe the key areas in the procure to pay process
[  ] Describe how the procure to pay process fits into the Oracle eBusiness suite of applications

Duration: 1 hour

Oracle Purchasing Process
[  ] Describe how the Procurement process fits into the Procure to Pay lifecycle
[  ] Describe the orerding process
[  ] Describe the key areas in the Procurement process
[  ] Identify Purchasing integration points
[  ] Identify Purchasing open interfaces and APIs

Duration: 1 hour

Enterprise Structure – Locations, Organizations, and Items
[  ] Describe the Oracle Applications Enterprise Structure
[  ] Define Inventory Organizations and Locations
[  ] Define Units of Measure
[  ] Define Item Categories and Catalogs
[  ] Describe Item Definition, Item Attributes and Attribute Controls
[  ] Define Items
[  ] Create Item Templates

Duration: 1 hour (Only if Inv is covered) otherwise 2 Hours

Suppliers
[  ] Define suppliers
[  ] Explain the Purchasing use of Suppliers and the flow of default values
[  ] Define supplier sites
[  ] Manage suppliers
[  ] Identify key reports
[  ] Describe Financials setup options and Profile options
[  ] Describe additional implementation considerations

Duration: 1 hour

RFQs and Quotations
[  ] Create RFQs
[  ] Create quotations
[  ] Identify key reports
[  ] Describe Purchasing setup options and Profile Options
[  ] Describe additional implementation considerations

Duration: 1 hour

Approved Supplier Lists and Sourcing Rules
[  ] Explain the role of Sourcing in Purchasing and define supplier statuses
[  ] Set up and use an approved supplier list
[  ] Set up and use sourcing rules
[  ] Describe how sourcing information defaults to requisitions and purchase orders
[  ] Set up Sourcing Profile Options
[  ] Describe additional implementation considerations

Duration: 1 hour

Requisitions
[  ] Explain the Requisition Lifecycle
[  ] Create purchase requisitions
[  ] Describe the various requisition actions that can be performed
[  ] Explain the Internal Requisition Process
[  ] Create Internal Requisition
[  ] Describe the Requisitions Open Interface
[  ] Indentify key reports
[  ] Describe setup options
[  ] Describe additional implementation considerations

Duration: 1 hour

Purchase Orders
[  ] Describe Purchase Orders and Purchase Order types
[  ] Create Standard Purchase Orders
[  ] Create Blanket Purchase Agreements and releases
[  ] Create Contract Purchase Agreements
[  ] Create Planned Purchase Orders
[  ] Describe purchasing document interfaces
[  ] Maintain purchase orders
[  ] Identify key reports
[  ] Describe setup options
[  ] Identify additional implementation considerations

Duration: 2 hour

Automating Document Creation
[  ] Use the AutoCreate window to automate the creation of purchase documents
[  ] Describe the benefits of AutoCreate
[  ] Use the Create Releases program to generate blankd purchase agreement releases
[  ] Describe how the PO Create Documents workflow can automatically create purchase documents without buyer intervention
[  ] Set up Profile Options
[  ] Identify additional implmentation considerations

Duration: 1 hour

Receiving
[  ] Describe the process of receiving goods
[  ] Describe receipt routing
[  ] Describe receipt processing methods
[  ] Create standard, express, and cascade receipts
[  ] Describe substitute receipts, unordered receipts, returns and corrections
[  ] Describe pay on receipt
[  ] Describe Receiving open Interface
[  ] Identify key reports
[  ] Set up Purchasing, Receiving and Profile options
[  ] Identify additional implmentation considerations

Duration: 1 hour (Not required if Inv is covered)

Document Security, Routing and Approval
[  ] Define your document security and access levels
[  ] Define your document approval and routing process
[  ] Create and assign approval groups
[  ] Identify key reports
[  ] Describe setup options
[  ] Identify additional implementation considerations

Duration: 1 hour

Purchasing Accounting
[  ] Describe the period closing process in Purchasing
[  ] Describe key accounts
[  ] Use foreign currency
[  ] Identify key reports
[  ] Describe setup options
[  ] Describe additional implementation considerations

Duration: 1 hour

Purchasing Administration
[  ] Identify Purchasing administration tasks
[  ] Describe Purchasing database maintenance
[  ] Identify important concurrent processes
[  ] Describe additional implementation considerations

Duration: 1 hour

Purchasing Setup Steps
[  ] Identify the key Purchasing setup steps
[  ] Describe key reports
[  ] Describe setup options and additional implementation considerations

Duration: 2 hour

Total Duration -14 Hours.

Oracle Order Management
Order to Cash Lifecycle
[  ] Explain the order to cash process from order entry through Bank reconciliation
[  ] Describe the order lifecycle
[  ] Describe application integration for order management

Duration: 1 hour

Oracle Order Management Process
[  ] Explain the positioning of Order Management in the Order to Cash lifecycle
[  ] Explain the Ship-to-Stock fulfillment model in Order Management
[  ] Explain the Internal orders fulfillment model in Order Management
[  ] Explain the Configure-to-order, ATO, and PTO fulfillment models in Order Management
[  ] Explain the Back-to-Back orders fulfillment model in Order Management
[  ] Explain the Drop-Ship to customers fulfillment model in Order Management
[  ] Explain customer relationships in order management
[  ] Describe various order entry methods

Duration: 2 hour

Items
[  ] Describe the Enterprise Structure
[  ] Describe considerations for defining inventory structure
[  ] Create and convert units of measure
[  ] Explain use of items by different modules in Oracle Applications
[  ] Describe item master organizations
[  ] Create an item and explain implementation considerations

Duration: 1 hour

Manage Parties and Customer Accounts
[  ] Describe the components and relationships of the Party Model
[  ] Create and manage profile classes
[  ] Explain how Data Quality Management (DQM) works
[  ] Import party information from external sources
[  ] Explain Trading Community Architecture (TCA)
[  ] Manage Party-Paying relationships using Oracle Trading Community Architecture
[  ] Merge party accounts and customer accounts
[  ] Set up customer profiles

Duration: 2 hour

Enter Orders
[  ] Describe the different order creation methods
[  ] Explain the Negotiation phas in Order Management
[  ] Explain workflow integration in the negotiation phase
[  ] Create Defaulting rules
[  ] Aplly sales credits
[  ] Create an order header
[  ] Explain line transaction types
[  ] Explain line statuses for a order
[  ] Search for an item using “Advanced item Search”
[  ] Create an order line and add an attachment in the order line
[  ] Explain Blanket sales agreements (BSA)
[  ] Create a Blanket sales agreement
[  ] Explain the process flow for internal requisitions
[  ] Create an internal Order
[  ] Explain Drop Ship across Sets of books
[  ] Create a drop ship order
[  ] Schedule an order line
[  ] Book an order
[  ] Copy an order
[  ] Explain High Volume Order Processing (HVOP)
[  ] Explain the required setup steps for entering orders
[  ] Describe order import

Duration: 2 hour

Manage Orders
[  ] Explain Processing Constraints
[  ] Update an order header and an order line
[  ] Perform a mass update or orders
[  ] Explain versioning and types of versioning
[  ] Describe the audit trail
[  ] Split an order line
[  ] Explain the Approval workflow
[  ] Create and apply a Hold
[  ] Release Holds
[  ] Explain the Credit Checking functionality
[  ] Credit Check an account before entering an order
[  ] Cancel an order
[  ] Close an order
[  ] Purge orders

Duration: 2 hour

Order Inquiry
[  ] Find Order and order lines using the Order Organize Form
[  ] Maintain orders using the Summary Form
[  ] Search for orders using the Navigator Tree Funtionality
[  ] Use the Order Information Portal

Duration: 1 hour

Pricing Concepts
[  ] Explain Pricing in the Order to Cash Process
[  ] Explain how the Pricing Engine works
[  ] Explain Price Lists
[  ] Explain Pricing Agreements
[  ] Compare features of Basic Pricing with Oracle Advanced Pricing

Duration: 1 hour

Oracle Shipping Execution Concepts
[  ] Explain Shipping in the Order to Cash Life Cycle
[  ] Explain Trips
[  ] Explain Delivery
[  ] Explain Stops
[  ] Use Query Manager
[  ] Explain the Shipping Transaction Form
[  ] Explain Quick Ship
[  ] Describe Shipping Exceptions

Duration: 1 hour

Oracle Shipping Execution
[  ] Explain Delivery Line
[  ] Explain LPN
[  ] Explain the Pick release process
[  ] Describe the Ship Confirm Process Flow
[  ] Explain One Step Shipping
[  ] Create Shipping Exceptions
[  ] Release Sales Orders
[  ] Describe On-Line, SRS and concurrent methods for pick release
[  ] Configure the pick release process
[  ] Explain auto-creation of deliveries
[  ] Ship Confirm Deliveries
[  ] Define shipping Document Sets
[  ] Describe packing into LPN containers
[  ] Explain the setup required for Shipping Execution
[  ] View shipping exceptions
[  ] Define Pick Slip grouping rules
[  ] Define Release sequence rules
[  ] Define Freight Carriers
[  ] Define Freight Costs Types
[  ] Define Roles and Grant access to roles

Duration: 3 hour

Total Duration 15 Hours.

- See more at: https://infoschool.in/oracle-inventory-training-and-placements-in-bangalore/#sthash.7SFq3mZS.dpuf
Content 10

Oracle is one of the most in Demand technology popular and finds its applications in Database design, Applications, DBA, ERP, Complicated operations of Business Intelligence, data warehousing can be comfortably handled by Oracle Software.

With growing Diversity of Oracle software usage, one needs to choose the right Course or package in Oracle.

We understand the needs of the students and hence provide career guidance to all the students who are doing or have completed their Oracle training. There is an ample scope of opportunities for Software developers and hence Oracle Training increases their chances to get a good job. Besides this, we provide Placements assistance in MNC companies/small companies/medium companies.

Content 3 Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt.
Content 4 Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt.