Oracle Apps Technical Course

ORACLE

ORACLE – APPS TECHNICAL COURSE CONTENT

1. 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
2. Application Object Library
   •  Creating Users
   • WHO columns
   • Creating Responsibilities
   • Menu construction
   • Request group construction
3. 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
4. Reports registration
   • Report development
   • Report registration
   • Parametric report registration
   •  Reports with repeating frames
5. 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
6. 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( )
7. Interfaces
   •  Introduction to Interfaces
   • Outbound Interfaces
   •  – Using UTL_FILE package
   • Inbound Interfaces
   •  – Using SQL * Loader tool
8. Conversions
   •  Overview on conversions
   •  Difference between Interfaces and conversions
   •  Working with staging table script
   •  Developing validations package
   •  Standards to be followed in conversions
9. Flex Fields
   •  Types of Flex Fields
   •  Descriptive Flex Fields
   •  Key Flex Fields
10. Workflows
    • Introduction to workflow
    •  Workflow builder
    •  Attributes
    •  Creating Processes
    •  Sending notifications using workflows
11. XML Publisher
    • Introduction to XML Publisher
    •  Generating XML file using reports
    •  Creating Templates
    •  Creating Data Definitions
12. Discoverer
    • Introduction to Discoverer tool
    •  Discoverer Administrator
    •  Creating EUL
    •  Creating Business Areas
    •  Discoverer Desktop
    •  Creating work books