§ 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 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 Flex field 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 12Order to Cash Flow with base tables
§ Session 13Procure to Pay flow with base tables
Part4 Reports (Oracle 10g Reports/XML publisher reports)
§ Session 14 Report development process, Report registration process
§ Session 15 Bind parameters, lexical parameters, reports with value set, Building report manually
§ Session 16 Using repeating frames, Summary columns , Standard report customization
Part5 Interfaces
§ Session 17 Introduction to Interfaces, working with Out Bound Interfaces, using UTL_FILE package
§ Session 18 Inbound Interface process, Working with SQL*Loader tool
§ Session 19 Different option in SQL *Loader tool, bad file, discard file
§ Session 20 Using Interface table approach
§ Session 21 Using API Approach
Part6 Conversions
§ Session 22 Introduction to conversions, Creation of staging table.
§ Session 23 developing the validation package, explaining the real time project code.
§ Session 24 Completing the conversion task, Differences between Inbound interfaces & Conversions
Part7 Forms
§ Session 25 Form registration process
§ Session 26 Form personalization with example.
§ Session 27Form personalization Using Custom.pll
Part 8XML Publisher
§ Session 28 Introduction to XML publisher, Report development process
§ Session 29 Creating reports for multiple rows, Creating Data definitions, Creating templates
Part 9 Flex fields
§ Session 31 what are Descriptive Flex field attributes and how they are activated.
§ Session 32 Making DFFs non Editable.
Part10Sample Demo Projects: Session 32-40
For training call at +91 9632266314
or mail at sekhar.byna@gmail.com
§ 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 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 Flex field 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 12Order to Cash Flow with base tables
§ Session 13Procure to Pay flow with base tables
Part4 Reports (Oracle 10g Reports/XML publisher reports)
§ Session 14 Report development process, Report registration process
§ Session 15 Bind parameters, lexical parameters, reports with value set, Building report manually
§ Session 16 Using repeating frames, Summary columns , Standard report customization
Part5 Interfaces
§ Session 17 Introduction to Interfaces, working with Out Bound Interfaces, using UTL_FILE package
§ Session 18 Inbound Interface process, Working with SQL*Loader tool
§ Session 19 Different option in SQL *Loader tool, bad file, discard file
§ Session 20 Using Interface table approach
§ Session 21 Using API Approach
Part6 Conversions
§ Session 22 Introduction to conversions, Creation of staging table.
§ Session 23 developing the validation package, explaining the real time project code.
§ Session 24 Completing the conversion task, Differences between Inbound interfaces & Conversions
Part7 Forms
§ Session 25 Form registration process
§ Session 26 Form personalization with example.
§ Session 27Form personalization Using Custom.pll
Part 8XML Publisher
§ Session 28 Introduction to XML publisher, Report development process
§ Session 29 Creating reports for multiple rows, Creating Data definitions, Creating templates
Part 9 Flex fields
§ Session 31 what are Descriptive Flex field attributes and how they are activated.
§ Session 32 Making DFFs non Editable.
Part10Sample Demo Projects: Session 32-40