ORACLE APPS TECHNICAL

Course Overview :

Oracle apps technical provides students with a basic understanding of the architecture, database and file system used in Oracle Applications Release 11i. Students will learn about the multi-tier architecture used to provide user access over the Internet or an intranet and the relationship between Oracle Applications and the Oracle database.

Prerequisties

• All attendees should have good knowledge of SQL and PL/SQL.

Course Content

• 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 Data Definitions