Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Oracle Apps Technical Online Training

No Reviews Yet

Course type: Online Instructor led Course

Platform: Through GOTO Meeting

Course ID: 9308

Course type: Online Instructor led Course

Platform: Through GOTO Meeting

Students Interested 0 (Seats Left 0)

No Reviews Yet

Date and Time

Not decided yet.

SrinivasGlory picture

About SrinivasGlory

We stay with you until you get the results you want. If you really interested, please let me know . We will arrange the Demo Session, Feel Free to call us any time

Thanks & Regards
Glory IT Technologies
No reviews currently Be the First to Review

About the Course

Oracle Apps Technical Online Training is Offering at Glory IT Technologies.Oracle Apps Technical is a collection of a bunch of collected applications like accounts payables, purchasing, inventory, accounts receivables, human resources, order management, general ledger and fixed assets, etc which have its own functionality for serving the business.

Topics Covered

Introduction to ERP

• Definition of ERP
• Overview of popular ERP’S
• Comparison of Oracle Apps with other ERP’S
• AIM documentation standards
• Oracle Application Architecture.
• Database structure of OA
• Using TOAD

Types of Roles

• Functional Consultant and Roles
• Technical Consultant and Roles
• Techno-Functional Consultant and Roles
• Oracle Application DBA and Roles

Application Object Library

• System Administration and Application Object Library (AOL)
• Defining an Applications User and Assigning the Responsibilities.
• Understanding AOL and its Components
• WHO columns
• Creating Responsibilities
• Request group creation
• Menu Creation

Application development

• Defining concurrent program
• Concurrent programs with parameters
• Working with multiple concurrent programs
• Concurrent Program incompatibilities
• Creating Request Set
• Default Types
• Value sets

Registration of Custom Objects

• Report registration
• Registration of a Table
• Using AD_DD Package to register Database Component in AOL

Interfaces and Conversions

• Introduction to Interfaces
• Difference Between Interfaces and Conversions
• Outbound Interfaces
o Using UTL_FILE package
• Inbound Interfaces
o Using SQL * Loader tool
• SQL * Loader Concepts o Data File.
o Control File.
o Bad File.
o Discard File.
o Log File.
• Working with staging table script
• Developing validations package
• Standards to be followed in conversions
• Using oracle API’s in Interfaces and Conversions
• Interface Tables and Error Tables

Flex Fields

• Overview of flex fields
• Types of Flex Fields
o Descriptive Flex Fields
o Key Flex Fields
• Step in creation of DFF
• Flex fields tables and relations


• Overview of profile options
• Different levels in Setting profiles
• Steps in setting a profile option
• Some important profile options
• Some important API’s of profiles

Value sets

• Overview of value sets
• Options in value sets
• Types of value sets
• Creation of value set
• Overview of value set tables
• Usage of $FLEX and $PROFILE

Multi Org Concepts

• What is Multi Org and why we need.
• Multi Org Tables.
• Multi Org Viiews.

Functional Modules Overview

• Overview of Procure to Pay Flow (P2P Cycle)
• Overview of Order to Cash Flow (O2C Cycle)
• Major setups and transactions
• Overview of important tables in PO,INV,OM,AP,AP,GL

Reports 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.
• Customization of Oracle Standard Reports.
• Reports Registration Steps in Oracle Applications
• Standards to develop a report in Oracle Apps

Forms in Oracle Applications

• New Form Development Process
• Form Registration in Oracle Applications.
• Calling one Form to another Form by using Button
• Master-Detailed Forms
• Form Personalization in Oracle Applications
• Form Personalization v/s Form Customization

Development of XML Reports

FAQ’S in Oracle Apps Technical

For Better Understanding of Your Training Sessions We have Furnished the Training Contents as Session by Session
Session 1

• Definition of ERP
• Introduction to Oracle Applications
• Types of Data

Session 2

• Functional Consultant and Roles
• Technical Consultant and Roles
• DBA and Roles
• Types of Projects

Session 3

• Oracle Application Architecture
• Data Base Structure of Oracle Applications
• Introduction to Rice Components

Session 4

• System Administration and Application Object Library (AOL)
• Defining Application Users and Assigning the Responsibilities.
• Creating Responsibilities
• FND Tables and Understanding AOL and its Components

Session 5

• Registration of Tables
• Using AD_DD Package
• Procedures to Register Database Tables in AOL Module

Session 6

• Report Registration Steps
• Register the Report in AOL Module
• Executable Creation of Reports
• Defining the Concurrent Program
• Creation of Request Group

Session 7

• Register the Parametric Report in AOL Module
• Introduction to Report Parameters
• Types of Parameters
• Creating Value Sets
• Value Set Default Types

Session 8

• Developing a Report from Scratch as per Client requirement
• Default Report Styles
• Customization of Oracle Standard Reports

Session 9

• Introduction to Forms
• Form registration in Oracle Applications

Session 10

• Creating Functions in AOL Module
• Creation of New Menu
• Oracle Application Default Menus

Session 11

• Introduction to Template.FMB
• Appstand.FMB
• Introduction to Pre Defined Objects in Template.FMB

Session 12

• Creating of New Template
• Creating of New Block, Canvas in Template
• Registration Steps for Template

Session 13

• Overview of Flex Fields
• Types of Flex Fields
• Introduction to Key and Descriptive Flex Fields

Session 14

• Steps for Creation of DFF
• Flex Field Tables and Relations

Session 15

• Overview of Profiles Options
• Different Levels in Setting Profiles
• Some Important Profile Options
• Steps in Setting Profile Options

Session 16

• Multiple Organization Concepts
• Introduction to Multi Org
• What is Multi Org and Why we need it
• Defining Multi Org Structure

Session 17

• Multi Org Tables
• Overview of Procure to Pay (P2P Cycle)
• Overview of Order to Cash (O2C Cycle)
• Overview of Important Tables in PO, Inventory, OM, AP, AR, GL

Session 18

• Introduction to Interfaces
• Difference between Interfaces and Conversions
• Types of Interfaces
• Inbound Interfaces
• Using SQL * Loader

Session 19

• Working with Staging Table Scripts
• Developing Validations Package
• Interface Tables and Error Tables

Session 20

• Introduction to Conversions
• Conversion Flow

Session 21

• Introduction to AIM Documentation
• Preparation of AIM Documents

Session 22

• Introduction to Business Documents
• Preparation of MD 50 Documents, MD 70 Documents etc.

Session 23

• Functional Flows of GL, AP, AR
• Back End Tables

Session 24

• Introduction of XML Reports
• Developing XML Reports

Session 25

• Steps for Registering the XML Reports in AOL Module
• Back End Tables
• FAQ’S in Oracle Apps Technical

Who should attend

For Online Training classes it can be any one who has a passion towards learning online training courses


Student must be familiar with Concepts in SQL, PL/SQL, and D2K. If you have knowledge in these it will be helpful to understand Oracle Apps Easily.

What you need to bring

these are online classes"

Key Takeaways

oracle apps technical training,apps technical online, oracle apps technical


No reviews currently Be the First to Review


Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Oracle 11i Financial Post your requirement now


Submit your enquiry for Oracle Apps Technical Online Training

Please enter valid question or comment

Please select a category

No matching category found.

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Glory IT Technologies

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer