Welcome to ApplStar Technologies - ORACLE REALTIME TRAINING

Login/Signup

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