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