Oracle Apps Technical Training in Marathahalli

Courses Info

Oracle Apps Technical Training in Marathahalli

Training Marathahalli provides excellent Oracle Apps Technical Training in Marathahalli location with experienced trainers. Our training strategies are Class room training, Process flow in Oracle® Application by trainers and independent testing by Students.

Oracle Apps Technical Training Syllabus:

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

Application Object Library

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

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

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

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

Reports

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

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

Interfaces

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

Conversions

    • Overview on conversions
    • Difference between Interfaces and conversions
    • Working with staging table script
    • Developing validations package
    • Standards to be followed in conversions

Flex Fields

  • Types of Flex Fields
    • – Descriptive Flex Fields
    • – Key Flex Fields

Value sets

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

XML Publisher

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

Workflow

  • Introduction to workflow
    • Workflow builder
    • Creating Processes

Discoverer

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

P2P (procure To pay) Bussiness Flow(Tables Explaination)

O2C (Order To Cash) Bussiness Flow(Tables Explaination)

Download Syllabus