Oracle Applications Technical Training

OracleApps Training technical module makes you understand the architecture, table relations, designing reports and forms using Oracle Apps. It helps connect your business to cloud efficiently.

Oracle Applications Technical Training Curriculum

ERP Concepts

What is ERP?
ERP Vendors
About Oracle Application & SAP
About Oracle Application Projects

Types of Project

Implementation of Projects
Up Gradation of Projects
Supporting Project
Rollout Project

Oracle Application Positions Hierarchies

Functional Consultant & Roles
Technical Consultant & Roles
Techno- Functional Consultant & Roles
Oracle Application DBA & Roles
Oracle Applications 11i/R12 Architecture
Three Tier Architecture Components

Oracle Application 11i/R12 File System

System Administration and Application Object Library (AOL)
Defining an Applications User and Assigning the Responsibilities
Understanding AOL and its Components

Using AD_DD Package to Register Database Component in AOL

Registering Custom Concurrent Programs based on Reports
Sql scripts
PL/SQL Stored Procedures
Registering a Custom Report in Oracle Application with or without parameters
Profile Option in Oracle Applications

AIM Documentation Preparation

MD 70, MD120, CV 60 and TE20
Reports 6i/10g in Oracle Applications
Introduction and Usage of USER_EXITS
Developing a Report from scratch as per Client Requirement
Developing a Report based on MD 50 Document (Reports in GL, AP, PO, INV)
Multi-Org & MOAC Concepts in Oracle Application 11i/R12
Customization of Oracle Standard Reports

Flex fields and Value Sets

Flex Fields and Types of Flex fields
Value Sets and Types of Value Sets
Usage of $FLEX and $PROFILE

Oracle Application Interface

Inbound Interface
About Interface and Scenarios
Interface Tables and Error Tables
Sql * Loader
Standard Gl Interface and Po Requisition
Writing Validation Programs
Outbound Interface


Difference between Conversion / Interface/ Data Migration
Conversion Approach
Interface Table Approach (OIT)
API’s Approach
Direct Insertions
Conversion Package Standards
Set Defaults
Validation Procedure
Loading Procedure and Error Report
Item Conversion and Vendor Conversion based on CV 40 Document
Customer Conversion using API Approach
Lot Number Conversion Using API Approach

Data Migration/Data Extractions

Extracting data from source Instance to Repository Instance

Functional Concepts

Procure To Pay Life Cycles
Order to Cash Cycles
FA To General Ledger Cycles
Technical Data Flow from Front End to Back End


About Sub Ledger Accounting (SLA)
TCA in R11i and R12i
Tables in R12i and R11i
General Ledger in R11i and R12i with tables
About Multi-Org Access Control
MOAC Reports

XML Publisher

Difference between XML Publisher Report and Oracle Reports 6i/10g/11g
About XML Publisher Report and Template Builder
Creation of New Report in XML Publisher
Registration of XML Publisher Reports in Oracle Applications
Template features
Conditional Formatting
Sub Template
IF Condition
IF THEN ELSE condition
Oracle Discoverer 10g

Oracle Apps Forms

Work Discoverer Desktop
Form registration
Form development using templates
Form customization concepts
Form Registration Process
Using function Zoom_available( )
Using procedure Event( )
Real Time Live Project
Implementation Methodology and Supporting Process
Real Time Reports/Interface/conversion/Customization
SQL and PLSQL Performance Methodology
Covering Oracle Financials + Oracle India Localization Financials
100% Placement assistance
Mock Interviews and FAQ’s
Resume Preparation
Real Time help after getting job.

  • 10 Days
  • 0 Units
  • 0 Hrs

Select Your Currency

WOOCS 1.1.8
Drop Us A Query
[contact-form-7 id="5639" title="Drop Us A Query"]
Create an Account