Oracle Apps Training - Course Content

Oracle Apps Training
Part1 Introduction


§  Session 1 Demo session – Introduction of the trainer, explaining the course contents, pre-requisites, and methodology of the training. Oracle Apps Org structure with Example.
§  Session 2 What is ERP?, comparison of Oracle Apps with other ERPS
§  Session 3 Types of Roles, Types of projects, AIM documents
§  Session 4 Oracle Apps file structure, database structure and 3-tier architecture
Part2 Application Object Library


§  Session 5 Levels of Oracle Applications, Creating users, WHO columns, Creating responsibilities
§  Session 6 Menu construction, Defining concurrent programs, assign concurrent program to request group
§  Session 7 Concurrent program with parameters, Creating Value sets, incompatibilities
§  Session 8 Scheduling concurrent program, Creating request group, Creating request set
§  Session 9 Enabling Flexfield DFF segments in Oracle apps.
Part3 Module Overviews


§  Session 10 Inventory Module flow with base tables
§  Session 11 Material transactions, Item creation, check item on hand quantity.
§  Session 12 Order to Cash Flow with base tables
§  Session 13 Procure to Pay flow with base tables
§  Session 14 Important order management flows like Drop ship,  Back to Back, IR-ISO Process flows
Part4 Reports


§  Session 15 Report development process, Report registration process
§  Session 16 Bind parameters, lexical parameters, reports with value set, Building report manually
§  Session 17 Using repeating frames, Summary columns , Standard report customization
Part5 Interfaces


§  Session 18 Introduction to Interfaces, working with Out Bound Interfaces, using UTL_FILE package
§  Session 19 Inbound Interface process, Working with SQL*Loader tool
§  Session 20 Different option in SQL *Loader tool, bad file, discard file
§  Session 22 Using Interface table approach
§  Session 22 Using API Approach
Part6 Conversions


§  Session 23 Introduction to conversions, Creation of staging table.
§  Session 24 Developing the validation package, explaining the real time project code.
§  Session 25 Completing the conversion task, Differences between Inbound interfaces & Conversions
Part7 Forms


§  Session 26 Form registration process
§  Session 27 Form personalization with example.
§  Session 28 Form personalization Using Custom.pll
Part8 Workflows


§  Session 29 Workflow Introduction, Workflow development process, running the workflow
§  Session 30 Sending notifications, branching the workflow using result out variable
§  Session 31 Running workflow from back end, important workflow tables.
Part9 XML Publisher


§  Session 32 Introduction to XML publisher, Report development process
§  Session 33 Creating reports for multiple rows, Creating Data definitions, Creating templates
Part10 Flex fields


§  Session 34 What are Descriptive Flexfield attributes and how they are activated.
§  Session 35 Making DFFs non Editable.
Part11 Sample Demo Projects: Session 36-40


§  Sample Demo Project – 1
§  Sample Demo project – 2
§  Sample Demo project – 3
§  Sample Demo Project – 4
§  Sample Demo project – 5
Part12 Interview Preparation & Resume preparation (If required) 41-45