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

Courses Duration : 3-4 weeks

1
Main