• • 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 / Oracle SQL Developer

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

• • 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

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

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

• • Introduction to Interfaces
  • Difference Between Interfaces and Conversions
  • Outbound Interfaces
  • Using UTL_FILE package
  • Inbound Interfaces
  • Using SQL * Loader tool
  • SQL * Loader Concepts of Data File.
  • Control File.
  • Bad File.
  • Discard File.
  • 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

• • Overview of flex fields
  • Types of Flex Fields
  • Descriptive Flex Fields
  • 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

• • 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

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

• • 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

• • 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
  • Reports with Barcode

• 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

• overview
• BI Publisher Applications Architecture and components
• Data Model and Report Designer Editor 
• Designing RTF  Template using Word Template Designer
• Design Interactive Reports Using Layout Builder
• BI Publisher Report Registration

• • Location
  • Organization
  • Items
  • Parameters
  • Suppliers and supplier Sites
  • RFQs and Quotations
  • Requisitions
  • Purchase Order
  • Automatic creation
  • Receiving
  • Buyer Work bench
  • Open Periods
  • PO& Requisition Interface

• Inventory Overview
• Define Inventory Organization
• Sub-Inventory
• Unit Of Measures
• Item Creation and update
• On hand and availability
• Issuing and Transfer material
• Sub-Inventory Transfer
• Inter org Transfer
• Item reservation
• Commodity Codes
• Customer Items
• Open Close Periods
• Item Import Interface

• Overview of O2C
• Sales order flow
• Release Rules
• Picking & Shipping
• Interface Trip Stop
• RMA order
• Internal Sales Order
• Drop Ship
• Transaction Types
• Defaulting Rules
• Order Import Interface
• Multi Org
• Multi Org Introduction
• Multi Org Setup

• Overview of Work in Process
• Setting Up Work in Process
• Creating Discrete Jobs
• Updating Material Requirements
• Assigning and Managing Resources
• Defining Scheduling
• Creating Shop Floor Transactions
• Work in Process Cost Transactions

• Introduction to BOM
• BOM Parameters
• Department Class and Standard operation in BOM
• Creation of items and Assign cost to itmes
• Overhades and routings
• Define Discrete jobs
• Define Bills
• Types of Bills