ORACLE APPS TECHNICAL


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