Oracle Apps Technical Online Training

Oracle Apps Technical Online Training Course

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