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
• Inbound 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