Oracle Apps Technical Online Training

Oracle Apps Technical Online Training Course Details

Oracle Apps Technical Online Training Course Content

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

Application Object Library

 Creating Users

 WHO columns

 Creating Responsibilities

 Menu construction

 Request group construction

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 registration

 Report development

 Report registration

 Parametric report registration

 Reports with repeating frames

Module Overviews

 Inventory Module flow with base tables

 Accounts Payable module flow with base tables

 Accounts Receivable module flow with base tables

 Order Management module flow with base tables

Form registration

 Template.fmb

 Appstand.fmb

 Form development using templates

 Form customization concepts

 Form Registration Process

 Custom.Pll

 Using function Zoom_available( )

 Using procedure Event( )

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

o Descriptive Flex Fields

o Key Flex Fields

Workflows

 Introduction to workflow

 Workflow builder

 Attributes

 Creating Processes

 Sending notifications using workflows

XML Publisher

 Introduction to XML Publisher

 Generating XML file using reports

 Creating Templates

 Creating Data Definitions