Oracle Apps Technical

Reading Time: 2 minutes

Oracle Apps Technical

    Module 1: Introduction to ERP

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

    Module 2: Application Object Library

    • Creating Users
    • WHO columns
    • Creating Responsibilities
    • Menu construction
    • Request group construction

    Module 3: Registration

    • Table Registration
    • Table Registration using AD_DD package
    • View Registration
    • Sequence Registration
    • New Application/New Module Development
    • Form Registration
    • Form Functions
    • Non-Form Functions
    • Report Registration
    • Registration of SQL*Plus files
    • Registration of SQL*Loader files
    • Registration of PL/SQL procedure

    Module 4: Profiles

    • 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

    Module 5: Application development

    • Defining concurrent program
    • Concurrent programs with parameters
    • Working with multiple concurrent programs
    • Scheduling the Concurrent Program
    • Concurrent Program incompatibilities
    • Creating Request Set
    • Procedure registration
    • Value sets

    Module 6: Reports

    • Report development
    • Report registration
    • Parametric report registration
    • Reports with repeating frames

    Module 7: Module Overviews

    • Accounts Payable module flow with base tables
    • Accounts Receivable module flow with base tables
    • Order Management module flow with base tables
    • Purchase order Module flow with base tables
    • General Ledger Module flow with base tables

    Module 8: Interfaces

    • Introduction to Interfaces
    • Outbound Interfaces
    • – Using UTL_FILE package
    • Inbound Interfaces
    • – Using SQL * Loader tool

    Module 9: Value sets

    • Overview of value sets
    • Options in value sets
    • Types of value sets
    • Creation of value set
    • Overview of value set tables

    Module 10: XML Publisher

    • Introduction to XML Publisher
    • Generating XML file using reports
    • Creating Templates
    • Creating Data Definitions

    Module 11: Discoverer

    • Introduction to Discoverer tool
    • Discoverer Administrator
    • Creating Business Areas
    • Discoverer Desktop
    • Creating work books