Oracle
Apps Training
§ 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