Course Contents
Day 1
Introduction
What is ERP ? , comparison of Oracle Apps with other ERPS
Types of Roles , Types of projects, AIM documents
Oracle Apps file structure, database structure and 3-tier architecture
Application Object Library
Levels of Oracle Applications, Creating users, WHO columns, Creating responsibilities
Menu construction, Defining concurrent program
Concurrent program with parameters, Creating Value sets, incompatibilities
Scheduling concurrent program, Creating request group, Creating request set
Concurrent program creation using API
Module Overviews
Inventory Module flow with base tables
Accounts Receivable module flow with base tables
Order Management module flow with base tables
Day 2
Reports
Report development process, Report registration process
Bind parameters, lexical parameters, reports with value set, Building report manually
Using repeating frames, Summary columns , Standard report customization
Interfaces
Introduction to Interfaces, working with Out Bound Interfaces, using UTL_FILE package
Inbound Interface process, Working with SQL*Loader tool
Different option in SQL *Loader tool, bad file, discard file
Using Interface table approach
Using API Approach
Day 3
Conversions
Introduction to conversions, Creation of staging table
Developing the validation package, Explaining the real time project code.
Completing the conversion task, Differences between Inbound interfaces and Conversions
Forms
Form development process using TEMPLATE.FMB , Form registration process
Form personalization
Using Custom.pll
Day 4
Workflows
Workflow Introduction, Workflow development process, running the workflow
Sending notifications, branching the workflow using resultout variable
XML Publisher
Introduction to XML publisher, Report development process
Creating reports for multiple rows, Creating Data definitions, Creating templates
Apps2Fusion Articles 