ORACLE APPS TECHNICAL

ORACLE APPS TECHNICAL

Overview:
Oracle Apps Technical is a technical part of ERP. Oracle Finance is a functional part of ERP where in Oracle Apps Technical is a technical part of ERP. With Oracle Apps Technical background you can work at the backend of any ERP like Finance, SCM CRM, and HRMS etc where in with any functional module you will be specialized in that domain only.

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 and 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.

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

About the Trainer

10 + Years of IT experience, provided training for over 1000+ professionals online Real-time IT experience which enables to provide dedicated quality training. Teaching is his passion vast experience in providing online training around the globe with good communication skills.