Oracle Applications Technical
Course Contents |
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
|
|