Oracle Applications Technical Training

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

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
nbound Interfaces
Using SQLLoader 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

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

Discoverer

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