|
Oracle Application 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
|
|
Registration of Custom Objects
|
- Registration of Application
- Report development
- Report registration
- Parametric report registration
- Registration of a Table
- Registration of Sql, Sql Loader, PL/SQL programs
|
|
Interfaces
|
- Introduction to Interfaces
- Outbound Interfaces
- Inbound Interfaces
- SQL * Loader Concepts
- Data File.
- Control File.
- Bad File.
- Discard File.
- Log File.
- Commands in Sql * Loader
- Registration Of control File in Oracle Apps.
|
|
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
|
- Overview of flex fields
- Types of Flex Fields
- Descriptive Flex Fields
- Key Flex Fields
- Step in creation of DFF
- Flex fields tables and relations
|
|
Profiles
|
- Overview of profile options
- Different levels in Setting profiles
- Steps in setting a profile option
- Some important profile options
- Some important API’s of profiles
|
|
Value sets
|
- Overview of value sets
- Options in value sets
- Types of value sets
- Creation of value set
- Overview of value set tables
|
|
Multi Org Concepts
|
- What is Multi Org and why we need.
- Multi Org Tables.
- Multi Org Views.
|
|
PO Overview and tables
|
- Overview of purchasing
- Major setups and transactions
- Overview of some purchasing tables
|
|
INV Overview and Tables
|
- Overview of inventory
- Major setups and transactions
- Overview of some INV Tables
|
|
OM Overview and Tables
|
- Overview of order management
- Major setups and transactions
- Overview of some Order Management Tables
|
|
GL Overview and Tables
|
- Overview of GL
- Major setups and transactions
- Overview of some GL tables
|
|
AP Overview and tables
|
- Overview of payables
- Major setups and transactions
- Overview of some payable tables
|
|
Form personalization
|
- Forms personalization: need and benefits
- Use validate feature to confirm conditions and strings
- Form Personalization v/s Form Customization
|
|
Alerts
|
- Overview on alerts
- Types of alerts
- Creation of alerts
|
|
Workflows
|
- Introduction to workflow
- Workflow builder
- Attributes
- Creating Processes
|
|
XML Publisher
|
- Introduction to XML Publisher
- Generating XML file using reports
- Creating Templates
- Creating Data Definitions
|
|
FAQ’s in Oracle Apps
|
|
Job Assistance
|