Oracle Apps Training in Bangalore

ORACLE APPS TECHNICAL TRANING COURSE DETAILS

Demo session

               Introduction of the trainer and company, explaining the course contents, pre-requisites, methodology of training.

               SQL

Session 1             Introduction

Features

Datatypes

Session 2             Commands

DDL commands

DML commands

DRL/DQL commands

TCL commands

DCL commands

Session 3             Functions and operators

Function types

Session 4             Clauses

Session 4             Constraints

Session 4             Joins

Session 5             Sub Queries

Session 5             Views

Session 5             Indexes

Session 6             Sequence

Session 6             Synonyms

               PL/SQL

Session 1             Introduction

Session 1             Exceptions

Session 2             Cursors

Session 3             Procedures

Session 4             Functions

Session 5&6        Packages

Session 7             Triggers

Session 8&9        Advance topics

Session 10           FAQ’s

               Oracle Apps Technical

Session 1             Introduction

Types of roles

Types of projects

AIM documents

Oracle apps architecture

Database

session 2&3        Application Object Library (AOL)

Levels of oracle applications access

Creating users

WHO’s Columns

Creating Responsibilities

Menu construction

Request group construction

Session 4,5&6     Application Development

Explanation of concurrent and executable window

Defining concurrent program

Concurrent program with parameter

Creating Request set

Schedule concurrent request and request set

Procedure registration

Session 7             Value sets

Types of value sets

Creation value sets

Using value sets

Session 8             Look ups

Creating look up and usage

Session 9,10,11&12         RDF Report

Report development

Report registration

Report with parameter registration

Building report manually

Building report by using bind and lexical parameter, value set, frames and repeating frames, summary& formula& place holder columns

Report customization 

Session 13&14    XML Publisher

Introduction to XML publisher report

Generating XML file using reports

Generating XML file using SQL and PL/SQL

Creating RTF Template

Creating XML template

Register XML publisher report

Session 15,16&17             Interfaces

Introduction to interface

Types of interfaces

Outbound interface using UTL_FILE package

Inbound interface using SQL* Loader tool

Different options in SQL* LOADER and different files

Session 18           Oracle API’s

Session 19,20,21&22       Conversions

Introduction of conversions

Difference between interface and conversions

Working with staging table script

Developing validation package

Standard to be followed in conversion

Session 23&24    Flex filed

Type of flex field

Descriptive flex field (DFF)

Key flex filed (KFF)

Session 25,26&27             Modules

Purchase Order (PO) and base tables

Account payable (AP) and base tables

Order Management (OM) and base table

Account Receivable (AR) and base table

General Ledger (GL) and base table

Session 28,29,30&31       Techno functional flow

P2P Cycle

O2C Cycle

Session 32,33&34             Oracle Forms

Template .fmb

Appstand. Fmb

Form development using template

Form customization concepts

Form registration process

Custom.pil

Using function zoom available ()

Using procedure event ()

Session 35&36    Workflows

Workflow introduction

Development process

Running workflow and sending notification

Session 37&38    Discoverer report

Introduction

Discoverer administrator

Creating EUL

Creating business area

Creating joins, item class

Using discoverer desktop

Creating workbook

Discoverer report registration process

Session 39&40    OAF

Session 41           Resume preparation

Session 42           Recall all concepts

Session 43           FAQ’s

Session 44           Discussions on interviews

Session 45           Farewell