ORACLE APPS Technical Training Overview
Introduction
• 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 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
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 EUL
• Creating Business Areas
• Discoverer Desktop
• Creating work books
• Frequently Asked Questions
• Conversion Project included in the course.