Online Guru Technologies’s Oracle Apps Technical training running with industry experts  according to industry requirements and demands.

This training helps you crack the interview and clear the certification as well.

Here you will get all class videos lifetime access.

Even after completion of course 24/7 support is provided for clearing interviews and certification.

By the end of the course a separate class is scheduled for interview questions and answers.

Online Guru Technologies will provide a platform to work for real time projects.


  • Types of roles
  • Types of projects
  • AIM documents
  • Oracle apps architecture
  • Database

Application Object Library (AOL)

  • Levels of oracle applications access
  • Creating users
  • WHO’s Columns
  • Creating Responsibilities
  • Menu construction
  • Request group construction

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

Value sets

  • Types of value sets
  • Creation value sets
  • Using value sets

Look ups

  • Creating look up and usage

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

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


  • 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

Oracle API’s


  • Introduction of conversions
  • Difference between interface and conversions
  • Working with staging table script
  • Developing validation package
  • Standard to be followed in conversion

Flex filed

  • Type of flex field
  • Descriptive flex field (DFF)
  • Key flex filed (KFF)


  • 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


Techno functional flow

  • P2P Cycle
  • O2C Cycle

Oracle Forms

  • Template .fmb
  • Fmb
  • Form development using template
  • Form customization concepts
  • Form registration process
  • pil
  • Using function zoom available ()
  • Using procedure event ()


  • Workflow introduction
  • Development process
  • Running workflow and sending notification

Discoverer report

  • Introduction
  • Discoverer administrator
  • Creating EUL
  • Creating business area
  • Creating joins, item class
  • Using discoverer desktop
  • Creating workbook
  • Discoverer report registration process


Online Guru Technologies conducting Free Oracle Apps Technical demo Classes with Industry experts for clarifying doubts and knowing about course, for attending free demo session Click on the “Schedule Free Demo Session” and Fill the form. Our representative will call you back and they will fix demo session timings according to your convent timings

The Demo sessions are conducting every day 1 Hour Session, the demo session conducting by real-time working professionals.

Call us on +91 - 9886508358

Training class hours – 60

All classes recorded videos

Lifetime access videos

Project classes hours – 10

Everyday support

Related Courses


7:00 AM-10:00AM - MON TO FRI

7:00 AM-10:00AM - SAT & SUN


WhatsApp chat