About the Course
Good to have prior knowledge of SQL, PL/ SQL, Oracle Forms and Oracle Reports
Topics CoveredOverview of Oracle products used and Oracle Applications Architecture
? Client/Server architecture
? Explain Oracle product with Oracle with Developer/2000. – This point understands
? people why and how Oracle Application works, useful and developed initially form based and web based.
? 3 tier architecture (for ERP) Database--Application-Client
? Preview of Oracle Applications:
? Why Business needs
? Who needs it
? How they can use
? What best business can achieve with this
? Explain different parts in Oracle Applications with modules in each area and flow and
? Connectivity between modules with diagram.
? Supply Chain Introduction to ERP ? Definition of ERP, Overview of popular ERP'S ? Comparison of Oracle Apps with other ERP'S ? Over view of Oracle E-Business suite ( EBS) ? Types of Roles ? Types of Projects ? AIM documentation standards ? Oracle Application Architecture. ? Database structure of OA ? Using TOAD ? Business Requirements Gathering ? GAP Analysis ? Setup Process ? Deliverable Process Architecture: ? Architecture of Oracle Application Package ? Product Directory Structures ? Users ? Responsibilities ? File Objects in Oracle Applications ? Database objects in Oracle Applications ? Profile Options
System Administration and Application Object Library (AOL) ? Defining an Applications User and Assigning the Responsibilities. ? Understanding AOL and its Components ? Creating a Custom Application Module. ? Using AD_DD Package to register Database Component in AOL. ? Registering Custom Concurrent Programs based on Reports, Sql scripts, PL/SQL Stored Procedures. ? Registering a Custom Reports in Oracle Application with or without parameters. ? Profile Option in Oracle Applications. ? Define User, Responsibilities , Define, Request Group ,Request set ? Profiles, System , Personal ? Application, Register ,Form, Function ? Menu , Menu creation ? Define Value Sets ? Flex fields, Key and Descriptive ? Define Currency, Concurrent Program ? Understanding Customization ? Customizing form with custom pll/ Forms Personalization Reports registration ? Report development ? Report registration ? Parametric report registration ? Reports with repeating frames
? Types of Flex Fields
? Descriptive Flex Fields
? Key Flex Fields
? Flex field’s tables and relations
? Overview of value sets
? Options in value sets
? Types of value sets
? Creation of value set
? Overview of value set tables
Multi Org Concepts
? What is Multi Org and Operating unit why we need.
? Multi Org Tables.
? Multi Org Views.
Introduction to Interfaces
? Inbound Interfaces
? Using SQL * Loader tool
? SQL * Loader Concepts
? Data File.
? Control File.
? Bad File.
? Discard File.
? Log File.
? Commands in Sql * Loader
? Registration Of control File in Oracle Apps.
? Working with staging table script
? Developing validations package
? Introduction to interface tables in all modules
? Usage of Standard Import Programs
? GL Interface
? Outbound Interfaces
? Using UTL_FILE package
? Overview on Conversions
? Difference between Interfaces and conversions
? Working with Staging Table Script
? Developing Validations Package
? Standards to be followed in Conversions
? Introduction to XML Publisher
? Generating XML file using reports
? Creating Templates
? Creating Data Definitions
? Bursting report in XML
? Introduction to Discoverer tool
? Discoverer Administrator
? Creating EUL
? Creating Business Areas
? Discoverer Desktop
? Creating work books
Who should attendAnyone
What you need to bringNothing