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