Oracle Apps Technical Course Content
Overview:
Oracle Apps Technical is a collection of a bunch of collected applications like accounts payables, purchasing, inventory, accounts receivables, human resources, order management, general ledger and fixed assets, etc which have its own functionality for serving the business.
Training Objectives of Oracle Apps Technical:
Oracle Applications Tools and Technology provides customers with many information driven advantages. Across all Oracle product lines, Oracle Business Intelligence Suite Enterprise Edition, Oracle E-Business Suite, PeopleSoft Enterprise Tools and Technology, JD Edwards World, JD Edwards Enterprise One Tools and Technology.
Target Students / Prerequisites:
Student must be familiar with Concepts in SQL, PL/SQL, and D2K. If you have knowledge in these it will be helpful to understand Oracle Apps Easily.
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