1. Introduction to Oracle EBS R12

• Advantages of Oracle Applications
• Oracle EBS Architecture
• Implementation
• Upgrade
• Support / Maintenance / Enhancements
• Oracle EBS R12 Modules
• Roles/Jobs in Oracle EBS

2. Instances

• What is an Instance?
• Development Instance
• Testing Instance
• Production Instance
• Migrating Objects from one Instance to another Instance

3. AOL Basics

• Introduction to Application Objects Library (AOL)
• User Creation
• Responsibility
• Menu/Request
• Concurrent Program (Request)
• Request Sets
• User
• Application
• Responsibility
• Request group
• Menu
• Form
• Function
• Profiles
• KFF (Key Flex Fields)
• DFF (Descriptive Flex Fields)
• Executables
• Concurrent Programs
• Concurrent request groups
• Parameters
• Value sets
• custom table registration
• Oracle Alerts
• API's

4. Forms

• Developing Form.
• Registering Form in Applications.

5. Value Sets

• What is Value Sets?
• None
• Independent
• Dependent
• Table
• Pair
• Special

6. Lookups

• What is lookups?
• FND Lookups
• Customer Lookups
• Lookup Creation

7. Flex Fields

• What is Flex Fields
• Key Flex Fields
• Descriptive Flex Fields

8. Profiles

• What is Profile
• Profile levels
• Set / get Profiles

9. RICE Components

• Report Registration RDF / XML Publisher
• Interfaces
• Conversions
• Extensions
• Form Development / Personalization
• OUTBOUND using UTL_FILE

10. Reports

• Developing new report using RDF.
• How to customize oracle standard report.
• User Exists in Reports.
• Triggers in Reports.
• oLexical Parameters.
• Formula Columns in Reports.
• MD-70 Technical Design Document.
• MD-120 Migration Document.

11. Interface / Conversion

• What is interface, Conversion?
• Difference between interface and conversion.
• SQL Loader.
• DB objects required for conversion.
• Developing PO / AP conversion.
• Open Interface vs. API.
• Developing code using API.
• Developing OUTBOUND interface using UTL_FILE.
• Pre-requisites and Exception Handling on UTL_FILE.
• MD-70 Technical design document for Interface / Conversion.
• MD-120 Migration document for Interface / Conversion.

12. Extensions

• What is extension?
• How to customize seeded form using personalization / CUSTOM.pll

13. AIM Standards

• MD.050 Create Application extensions functional design
• MD.070 Create Application extensions technical design
• MD.120 Create Installation routines
• CV.040 Perform conversion data mapping
• CV.060 Design conversion programs
• TE.020 Develop unit test script

14. R12 Functional Flows

• Financials
• Procure to Pay Functional Flow (P2P)
• Order to Cash Functional Flow (O2C)
• 11i and R12 difference