Big Bytes

Oracle Apps Technical Online Training (One to One)

ORACLE APPS Technical Course Content

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

About Training

I am Sridevi Koduru, Senior Oracle Apps Trainer at With 9 Yrs Exp on Oracle Apps and 13 Yrs IT Exp Providing Online Training on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Apps SCM, Oracle Apps HRMS, Oracle Financial for Indian Localization, SQL, PL/SQL and D2K. I have Provided Training for 1000+ Professionals Most of them are Working in Real Time now.

Contact for (One to One Online Training) on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Financial for Indian Localization, Oracle Apps SCM, Oracle Apps HRMS, SQL, PL/SQL and D2K at | | – 9581017828 |

LinkedIn profile –

Leave a Reply

You may also like:

Education Law / Legal Lifestyle Linux People Software Technology World

How to stay safe from Email Server Compromises & Data Scams?

Avoid using tools like mobile apps or fancy desktop apps for email send / receive and other critical transactions.

Read More
Books Education Linux Media / PR Software Technology

The 4Cs of SEO – Code, Content, Connectivity and Commitment

Stay far away from any “fades of the day” or anything that appears spammy, unethical, or tricky. Be bold and plant yourself firmly on the high ground in the middle of the road, however bumpy it maybe.

Read More
Corruption Education Lifestyle Politics Software Startup Technology

Community activists are stars of #SupremeJustice against DRM & digital imperialists

People all over the world spoke out against Digital Restrictions Imperialism with flyering, rallies, jam sessions, and writings. International Day Against DRM was a landslide of community activism in support of media users’ rights. Protestors at the New York City Apple store were evicted by uncomfortable security guards. Principled cooks in Italy created painfully spicy […]

Read More