Oracle Apps Technical
Module 1: 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
Module 2: Application Object Library
- Creating Users
- WHO columns
- Creating Responsibilities
- Menu construction
- Request group construction
Module 3: Registration
- Table Registration
- Table Registration using AD_DD package
- View Registration
- Sequence Registration
- New Application/New Module Development
- Form Registration
- Form Functions
- Non-Form Functions
- Report Registration
- Registration of SQL*Plus files
- Registration of SQL*Loader files
- Registration of PL/SQL procedure
Module 4: 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
Module 5: 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
Module 6: Reports
- Report development
- Report registration
- Parametric report registration
- Reports with repeating frames
Module 7: Module Overviews
- Accounts Payable module flow with base tables
- Accounts Receivable module flow with base tables
- Order Management module flow with base tables
- Purchase order Module flow with base tables
- General Ledger Module flow with base tables
Module 8: Interfaces
- Introduction to Interfaces
- Outbound Interfaces
- – Using UTL_FILE package
- Inbound Interfaces
- – Using SQL * Loader tool
Module 9: Value sets
- Overview of value sets
- Options in value sets
- Types of value sets
- Creation of value set
- Overview of value set tables
Module 10: XML Publisher
- Introduction to XML Publisher
- Generating XML file using reports
- Creating Templates
- Creating Data Definitions
Module 11: Discoverer
- Introduction to Discoverer tool
- Discoverer Administrator
- Creating Business Areas
- Discoverer Desktop
- Creating work books