Training. Types of projects.
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
1)Invenoty--
Inventory Setup
Subinventory Setups
Item Setup
Move Orders
Sub Inventory Transfers
Min-Max planning
ABC Anlaysis
Highligts
Under lying table strucures ,Queries for the above Module.
Business Scenarios
2) Purchasing
Purchasing Item Setup
Buyer Setup
Approval HIeracrchy setup
Various type of POS
BPA(Blanket Purchase agreement setups)
Standard Purchase Order setups
Receiving
Highligts
Intefaces(Inbound)
Reports(New reports development and Customization)
Forms Personalization
3) Order Management
Order Types
Define Order Management Transaction Types
Define Order Import Sources
Defining Processing Constraints
Define Defaulting Rules
Define Automatic Holds
User Item Description
Setup for Related Items
Defining Pick Slip Grouping Rules
Defining Shipping Document Sets
Defining Release Rules
Defining Release Sequence Rules
Back to Back orders
Internal orders
Setting up gift items
Settting up discounts
Highlights
API
Outbound Interfaces
Underlying table strucure
Queries
XML Publisher reports
Application Object Library
Levels of Oracle Applications, Creating users, WHO columns, Creating responsibilities
Menu construction, Defining concurrent programs, assign concurrent program to request group
Concurrent program with parameters, Creating Value sets, incompatibilities
Scheduling concurrent program, Creating request group, Creating request set
Enabling Flex field DFF segments in Oracle apps.
Reports (Oracle 10g Reports/XML publisher 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
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 & Conversions, FNDLOAD
Form registration process
Form personalization with example.
Form personalization Using Custom.pll
XML Publisher
Introduction to XML publisher, Report development process Creating reports for multiple rows, Creating Data definitions, Creating templates
Flex fields
what are Descriptive Flex field attributes and how they are activated.
Making DFFs non Editable.