Oracle Apps Technical

Duration of       Hours 


Duration time may vary depends on course progress


Oracle Apps Technical


Oracle Apps Technical is a technical part of ERP. Oracle Finance is a functional part of ERP where in Oracle Apps Technical is a technical part of ERP. With Oracle Apps Technical background you can work at the backend of any ERP like Finance, SCM CRM, and HRMS etc where in with any functional module you will be specialized in that domain only.

Training Objectives of ORACLE APPS TECHNICAL:

Oracle Applications Tools and Technology provides customers with many information driven advantages. Across all Oracle product lines, Oracle Business Intelligence Suite Enterprise Edition, Oracle E-Business Suite, PeopleSoft Enterprise Tools and Technology, JD Edwards World, JD Edwards Enterprise One Tools and Technology.



Course Content

Introduction to ERP:

  •  Definition of ERP, Overview of popular ERP’S

  •  Comparison of Oracle Apps with other ERP’S

  •  Types of Roles

  •  Types of Projects

  •  AIM documentation standards

  •  Oracle Application Architecture.

  •  Database structure of OA

  •  Using TOAD

Application Object Library:

  •  Creating Users

  •  WHO columns

  •  Creating Responsibilities

  •  Menu construction

  •  Request group construction

Application development:

  •  Defining concurrent program

  •  Concurrent programs with parameters

  •  Working with multiple concurrent programs

  •  Scheduling the Concurrent Program

  •  Concurrent Program incompatibilities

  •  Creating Request Set

  •  Procedure registration

  •  Value sets

Reports registration:

  •  Report development

  •  Report registration

  •  Parametric report registration

  •  Reports with repeating frames

Module Overviews:

  •  Inventory Module flow with base tables

  •  Accounts Payable module flow with base tables

  •  Accounts Receivable module flow with base tables

  •  Order Management module flow with base tables

Form registration:

  •  Template.fmb

  •  Appstand.fmb

  •  Form development using templates

  •  Form customization concepts

  •  Form Registration Process

  •  Custom.Pll

  •  Using function Zoom_available( )

  •  Using procedure Event( )


  •  Introduction to Interfaces

  •  Outbound Interfaces

  •  Using UTL_FILE package

  •  Inbound Interfaces

  •  Using SQL * Loader tool


  •  Overview on conversions

  •  Difference between Interfaces and conversions

  •  Working with staging table script

  •  Developing validations package

  •  Standards to be followed in conversions

Flex Fields:

  •  Types of Flex Fields

  •  Descriptive Flex Fields

  •  Key Flex Fields


  •  Introduction to workflow

  •  Workflow builder

  •  Attributes

  •  Creating Processes

  •  Sending notifications using workflows

XML Publisher:

  •  Introduction to XML Publisher

  •  Generating XML file using reports

  •  Creating Templates

  •  Creating Data Definitions


  •  Introduction to Discoverer tool

  •  Discoverer Administrator

  •  Creating EUL

  •  Creating Business Areas

  •  Discoverer Desktop

  •  Creating work books

Have some Questions?

Call us at our care or drop quick contact box

Why with us?
  • Live Quality Training 

  • Live demonstration of of features and practicals.

  • 100% Assurance Placement Assistance

  • Effective Resume building

  • Internship Program for real exposure

  • Interview preparation with mock interview drills

  • Process of applying jobs at right places

  • Guidance of getting flexible, part time jobs

  • Facebook - Black Circle


Corporate Office


364 E Main ST STE 1001

Middle Town

DE 19709


+1 720  738 4411

Subscribe with us for regular


© 2023 by KEYZONE IT