Oracle Cetification

  • Duaration - 3 Months

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management. In general, a server reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.

  • Installing and configuring Oracle
  • Basic monitoring and tuning
  • Basic understanding of database security issues
  • Database design
  • Good knowledge of DBMS series of packages

  • Relational and Object Relational Database Management System
  • Relational Database Concept
  • Definition of a Relational Database
  • Entity Relationship Model
  • Entity Relationship Modeling Conventions
  • Relational Database Terminology
  • Relational Database Properties
  • Communicating with a RDBMS Using SQL
  • SQL Statements

Writing Basic SQL SELECT Statements
  • Capabilities of SQL SELECT Statements
  • Basic SELECT Statemen
  • Selecting All Columns
  • Selecting Specific Columns
  • Writing SQL Statements
  • Column Heading Defaults
  • Arithmetic Expressions
  • Using Arithmetic Operators
  • Operator Precedence
  • Using Parentheses
  • Defining a Null Value
  • Null Values in Arithmetic Expressions
  • Defining a Column Alias
  • Duplicate rows
  • Displaying Table Structure

Restricting and Sorting Data
  • Limiting Rows Using a Selection
  • Using the WHERE Clause
  • Comparison Conditions
  • Using the BETWEEN Condition
  • Using the IN Condition
  • Using the LIKE Condition
  • Using the NULL Conditions
  • Logical Conditions
  • Using the AND Operator
  • Using the OR Operator
  • Using the NOT Operator
  • Rules of Precedence
  • ORDER BY Clause
  • Sorting in Descending Order
  • Sorting by Multiple Columns

Single-Row Functions
  • SQL Functions
  • Two Types of SQL Functions
  • Single-Row Functions
  • Character Functions
  • Case Manipulation Functions
  • Character-Manipulation Functions
  • Number Functions
  • Using the ROUND Function
  • Using the TRUNC Function
  • Using the MOD Function
  • Working with Dates
  • Arithmetic Operators with Dates
  • Date Functions
  • General Functions
  • NVL Function
  • Using the NVL2 Function
  • Using the COALESCE Function
  • The CASE Expression
  • Using the CASE Expression
  • The DECODE Function

Aggregating Data Using Group Functions
  • What Are Group Functions?
  • Types of Group Functions
  • Group Functions Syntax
  • Using the AVG and SUM Functions
  • Using the MIN and MAX Functions
  • Using the COUNT Function
  • Using the DISTINCT Keyword
  • Group Functions and Null Values
  • Using the NVL Function with Group Functions
  • Creating Groups of Data: The GROUP BY Clause Syntax
  • Using the GROUP BY Clause on Multiple Columns
  • Excluding Group Results: The HAVING Clause
  • Nesting Group Functions

Displaying Data from Multiple Tables (Joins)
  • Obtaining Data from Multiple Tables
  • Cartesian Products
  • Generating a Cartesian Product
  • Types of Joins
  • Joining Tables Using Oracle Syntax
  • What is Equi Join?
  • Retrieving Records with Equijoins
  • Additional Search Conditions Using the AND Operator
  • Qualifying Ambiguous Column Names
  • Using Table Aliases
  • Joining More than Two Tables
  • Non-Equijoins
  • Retrieving Records with Non-Equijoins
  • Outer Joins
  • Outer Joins Syntax
  • Using Outer Joins
  • Self Joins
  • Creating Joins with the USING Clause
  • Retrieving Records with the USING Clause
  • Creating Joins with the ON Clause
  • Retrieving Records with the ON Clause

  • Using a Subquery to Solve a Problem
  • Subquery Syntax
  • Guidelines for Using Subqueries
  • Types of Subqueries
  • Single-Row Subqueries
  • Executing Single-Row Subqueries
  • Using Group Functions in a Subquery
  • Multiple-Row Subqueries
  • Using the ANY Operator in Multiple-Row Subqueries
  • Using the ALL Operator in Multiple-Row Subqueries
  • Null Values in a Subquery

Manipulating Data
  • Data Manipulation Language
  • Adding a New Row to a Table
  • The INSERT Statement Syntax
  • Inserting New Rows
  • Inserting Rows with Null Values
  • Copying Rows from another Table
  • Changing Data in a Table
  • The UPDATE Statement Syntax
  • Updating Rows in a Table
  • Updating Two Columns with a Subquery
  • DELETE statement
  • Deleting Rows from a Table
  • Deleting Rows Based on another Table
  • Using a Subquery in an INSERT Statement
  • The MERGE Statement
  • The MERGE Statement Syntax
  • Database Transactions
  • Advantages of COMMIT and ROLLBACK Statements
  • Controlling Transactions
  • Rolling Back Changes
  • Implicit Transaction Processing
  • State of the Data before COMMIT or ROLLBACK
  • State of the Data after COMMIT
  • Committing Data
  • State of the Data after ROLLBACK
  • Locking
  • Implicit Locking

Creating and Managing Tables
  • Database Objects
  • Naming Rules
  • The CREATE TABLE Statement
  • Referencing another User's Tables
  • The DEFAULT Option
  • Creating Tables
  • Tables in the Oracle Database
  • Querying the Data Dictionary
  • Creating a Table by Using a Subquery
  • The ALTER TABLE Statement
  • Adding a Column
  • Modifying a Column
  • Dropping a Column
  • The SET UNUSED Option
  • Dropping a Table
  • Changing the Name of an Object
  • Truncating a Table

Oracle Date Time Functions
  • TIMESTAMP Data Type
  • TIMESTAMP with Time Zone Data Type
  • TIMESTAMP with Local Time Data Type

Pseudo columns
  • What is Pseudocolumns?
  • Rownum
  • Rownum in camparison

Including Constraints
  • Objectives
  • What are Constraints?
  • Constraint Guidelines
  • Defining Constraints
  • The NOT NULL Constraint
  • The UNIQUE Constraint
  • The PRIMARY KEY Constraint
  • The FOREIGN KEY Constraint
  • FOREIGN KEY Constraint Keywords
  • The CHECK Constraint
  • Adding a Constraint Syntax
  • Dropping a Constraint
  • Disabling Constraints
  • Enabling Constraints
  • Viewing Constraints

  • What is a Sequence?
  • The CREATE SEQUENCE Statement Syntax
  • Creating a Sequence
  • Confirming Sequences
  • NEXTVAL and CURRVAL Pseudocolumns
  • Using a Sequence
  • Modifying a Sequence
  • Guidelines for Modifying a Sequence
  • Removing a Sequence

Creating Views
  • What is Database Objects
  • What is a View?
  • Why to use Views?
  • Simple Views and Complex Views
  • Creating a View
  • Retrieving Data from a View
  • Querying a View
  • Modifying a View
  • Creating a Complex View
  • Rules for Performing DML Operations on a View
  • Using the WITH CHECK OPTION Clause
  • Denying DML Operations (With read only Option)
  • Removing a View
  • Inline Views

  • What is an Index?
  • How Are Indexes Created?
  • Creating an Index
  • When to Create an Index
  • When Not to Create an Index
  • Confirming Indexes
  • Removing an Index

Controlling User Access
  • Objectives
  • Controlling User Access
  • Privileges
  • System Privileges
  • Creating Users
  • User System Privileges
  • Granting System Privileges
  • What is a Role?
  • Creating and Granting Privileges to a Role
  • Changing Your Password
  • Object Privileges
  • Granting Object Privileges
  • Using the WITH GRANT OPTION and PUBLIC Keywords
  • How to Revoke Object Privileges
  • Revoking Object Privileges

  • What is Synonyms?
  • C How Are Synonyms Created?
  • Removing Synonyms

  • Introduction to PL/SQL
  • PL/SQL Execution Environment
  • PL/SQL Development Environment
  • Introduction to PL/SQL Procedures
  • Introduction to PL/SQL Functions
  • Introduction to PL/SQL Packages
  • Introduction to PL/SQL Triggers
  • Coding PL/SQL
  • The correct structure of a PL/SQL program block
  • Declare and initialize a variable
  • Declare and initialize data types and Boolean variables

Decision Making
  • IF Statement
  • IF-ELSIF Statements

  • Implement suitable control structures in PL/SQL
  • Implement a suitable loop construct in PL/SQL for a given scenario
  • Characteristics of FOR and nested loops in PL/SQL
  • Implementation of WHILE LOOP
  • Implementation of DO WHILE LOOP
  • EXIT Keyword
  • GOTO Statement

Sub Blocks
  • What is Sub Block?
  • Sub Blocks implementation
  • Modular Programming
  • Create and populate a user-defined record in PL/SQL
  • Create a record using the %ROWTYPE attribute and use it to insert and update a row
  • Create a record and use it to update a table

  • What is Cursor?
  • Cursor Types
  • Implicit Cursor
  • Use explicit cursors to retrieve data
  • Cursor attributes
  • For Loop Cursors
  • Advantages of For Loop Cursors
  • Default values in cursors
  • Use parameters to make cursors reusable in a given scenario
  • Use an explicit cursor to retrieve and update data

  • What is Exception?
  • Exception Section
  • About The Exception Section
  • Isolating the Specific Exception
  • Outline how each of the PL/SQL exception types are raised and handled
  • Trap predefined and non-predefined exceptions in PL/SQL
  • Trap user-defined exceptions and identify error codes and messages
  • Use nested blocks and the RAISE_APPLICATION_ERROR procedure when handling exceptions in PL/SQL
  • Handle exceptions in PL/SQL
  • Pragma Exception_Init
  • SQLcode & SQLerrm Example
  • SQL%Rowcount

Stored Procedures
  • Create, remove, and view PL/SQL stored procedures
  • Use IN, OUT, and IN OUT parameter modes to pass values to and from stored procedures and programs
  • Outline how to view values returned by OUT parameters
  • Create stored procedures with suitable parameters
  • Assign values to multiple parameters
  • Handle exceptions in stored procedures

Stored Functions
  • Create a stored function
  • Execute a stored function
  • Call, remove, and view stored functions in PL/SQL

Managing Subprograms
  • Definer Rights
  • Invoker rights
  • List all Procedures and Functions

  • Identify features of PL/SQL packages
  • Sequence steps for developing PL/SQL packages
  • Identify the syntax for creating a PL/SQL package
  • Identify tasks involved in managing PL/SQL packages
  • Identify features of the overloaded subprograms contained in PL/SQL packages
  • Identify features of forward referencing in PL/SQL packages

Managing LOBs
  • Identify features of the DBMS_LOB package
  • Identify the code to work with Large Object (LOB) values
  • Identify methods of selecting Character Large Object (CLOB) values
  • Identify features of temporary Large Objects (LOBs)

  • Identify features of Triggers
  • Identify the code to create a Data Manipulation Language (DML) trigger
  • Identify the code to create a Data Manipulation Language (DML) row Trigger
  • Match the options for managing triggers with their descriptions
  • Identify guidelines for testing triggers
  • Identify the benefits of triggers in different business application scenarios
  • Identify the syntax for creating triggers for DDL and system events

Advanced Triggers
  • Creating Trigger on DDL Statements
  • LOGON & LOGOFF Trigger Example
  • CALL Statement in Trigger
  • Advantages of trigger
  • Conditional Security

  • Objectives
  • Understand Oracle Architecture
  • Create / Manage Database
  • Optimization of Database
  • Disaster Management
  • Duties & Responsibilities of DBA
  • Installation of Oracle Server & Application Tools
  • Allocation of Space and sizing storage requirements
  • Creation of Primary Database & Schema Objects
  • Modification of Database structure
  • Creating /maintaining of user
  • Performance Tuning
  • Backup & recovery

Oracle Architecture
  • Optimal Flexible Architecture (OFA) complaint
  • Standard Architecture
  • Oracle Instance
  • Oracle Database
  • Single Process
  • Multi-Process
  • Database Structure
  • Logical (Tablespace, Segments, Extents, Schema Objects)
  • Physical (Control file, Data file, Redo log files)
  • Roll back segments
  • Transaction Management
  • Data Dictionary

Hardware Considerations
  • Stand alone host
  • Multiple Databases
  • Networked Host
  • Clustered Servers

Startup & Shutdown
  • Invoking SVRMGRL
  • Startup
  • Start the Instance
  • Mount The Database
  • Open the Database
  • Shutdown
  • Normal
  • Immediate
  • Transactional
  • Abort
  • Alter Database
  • Enable Restricted Session
  • Parameter file

Database Storage
  • Tablespaces & Datafiles
  • Managing Tablespaces
  • Managing / Sizing Schema Objects
  • Managing Datafiles
  • Allocation of Space
  • Segments
  • Extents
  • Database Blocks
  • Index
  • Temporary
  • Rollback
  • Tables
  • Views
  • Indexes
  • Partitioning of tables & Indexes
  • Snapshots
  • Sequences
  • Synonyms
  • Database Links

Creating & Customising The Database
  • Create a Database
  • Determine Instance
  • Copy & Edit Parameter Settings
  • Start the Instance
  • Connect the Instance
  • Physically Create the Database
  • Add Control File
  • Multiplexing Control files
  • Add Redo log Members
  • Multiplexing Redo log Members
  • Data dictionary users
  • Display Data Dictionary Views
  • Rollback segments
  • Create rollback segments
  • Alter Rollback segments
  • Guidelines for Managing RBS
  • Managing Locks
  • Types of Locks
  • Table Locks
  • Dictionary Locks
  • Dead Lock Detection
  • Monitor locking Activity

Create And Manage Database User / Enterprise Manager
  • Create User
  • Alter User
  • Drop User
  • Monitor User
  • Profiles
  • Create Profile
  • Alter Profile
  • Drop Profile
  • Managing database security for Users
  • User Authentication

Managing Privileges And Roles Command Line & Enterprise Manager
  • Types of Privileges
  • Different Roles
  • Default Roles
  • Dropping Roles
  • Changing Default Roles
  • Granting System Privileges & roles
  • Granting object Privileges
  • Revoke system Privileges & roles
  • Revoking Object Privileges
  • Cascading effects
  • Listing Privileges & Role Information

Performance Tuning
  • SQL Tuning
  • Memory Tuning
  • SGA
  • Library Cache
  • Dictionary Cache
  • Redo log Buffer Cache
  • I/O Tuning
  • Disk Contention
  • Space in data block
  • Trace files & Alert Files
  • Contention for Rollback segments
  • Tune free lists
  • Tune Checkpoints
  • SQL Trace facility & TKPROF Utility
    1] Multiple Database/ Distributed Database Management
    2] Database Auditing & Security
    3] NET8

OFA Complaint Backup & Recovery
  • Operating System Backups (Cold Backups)
  • Online Backup (Hot Backups)
  • Recovery Structure
  • Archive Modes
  • Change Archive Modes
  • Enable Archive Processing
  • Archive Log Files
  • Database Errors
  • Recovers from User error
  • Recovery from Statement Failures
  • Recover from Instance failure
  • Recovery from Media Failure
  • Recovery with Archiving
  • Recovery Without Archiving
  • Disable Archive Processing
  • Backup Control file
  • Recover a Control file
  • Legato Storage Manager
  • Recovery Manager (RMAN)

Server Utilities
  • Export
  • Export Basics
  • Export Parameters
  • Incremental Export
  • Cumulative Export
  • Complete Export
  • Import
  • Import basics
  • Import modes
  • Import Parameters
  • Incremental Import
  • Cumulative Import
  • Complete Import
  • SQL*Loader
  • Basics
  • Direct path Loads
  • Conventional Path Loads
  • Logging information
  • Control file
  • Data file
  • Discard File
  • Bad file
  • Case Studies
    1] Monitoring Common Problem Areas & Useful DBA Scripts
    2] Oracle Standard Installation
    3] Oracle (OFA) Installation
    4] Oracle Database Connectivity With Front Ends

Oracle E-Business Suite Overview
  • Oracle E-Business Suite Home Page
  • Oracle E-Business Suite Architecture
  • Oracle E-Business Suite Technology Stack
  • Installation Tools
  • Oracle E-Business Suite Products

Preparing For Your Installation
  • Overview of Rapid Install
  • Supported Platforms and Environments
  • Prerequisites and Preparatory Tasks
  • Starting Rapid Install
  • Obtaining Help

Performing an Installation
  • Installation Types and Options
  • Standard Installation
  • Express Installation

Finishing Your Installation
  • Required Post-Installation Steps
  • Conditional Post-Installation Steps
  • Administration and Maintenance Tasks

Oracle E-Business Suite Components
  • Oracle E-Business Suite Technology Stack
  • Desktop Tier
  • Application Tier
  • Database Tier
  • Oracle E-Business Suite Technology Layer
  • Oracle Applications DBA
  • Oracle Application Object Library
  • Oracle E-Business Suite Utilities

Environment Files, Control Scripts, and Languages
  • Oracle E-Business Suite Environment Files
  • Application Tier Service Control Scripts
  • Character Sets
  • Globalization Features
  • Language Support

Oracle E-Business Suite File System
  • File System Overview
  • INST_TOP Directory Structure
  • Database Tier File System
  • Application Tier File System
  • APPL_TOP Directory Structure
  • Product Directories
  • Technology Stack Directory
  • Database Directories

Oracle E-Business Suite Database
  • Database Overview
  • Oracle E-Business Suite Database Objects and Schemas
  • Implementing Multiple Organizations
  • Reporting Currencies
  • Monitoring Features
  • Performance Features
  • Scalability Features
  • Database Tier Server Control Scripts

Advanced Configuration Options
  • Shared Application Tier File System
  • Load Balancing
  • Network Features

Using the AD Utilities
  • Overview
  • Setting the Environment
  • The AD Utilities
  • Command Line Arguments and Flags
  • AD Utilities Features and Prompts
  • Parallel Processing Options and Distributed AD
  • Log and Restart Files
  • Maintenance Mode

AD Administration: Generate Applications Files Tasks
  • Preliminary Tasks
  • Prompts and Log Files
  • Generate Applications Files Menu
  • Generate Message Files
  • Generate Form Files
  • Generate Report Files
  • Generate Product JAR Files

AD Administration: Maintain Applications Files Tasks
  • Maintain Applications Files Menu
  • Relink Applications Programs
  • Copy Files to Destinations
  • Convert Character Set
  • Maintain Snapshot Information
  • Checking for Missing Files
  • Performing File System Tasks

AD Administration: Compile/Reload Database Entities Tasks
  • Compile/Reload Database Entities Menu
  • Compile APPS Schema
  • Compile Menu Information
  • Compiling Flexfield Data in AOL Tables
  • Reloading JAR Files into Database

Special Utilities
  • AD Controller Overview
  • Worker Status Flow
  • Restarting an AD Utility
  • Shutting Down Managers
  • AD Relink Overview
  • Running AD Relink

  • AutoConfig Overview
  • Context Files
  • AutoConfig Tasks
  • Running AutoConfig
  • AutoConfig Log Files
  • Rolling Back an AutoConfig Session
  • Running AutoConfig in Test Mode
  • Other AutoConfig Features

License Manager
  • AD Configuration
  • AD File Identification
  • AD Job Timing Report

Configuration Utilities
  • AD Splicer Overview
  • AD Splicer Control Files
  • Editing newprods.txt File
  • Post-Splice Steps
  • File Character Set Converter

Patching and the AutoPatch Process
  • Patch Terminology and Components
  • Downloading Patches
  • AutoPatch Features
  • Patch Wizard
  • Running AutoPatch
  • OAM Timing Reports
  • Other Patching Topics
  • Applied Patches Information

Cloning Oracle E-Business Suite
  • Principles and Terminology
  • Cloning Scenarios
  • Prerequisite Steps
  • Cloning Steps
  • Finishing Tasks
  • Refresh a Target System
  • Clone a Multi-Node System
  • Add a Node to an Existing System

Oracle 12c R2 Grid Infrastructure Concepts
  • What is a Cluster
  • Grid Foundation Components
  • Oracle Clusterware Architecture
  • Oracle Clusterware Software and Storage
  • Describe ASM Architecture
  • Creating and Managing ASM Disk Groups
  • Creating and Managing ASM Cluster File systems
  • Administering Oracle Clusterware
  • Troubleshooting Oracle Clusterware

Grid Infrastructure Installation and Configuration
  • Hardware Requirements
  • Network Requirements
  • Software Requirements
  • DNS and DHCP Configuration
  • Grid Plug and Play Considerations
  • Single Client Access Names
  • Post installation tasks

Oracle Automatic Storage Management concepts
  • ASM Instance
  • ASM Disks
  • ASM Disk Groups
  • ASM Redundancy

Cluster installation Prerequisite for Oracle 12c R2 RAC
  • Linux OS Software Installation
  • Create OS Group and User Accounts
  • Networking
  • Synchronizing the Time on ALL Nodes
  • Configuring Kernel Parameters
  • Set shell limits for the oracle & grid user
  • Create the Oracle Inventory Directory
  • Creating the Oracle Grid Infrastructure Home Directory
  • Creating the Oracle Base Directory
  • Creating the Oracle RDBMS Home Directory
  • Stage the Oracle Software
  • Check OS Software Requirements
  • Cluster Verification Utility

Shared Storage Configuration
  • Types of Shared Storage
  • Partition the Shared Disks
  • Installing and Configuring ASMLib
  • Using ASMLib to Mark the Shared Disks as Candidate Disks

Oracle 12c Grid Infrastructure Installation
  • Basic/Advanced Grid Infrastructure Install (without GNS and IPMI)…
  • Grid Infrastructure Home Patching
  • RDBMS Software Install
  • Run ASMCA to create disk groups

Oracle 12c R2 RAC Database Software Installation
  • Installing The Oracle Database Software
  • Creating A Cluster Database
  • Post database Creation Tasks

Administering Oracle Clusterware
  • Managing Clusterware with Enterprise Manager
  • Determining the Location of the Oracle Clusterware Configuration Files
  • Backing Up and Recovering the Voting Disk
  • Adding, Deleting, or Migrating Voting Disks
  • Locating the OCR Automatic Backups
  • Oracle Local Registry
  • Migrating OCR Locations to ASM
  • Managing Network Settings
  • Managing Oracle Clusterware

Administering ASM Instances
  • ASM Initialization Parameters
  • Adjusting ASM Instance Parameters in SPFILEs
  • Starting and Stopping ASM Instances Using srvctl
  • Starting and Stopping ASM Instances Using ASMCA and ASMCMD
  • Starting and Stopping ASM Instances Containing Cluster Files
  • Starting and Stopping the ASM Listener
  • Administering ASM Disk Groups
  • Creating and Deleting ASM Disk Groups
  • ASM Disk Group Attributes
  • ASM Disk Group Maintenance Tasks
  • Viewing ASM Disk Statistics

Prerequisite Steps for Extending a Cluster
  • Using to add a Node to a Cluster
  • Rolling Patches and Rolling Upgrades
  • Installing a Patchset with the OUI Utility
  • Installing a Patch With The opatch Utility

Cluster Node Management
  • Add/Deleting the Instance
  • Add the Node
  • Remove the Node
  • Single-Instance Conversion Using rconfig
  • Single-Instance Conversion Using DBCA

Troubleshooting Oracle Clusterware
  • Oracle Clusterware Log Files
  • Gathering Log Files Using
  • Component-level Debugging
  • RAC-Specific Wait Events, Global Enqueues, and System Statistic
  • Implementing the Most Common RAC Tuning Tips
  • Using the Cluster Database Performance Pages
  • Using the Automatic Workload Repository in RAC
  • Using Automatic Database Diagnostic Monitor in RAC

Introduction to Oracle OSB
  • Overview of service-oriented architecture (SOA)
  • Overview XML, XSD, WSDL, Webservices
  • Why is OSB?
  • Introducing the Service Oriented Architecture
  • Describing the Oracle Service Bus Architecture
  • Introducing the Role of Oracle Service Bus

  • Overview of weblogic server
  • Overview of OSB server and meta data schemas
  • Creating domain in weblogic server.
  • Install OSB Server
  • Overview of start and stop steps of OSB server and Admin Server.

OSB Concepts
  • Business Service
  • Proxy Service
  • Message Flow
  • Resources of OSB
  • Change Centre in OSB
  • Export and Import of OSB Coding
  • How to create and use of Customization file in OSB

Message Flow
  • Introducing the Oracle Service Bus Resources
  • Explaining the Message Context Model and the Message Context Variables
  • Understanding the Message Flow and the Nodes/Elements of a Message Flow

Message Flow Actions
  • Describing the Communication Actions You Can Add to a Route or a Stage in a Message Flow
  • Describing the Flow Control Action You Can Add to a Route or a Stage in a Message Flow
  • Describing the Message Processing Actions You Can Add to a Stage in a Message Flow
  • Describing the Reporting Actions You Can Add to a Stage in a Message Flow
  • Using XQuery Mapping and Transformations

Transports in Oracle Service Bus
  • Describing Oracle SOA Suite Transport (SOA-DIRECT)
  • How to Import XSD/WSDL
  • How to Create Business service using other WS
  • Describing JCA Transport

Debugging with Oracle Service Bus
  • Describing and Configuring Error Handling in Oracle Service Bus
  • Configuring Validation in Oracle Service Bus
  • Explaining the Usage of the Reporting Action

Introducing Oracle Fusion Middleware Platform
  • Intro about Web logic Server
  • What is an application server
  • Middleware
  • J2EE Technologies
  • Web & WLS Terms

Setting up a Web logic Server Environment
  • Web Logic Server Architecture
  • Download of WebLogic
  • Installing of Web Logic Server 11g (GUI /Console /Silent) on both Windows/Linux
  • Starting and Stopping Web Logic Server
  • Various types of Start/Stop of Servers

Configure a Web Logic Server Environment
  • Intro about Admin, Managed Servers, Domain, Machine and Node Manager
  • Configuring Admin Servers
  • Configuring Managed Servers
  • Configuring Node Manager
  • Configuring of Machine
  • Console Administration
  • Command Line Administration
  • Configuration of Domain using Dev and Prod Mode
  • Difference between Dev and Prod Mode of Domain

Introduction to Clustering
  • The Benefits of Oracle WebLogic Cluster
  • Types of Cluster (Vertical/Horizontal)
  • Configuring Vertical / Horizontal Cluster
  • Communication Among Clustered Server Instances
  • The Key Criteria for Selecting Suitable Cluster Architecture

Configuring a Cluster
  • Preparing Your Environment for a Cluster
  • Creating and Configuring a Cluster for Vertical / Horizontal.
  • Adding Servers to a Cluster
  • Starting Up and Shutting Down Clustered Servers.

Web logic Configuring Resources
  • Finding Weblogic Sever Version
  • PassBasis Commands
  • What is Classpath? How to set Classpath in WebLogic
  • Importance of setWLSEnv/ file
  • Importance of config.xml file
  • Importance of file
  • Importance of file
  • Monitoring and handling of Servers, Domains
  • Enabling of Administration Port
  • Virtual Host

Deploying Applications
  • Overview of Deployment
  • Various types of Deployment
  • Java Applications
  • Web Applications
  • Advanced Deployment

Understanding JNDI and Setting up JDBC
  • Introduction to JNDI
  • Overview of JDBC
  • Data Sources
  • Types of Data Sources (Generic/GridLink/Multi)
  • Configuration of Data Sources
  • Administration of Data Sources
  • Explaining the Components of JDBC URLs
  • Monitoring and Testing a Data Source
  • Overview of Transactions (XA and Non-XA)

Setting Up Java Message Service (JMS) Resources
  • Describing JMS
  • Describing How Oracle WebLogic Server JMS is Implemented
  • Configuring JMS Server
  • Configuring Connection Factories
  • Configuring Queues and Topics
  • Configuring Persistent Messages
  • Deploying an Application that Uses JMS
  • Monitoring JMS Resources and Messages

Security Concepts and Configuration
  • Over view of Security Realms
  • Configuring Users and Groups
  • Admin Server Password Reset
  • Build

Monitoring and log file handling Logs
  • Overview of Log Management
  • Various Types of Log File for Trouble Shooting
  • Server Log and access logs
  • Log Management
  • Rotation/Archiving/ log files
  • Troubleshooting issues in WebLogic

Performance Tuning and WebLogic Web Container
  • The JVM
  • Memory Management
  • Garbage Collection Mechanism
  • GC Performance Improvements
  • Heap Management
  • Thread Management
  • Thread / heap Dump
  • Oracle Patching /Upgrade
  • Backup Plan in Web logic

WebLogic Scripting Tool
  • Introduction to WLST
  • Modes
  • Script Generation
  • Script Recording

Introduction to Oracle SOA Suite
  • Overview of service-oriented architecture (SOA)
  • Overview XML, XSD, WSDL, Web services
  • Why is SOA?
  • What is SCA?

  • Overview of weblogic server
  • Overview of SOA server and meta data schemas
  • Creating domain in weblogic server.
  • Install SOA Server
  • Overview of start and stop steps of SOA server and Admin Server.

Interaction Patterns
  • Synchronous Pattern
  • Asynchronous pattern
  • One way invoke

SCA Architecture
  • Define a composite application
  • Describe SOA Composite Editor
  • Explain Component Type Files.

SOA Composite Build and Deploy
  • Explain SOA composite.
  • Lab
  • Understand BPEL designer (JDeveloper) and activities
  • Creating your first BPEL Process – HelloWorld
  • Xpath Expression Builder
  • Deploying the SOA Composite application.
  • Managing Deployments/Un-Deployments with Enterprise Manager 11g

Build of Synchronous and Asynchronous Services
  • Orchestrating Services with BPEL for Synchronous, Asynchronous and One-way Service
  • Overview of Partner Link. Why do we need myRole-PartnerRole concept
  • Lab
  • Create a synchronous process
  • Create an asynchronous process
  • Create One-way

Transformation Services
  • XSLT mapping tool
  • XSLT map Testing and analysing at design time

Parallel processing and Conditional branching
  • Understanding activities XSL, Switch, flow and While.
  • Lab
  • Processing with Parallel Flows
  • Using Flown activity
  • Conditional Branching

Exploring Pick activity and OnAlarm branch
  • Lab
  • Develop BPEL process to use pick(Receive inputs from Multiple Operations)
  • Develop BPEL process that can time out a call to an Async process, using OnAlarm branch

Adapters Concepts
  • Understanding File, Database and JMS Adapter
  • Lab
  • Read and write a file using file adapter
  • Poll for new rows in a table using DB adapter
  • Insert data into JMS queue using JMS adapter

  • Working with Mediator Components
  • Explain the Mediator component and its features
  • Parallel Flows and sequential flows.
  • Lab
  • Creating a Mediator Component
  • Adding Routing Rules
  • Create XSL Transformations with XSLT Mapper
  • Create Content Based Routing filters

Human Workflow and work list application
  • Human Workflow Service Concepts
  • Features of workflow service
  • Lab
  • Sending an approval notification
  • Modeling workflows

Business Rules
  • Introduction to Business Rules.
  • Introduction to Decision tables
  • Lab
  • Using Business Rules and Decision tables in BPEL

Fault Handling and Exception Management
  • Explain Fault Types
  • System faults
  • Business faults
  • Process based Fault handling
  • Policy based fault handling
  • Lab
  • Using Throw activity to throw faults
  • Using Fault Handler to handle faults
  • Compensation handler
  • Using policy files

Introduction to Oracle 11g ADF
  • What is Oracle ADF?
  • MVC architecture
  • Benefits of ADF
  • ADF architecture
  • ADF Faces
  • JDeveloper tools

Developing ADF applications
  • Applications and projects
  • Database connections
  • Overview of Business components
  • Steps to create business components
  • Business Components diagram
  • Application flow overview

Entity Objects
  • What is an entity object?
  • Entity object class diagram
  • Creating entity objects
  • Customizing attribute properties
  • Entity associations
  • Entity object definition file
  • Database synchronization, moving, and renaming
  • Entity diagrams

View objects
  • What is a view object?
  • View object class diagram
  • Steps to create a view object
  • Bind variables
  • Query-by-example view criteria
  • Adding view object instance to application module
  • Testing view objects
  • Read-only master-detail tables
  • Master-detail-detail
  • Inline detail tables

Transactions, validation and conversion
  • Built-in conversion
  • Custom converters
  • Entity object validation
  • Creating validation rules
  • Error messages
  • ADF Faces validation

ADF Tables
  • ADF table overview
  • Table selection and sorting
  • Result set scrolling and navigation
  • Table and Column attributes
  • Editing records
  • Table bindings
  • Deleting records

Advanced Tables, Trees, and Tree Tables
  • Row Disclosure
  • Creating Context Menus
  • Handling multiple selections
  • ADF Trees
  • ADF TreeTables

The ADF LifeCycle
  • JSF lifecycle
  • ADF Faces Rich Client lifecycle
  • ADF page lifecycle
  • Monitoring the lifecycle
  • Subforms

Handling forms
  • Control flow rules
  • Common input components
  • Managed beans and scopes
  • Drop-down menus
  • Multiple select components
  • Search concepts
  • Query-by-example
  • Search forms and bind variables

Task Flow Concepts
  • Bounded vs. unbounded task flows
  • ADF controller activities
  • Managed beans and scoping
  • State tracking
  • Save points
  • Exception handling

Working with Task Flows
  • Passing values between pages
  • Bookmarking
  • Using bounded child task flows
  • Transaction handling
  • Managing the browser back button
  • Bounded task flows in dialogs and popups
  • Managing task flow templates

Working with Task Flows
  • Passing values between pages
  • Bookmarking
  • Using bounded child task flows
  • Transaction handling
  • Managing the browser back button
  • Bounded task flows in dialogs and popups
  • Managing task flow templates

ADF Regions and Bounded Task Flows
  • Using page fragments
  • Using ADF regions
  • Dynamic regions
  • Managing contextual events
  • Communicating with ADF Regions

ADF Navigation
  • Bread crumbs
  • Reusable menu concepts
  • Process train
  • Partial page navigation
  • Navigating programmatically

  • Container-managed security
  • JAAS
  • ADF security overview
  • Enabling security
  • Creating users, groups, and roles
  • Page and task flow permissions
  • Security Expression Language
  • Securing entity objects
  • Row-level security
  • Logging in and out

Customizing ADF Programmatically
  • Custom Java classes – EO and VO
  • Custom validation methods – EO
  • Calculated attributes – EO and VO
  • Finding, creating, removing, and modifying EOs and VOs

Web services
  • What is a web service?
  • Web service data control
  • Securing a web service
  • Consuming a web service – JSP
  • Web service proxy

ADF Troubleshooting
  • Business Components Browser
  • Expression language builder
  • Page definition errors
  • Java logging
  • Breakpoints
  • Breakpoint groups
  • Debugging configuration
  • The Stack

  • Deployment steps
  • WebLogic admin basics
  • Deployment Profiles
  • Deployment Options
  • Deploying an application with JDeveloper
  • Testing your application
Introduction to Oracle Applications and OAF
  • Oracle Applications Framework
  • OAF and MVC
  • OAF Process Flow
  • More about OAF

JDeveloper Overview
  • JDeveloper Features
  • Building OAF Application in JDeveloper
  • Configuring JDeveloper Preferences

Basics of the Model
  • Understand the basics of BC4J
  • Understand an Entity Object
  • Understand a View Object
  • Understand an Application Module

Basics of the View
  • Understand the terminology
  • Building a basic OA Framework page
  • List of Values
  • Building Search Regions

Debugging OA Framework Applications
  • Using JDeveloper debugger
  • Examine Runtime variables and arguments
  • Modify Runtime variables and arguments

Basics of the Controller
  • Understanding OA Framework Controller
  • Enhance an OA Framework page
  • OA Framework : Message Dictionary

OA Framework Event Flows
  • Initial Setup Flow
  • Controller Event Flows
  • Request Flow (GET)
  • Submit Flow (POST)

Naming Conventions and Standards
  • General Naming Rules
  • Package Naming
  • Page and Region Naming
  • Item Naming

Error Handling
  • Exception types and Classes
  • Bundled exceptions
  • Dialog pages
  • Debugging messages

Implementing Business Logic
  • Client Validations
  • Required values and Data types
  • Server Validations
  • Entity object and View object validations

Partial Page Rendering
  • Using Auto Submit
  • Using Partial Submit
  • Trigger and Target Components
  • Implementing Partial Page Rendering

OA Framework State Management
  • OA Framework State Caches
  • Passivation
  • “Back” button support

OA Framework Extension
  • Types of Extension
  • Overriding Default Values
  • Override Attribute Validation

OA Framework Performance Tuning
  • BC4J and JDBC Guidelines
  • SQL Tracing
  • Monitor Connection Pool
  • OA Framework Performance Standards

Application Menus and Function Security
  • OA Framework page menus
  • Registering functions for OA Framework pages
  • Creating Responsibilities and Users
  • Using JSP test page

Implementing Internationalization
  • Date and Timezone Internationalization
  • Number and Currency Internationalization
  • Testing Internationalization

Deploying OA Framework Applications
  • Creating Deployment Profiles
  • Deploying Model
  • Deploying View and Controller

Introducing Oracle Forms Developer and Forms Services
  • Grid Computing
  • Oracle 10g Products
  • Oracle Application Server 10g Architecture
  • Benefits and Components of Oracle Developer Suite 10g
  • Running a Forms Developer Application
  • Working in the Forms Developer Environment

Creating Forms Modules
  • Creating a Basic Forms Module
  • Creating a Master-Detail Forms Module
  • Modifying the Data Block
  • Modifying the Layout

Working with Data Blocks and Frames
  • Using the Property Palette
  • Managing Object Properties
  • Creating and Using Visual Attributes
  • Controlling the Behavior and Appearance of Data Blocks
  • Controlling Frame Properties
  • Creating Control Blocks
  • Deleting Data Blocks

Working with Input Items
  • Creating Text Items
  • Controlling the Behavior and Appearance of Text Items
  • Creating LOVs
  • Defining Editors
  • Creating Check Boxes
  • Creating List Items
  • Creating Radio Groups

Working with Non Input Items
  • Creating a Display Item
  • Creating an Image Item
  • Creating a Push Button
  • Creating a Calculated Item
  • Creating a Hierarchical Tree Item
  • Creating a Bean Area Item

Working with Windows and Canvases
  • Overview of Windows and Canvases
  • Displaying a Forms Module in Multiple Windows
  • Creating a New Window
  • Displaying a Forms Module on Multiple Layouts
  • Creating a New Content Canvas
  • Creating a New Stacked Canvas
  • Creating a New Toolbar Canvas
  • Creating a New Tab Canvas

Producing Triggers
  • Grouping Triggers into Categories
  • Defining Trigger Components: Type, Code, and Scope
  • Specifying Execution Hierarchy
  • Using the PL/SQL Editor
  • Writing Trigger Code
  • Using Variables and Built-ins
  • Using the When-Button-Pressed and When-Window-Closed Triggers

Debugging Triggers
  • The Debugging Process
  • The Debug Console
  • Setting Breakpoints
  • Debugging Tips
  • Running a Form in Debug Mode
  • Stepping through Code

Adding Functionality to Items
  • Coding Item Interaction Triggers
  • Defining Functionality for Check Boxes
  • Changing List Items at Run Time
  • Displaying LOVs from Buttons
  • Populating Image Items
  • Populating and Displaying Hierarchical Trees
  • Interacting with JavaBeans

Run-Time Messages and Alerts
  • Built-ins and Handling Errors
  • Controlling System Messages
  • Using Triggers to Intercept System Messages
  • Creating and Controlling Alerts
  • Handling Server Errors

Query Triggers
  • SELECT Statements Issued During Query Processing
  • WHERE and ORDER BY Clauses and the ONETIME_WHERE Property
  • Writing Query Triggers
  • Query Array Processing
  • Coding Triggers for Enter-Query Mode
  • Overriding Default Query Processing
  • Obtaining Query Information at Run Time

  • Validation Process
  • Controlling Validation Using Properties
  • Controlling Validation Using Triggers
  • Performing Client-Side Validation with PJCs
  • Tracking Validation Status
  • Using Built-ins to Control When Validation Occurs

  • Navigation Overview
  • Understanding Internal Navigation
  • Using Object Properties to Control Navigation
  • Writing Navigation Triggers: When-New

OA Framework Performance Tuning
  • BC4J and JDBC Guidelines
  • SQL Tracing
  • Monitor Connection Pool
  • OA Framework Performance Standards

Application Menus and Function Security
  • OA Framework page menus
  • Registering functions for OA Framework pages
  • Creating Responsibilities and Users
  • Using JSP test page

Implementing Internationalization
  • Date and Timezone Internationalization
  • Number and Currency Internationalization
  • Testing Internationalization

Deploying OA Framework Applications
  • Creating Deployment Profiles
  • Deploying Model
  • Deploying View and Controller

Introducing Oracle Forms Developer and Forms Services
  • Grid Computing
  • Oracle 10g Products
  • Oracle Application Server 10g Architecture
  • Benefits and Components of Oracle Developer Suite 10g
  • Running a Forms Developer Application
  • Working in the Forms Developer Environment

Introduction to Oracle Reports Developer
  • Business Intelligence
  • Enterprise Reporting
  • Oracle Reports Developer
  • Oracle Database 10g
  • Oracle Developer Suite 10g
  • Oracle Application Server 10g
  • OracleAS Reports Services
  • OracleAS Reports Services Architecture for the Web

Designing and Running Reports
  • Understanding User Requirements
  • Designing Reports
  • Tabular
  • Master-Detail
  • Master with Two Details
  • Matrix
  • Retrieving and Sharing Data
  • Running a Report

Working in Oracle Reports Developer
  • Reports Developer Executables
  • Invoking Reports Builder
  • Reports Builder Modules
  • Report Data and Layout
  • Reports Builder Components
  • Object Navigator
  • Report-Level Objects
  • Data Model Objects

Creating a Paper Report
  • Report Module Components
  • Building a Paper Report
  • Viewing the Paper Report Output
  • Saving the Report Definition
  • Reentering the Wizard
  • Creating Break Reports
  • Break Report Labels
  • Creating Mailing Labels and Letters

Enhancing a Basic Paper Report
  • What Is the Paper Design?
  • The Paper Design Window
  • Modifying a Report
  • Aligning Columns
  • Setting a Format Mask
  • Manipulating Objects
  • Modifying Visual Attributes
  • Applying Conditional Formatting

Managing Report Templates
  • Using Report Templates
  • Modifying a Template
  • Customizing the Template Margin
  • Adding Web Links to a Template for Report HTML Output
  • Predefining Your Own Templates
  • Adding a Template Preview Image

Creating a Web Report
  • What Is JSP Technology?
  • JSP Advantages
  • Simple JSP Example
  • Building a Web Report
  • Using the Report Wizard
  • Report Editor: Web Source View
  • JSP Tags
  • Web Source Example

Enhancing Reports Using the Data Model: Queries and Group
  • The Data Model Objects
  • Modifying Properties of a Query
  • Applying Changes
  • Changing the Group Structure
  • Group Hierarchy
  • Ordering Data in a Group
  • Query Modifications
  • Filtering Data in a Group

Enhancing Reports Using the Data Model: Data Sources
  • Data Source Types
  • Pluggable Data Sources
  • Using XML as a Data Source
  • Document Type Definition File
  • OLAP Data Source
  • Using Text as a Data Source
  • Using JDBC as a Data Source
  • Using REF Cursor Queries

Enhancing Reports Using the Data Model: Creating Columns
  • Data Model Columns
  • Maintaining Data Source Columns
  • Producing File Content Output
  • Creating a Column
  • Creating Summary Columns
  • Displaying Subtotals
  • Displaying Percentages
  • Creating a Formula Column

Enhancing Reports Using the Paper Layout
  • Viewing the Paper Layout
  • Designing Multi-panel Report
  • Printing Multi-panel Reports
  • Different Objects in the Paper Layouts
  • The Paper Layout Layers
  • Report Processing
  • Paper Layout Tools
  • Report Bursting

Controlling the Paper Layout: Common Properties
  • Modifying Paper Layout Object Properties
  • Common Layout Properties
  • Sizing Objects
  • Anchors
  • Layout Object Relationships
  • Pagination Icons in the Paper Layout
  • Controlling Print Frequency
  • Using Format Triggers

Controlling the Paper Layout: Specific Properties
  • Properties of a Repeating Frame
  • Specifying Print Direction
  • Controlling the Number of Records per Page
  • Controlling Spacing Between Records
  • Minimum Widow Records
  • System Variables
  • Valid Source Columns
  • Displaying File Contents

Web Reporting
  • Comparing Static and Dynamic Reporting
  • Adding Dynamic Content
  • Creating a Report Block
  • Invoking the Report Block Wizard
  • Examining the Web Source Code
  • rw:foreach Tag
  • rw:field Tag
  • Customizing Reports JSPs

Extending Functionality Using XML
  • Why Use XML Report Definitions?
  • Creating XML Report Definitions
  • Partial Report Definitions: Format Modification Example
  • Partial Report Definitions: Format Exception Example
  • Full Report Definition: Data Model Modification Example
  • Running XML Report Definitions
  • Debugging XML Report Definitions

Creating and Using Report Parameters
  • Creating User Parameters
  • Referencing Parameters in a Report Query
  • Using Bind References
  • Using Lexical References
  • Hints and Tips When Referencing Parameters
  • Creating a List of Values
  • Referencing System Parameters
  • Building a Paper Parameter Form

Embedding a Graph in a Report
  • Adding a Graph to a Paper Report
  • Adding a Graph to a Web Report
  • Selecting the Graph Type
  • Selecting the Graph Data
  • Adding Options to the Graph
  • Customizing Web Graphs
  • The rw:graph Tag
  • Customizing Graphs Using the Graph.XML File

Enhancing Matrix Reports
  • The Matrix Data Model
  • The Matrix Paper Layout
  • Creating Matrix Summaries
  • Creating the Matrix Manually
  • The Matrix with Group Data Model
  • The Matrix with Group Layout
  • Building a Nested Matrix
  • Nested Matrix Paper Layout

Coding PL/SQL Triggers
  • Types of Triggers in Reports
  • Trigger Code
  • Using Report Triggers
  • Using Data Model Triggers: PL/SQL Group Filter
  • Using Data Model Triggers: Parameter Validation
  • Using Layout Triggers
  • Using Format Triggers
  • Event-Based Reporting

Extending Functionality Using the SRW Package
  • Contents of the SRW Package
  • Outputting Messages
  • Executing a Nested Report
  • Restricting Data
  • Initializing Fields
  • Creating a Table of Contents
  • Performing DDL Statements
  • Setting Format Attributes

Maximizing Performance Using OracleAS Reports Services
  • Running Reports Using OracleAS Reports Services
  • Report Request Methods
  • Oracle Application Server Components
  • Enabling Single Sign-On Access
  • Running the Web Layout: JSP Run-time Architecture
  • Running the Paper Layout: Servlet Run-time Architecture
  • Running a Paper Report on the Web
  • Queue Manager

Building Reports: Efficiency Guidelines
  • Tuning Reports
  • Performance Measurement
  • Non SQL Data Sources
  • Investigating the Data Model
  • Investigating the Paper Layout
  • Running the Report
  • Different Development and Run-Time Environments
  • Developing Reports to Run in Different GUIs

Introduction to Oracle Applications
  • Role of Technical Consultant
  • Architecture
  • Architecture of Oracle Application Package
  • Product Directory Structures
  • Users
  • Responsibilities
  • Role of Apps Database User
  • File Objects in Oracle Applications
  • Database objects in Oracle Applications
  • Profile Options
  • Registration
  • Table Registration
  • Table Registration using AD_DD package
  • View Registration
  • Sequence Registration
  • New Application/New Module Development
  • Form Registration
  • Form Functions
  • Non-Form Functions
  • Basic Report Registration
  • Parametric Report Registration
  • Registration of SQL*Plus files
  • Registration of SQL*Loader files
  • Report Development
  • Customization of Reports – Adding DFF Info
  • Customization of Reports – Removing Parameter s
  • Flexfield Report with Single Structure
  • Interface Development
  • Interface Scenarios
  • Usage of Standard Import Programs
  • Daily Rates Import
  • GL_Interface
  • Up-gradation
  • Forms Up-gradation
  • Reports Up-gradation
  • Menus Up-gradation
  • XML Publisher
  • Introduction
  • Generating XML File through Report Builder
  • Creating a Template
  • Generating RTF Output
  • Register XML Report in APPS
  • Discoverer Administration Edition
  • Creating a private end user layer for a new tutorial
  • database user
  • Connecting to discoverer administrator , using the load
  • wizard and the work area
  • Modifying the Business Area
  • Working with Custom Folders
  • Creating Joins
  • Customizing Items
  • Designing a complex Folder
  • Working with Hier archies
  • Form Development Process
  • Template Form Architecture
  • Appsstand Architecture
  • FNDMENU Architecture
  • Coding Standards
  • Name Conventions
  • Form Development Process
  • WHO Information Tracking
  • Row LOV
  • Queries find Window
  • Customization of Forms
  • Programming of Non-Form Functions
  • Calendar s
  • Flexfields
  • Introduction to Key and Descriptive Flexfields
  • Enabling a DFF
  • DFF Registration
  • KFF Registration
  • Define a KFF Flexfields Structure
  • Invoking DFF form of New Form
  • Invoking KFF Form of New Form
  • Report Development
  • Report Coding Standar ds
  • User Exits in Report design
  • Customization of Reports – Adding Parameter s
  • Customization of Reports – Adding Logos
  • Discoverer User Edition
  • Creation of Simple Workbook
  • To design parameterized workbook
  • To change Heading items
  • To insert new sheet in the Workbook
  • To add and remove items from Workbook
  • To create duplicate sheet in Workbook
  • To add title to the Worksheet
  • To insert date, time, page numbers and image on
  • Header /Title of Workbook
  • To apply Conditional For matting

Introduction to Oracle Applications
  • Introduction to ERP
  • What is oracle
  • History of Oracle & People behind Oracle Corp
  • What is Oracle Application/E-Business suite
  • Versions available in Oracle
  • Versions available in Oracle Application
  • What are major modules available in Oracle
  • ERP’s available in the market
  • Why Oracle application is so popular
  • What Basically Implementation is?
  • Overview of Implementation of Oracle Application
  • Companies Implementing Oracle Application
  • Overview of AIM
  • Job Opportunities & Academic requirement

Oracle General Ledger
  • Introduction
  • Calendars
  • Flex fields
    1] Accounting Flex field
    2] GL Ledger Flex field
  • Chart of accounts
  • Accounting Setup Manager
  • Define Legal Entities
  • Define Ledgers
  • Define Accounting Options
  • Add Legal Entities to Ledgers
  • Assign BSV to Legal Entities
  • Ledger sets
  • Definition Access Sets
  • Auto copy journals
  • Reversal journals
    1] Manual reversal
    2] Auto reversal
  • Suspense Journals
  • Recurring Journals
    1] Standard
    2] Skeleton
    3] Formula
  • Inter Company & Intra company journals
    1] Without Qualifying method
    2] With Qualifying method
  • Reporting Currency Ledgers
    1] Balance Method
    2] Journal Method
    3] Sub Ledger Method
    4] Adjustments Only
  • Revaluation Process
  • Consolidation Workbench
  • Summary of Accounts
  • Period Close Process

Oracle Purchasing
  • MOAC Setup
    1] Define Locations
    2] Define Business Group
    3] Define Operating Units
    4] Define Security Profiles
    5] Define HR Organization
    6] Define Security and User Access
    7] Define Purchasing Options
    8] Define Jobs
    9] Define Positions
    10] Define Employees
    11] Define Employee/Position Hierarchies
    12] Define Buyers
    13] Define Approval Groups
    14] Approval Group Assignments
  • Process Setups
    1] Define Master Items
    2] Create Requisitions
    3] Define Suppliers
    4] Create Purchase Orders
    5] Approving Purchase Orders
    6] Creating Receipts
    7] Self Billing Invoices (Auto Invoice)
    8] Create Document Styles
    9] Create Complex Work Orders
    10] Create Accounting
    11] Returns
    12] Receiving Options
    13] Close/ Cancel P.O Requisition P.O Gaps
  • Oracle Payables
  • MOAC Setup
  • Define Financial Options
  • Define Payables Option
  • Invoice Work Bench
  • 1] Standard
    2] Credit Memo
    3] Debit Memo
    4] Mixed Invoices
    5] Pre Payments
    6] Retain Age Release
    7] Payment Request
    8] Expense Report
    9] Withholding Tax Invoices
    10] Interest Invoices
    11] Transportation Invoices
    12] Recurring Invoices
    13] Define Grants & Roles (User Management)
    14] Define Banks
    15] Define Branches
    16] Define Bank Accounts
    17] Define Payables Documents
    18] Define Organization Access
    19] Define Netting Accounts
  • Payment Workbench
    1] Manual Payments
    2] Quick Payments
    3] Netting Payments
    4] Bills Receivables
    5] Refund Payments
  • Period Close Process
  • Holds
  • Manual Hold
  • System Hold
  • Invoice Matching With P.O
  • Quick Match
  • Match (P.O)
  • Adjustment Invoices
  • Corrections
  • Payment Terms
  • Distribution Set
    1] Full Type
    2] Skeleton Type
  • Cancellation Invoices
  • Oracle Payments (ipayments)
    1] System Security Options
    2] XML Publisher Format Template
    3] Payment Format
    4] Payment Methods
    5] Payment Method Defaulting Methods
    6] Payment Process Profile
    7] Payments Manager
  • Fixed Assets
    1] Flex filed
    a] Category Flex field
    b] Asset Key
    c] Location
    2] Define System Controls
    3] Define Fiscal Years
    4] Define Calendars
    a] Depreciation Calendar
    b] Prorate Calendar
    5] Define Prorate Conventions
    6] Define Depreciation Methods
    7] Define Asset Categories
    8] Define Asset Books
    9] Addition of Assets
    10] CIP Addition
    11] Quick Addition
    12] Manual Addition
    13] Mass Addition
    14] Mass addition of Assets from Payables
    15] Run Depreciation
    16] Mass Retirements
    17] Mass Revaluation
    18] Mass Changes
    19] Mass Transfers
    20] Mass Re-Classifications
    21] Create Accounting
    22] Transferring Assets to GL
  • Oracle Receivables
    1] MOAC Setups For Receivables
    2] Configure System Options
    3] Introduction to TCA
    4] TCA Setups
    5] DQM:-
    a] Security
    b] Profile Classes
    c] Customers
    d] Parties
    e] Organizations
    f] Relationships
    g] Administration & Security
    6] Auto Accounting
    7] Transaction Types
    8] Transaction Batch Sources
    9] Document Sequencing
    10] Transaction Workbench
    a] Invoices
    b] Credit Memo
    c] Debit Memo
    d] Deposits
    11] Guarantee
    12] Charge back
    13] Bills Receivables
    14] Transaction With Rules
    a] Invoicing Rules
    b] Accounting Rules
    15] EBT (Enterprise Business Taxes)
    a] Geography Codes
    b] Tax Regimes
    c] Taxes
    d] Tax Statuses
    e] Tax Jurisdiction
    f] Tax Rates
    g] Tax Rules
    h] Application Tax Options
    i] Configuration Tax Options
    j] Create Party Tax Profile
    k] Create Party Tax Profile for third parties
  • Sub Ledger Accounting Methods
    a] Event Entities
    b] Event Classes
    c] Event Types
    d] Process Categories
    e] Sources
    f] Mapping set
    g] Journal Entry Description
    h] Journal Line Types
    i] Journal Line Definitions
    j] Application Accounting Definitions
    k] Sub ledger Accounting Methods
    l] Customizing SLA
  • Cash Management
    a] MOAC for Cash Management
    b] Define System Parameters
    c] Define Reconciliation Controls At Internal Banks
    d] Manual Reconciliation
    e] Automatic Reconciliation
    f] Bank Account Transfers
  • Oracle Technical - Application Object Library
    a] Introduction to Application Object Library
    b] About Application Folders
    c] Introduction to Interfaces
    d] Types of Interfaces
    e] Understanding SQL *Loader
    f] Interface – Journal Import Using – Excel Data
    g] Interface – Budget upload Using – Flat file Data
    h] Introduction to Concurrent Programs
    i] Concurrent Programs – – SQL Loader
    j] Concurrent Programs – Journal Line Report – Oracle D2K Reports
  • Highlights of the Program
    a] Check our Course Curriculum before you join anywhere
    b] Attend 1 Free Demo Classes without any Registration
    c] Free FAQ’s Prepared by Faculty
    d] Learn Oracle Financials from the Experts to build your Career

Get The Coaching Training Today!

For more information for courses contact us