ORACLE APPS TECHNICAL TRAINING IN BANGALORE

 Introduction to ERP
 Definition of ERP, Overview of popular ERP'S
 Comparison of Oracle Apps with other ERP'S
 Types of Roles
 Types of Projects
 AIM documentation standards
 Oracle Application Architecture.
 Database structure of OA
 Using TOAD

 Application Object Library
 Creating Users
 WHO columns
 Creating Responsibilities
 Request group construction

 Application development
 Defining concurrent program
 Concurrent programs with parameters
 Working with multiple concurrent programs
 Scheduling the Concurrent Program
 Concurrent Program incompatibilities
 Creating Request Set
 Procedure registration
 Value sets
 Value sets
 Overview of value sets
 Options in value sets
 Types of value sets
 Creation of value set
 Overview of value set tables
 Registration of Custom Objects
 Registration of Application
 Report development
 Report registration
 Parametric report registration
 Registration of a Table
 Registration of Sql, Sql Loader, PL/SQL programs
 Report Development:
 Customization of Reports – Adding DFF Info
 Customization of Reports – Removing Parameters
 Flexfields Report with Single Structure
 Report Coding Standards
 User Exits in Report design
 Customization of Reports – Adding Parameters
 Customization of Reports – Adding Logos
 Discoverer Administration Edition:
 Creating a end user layer
 database user
 Connecting to discoverer administrator, using the load
 wizard and the work area
 Modifying the Business Area
 Working with Custom Folders
 Creating Joins
 Customizing Items
 Designing a complex Folder
 Discoverer User Edition:
 Creation of Simple Workbook
 To design parameterized workbook
 To change Heading items
 To insert new sheet in the Workbook
 To add and remove items from Workbook
 To create duplicate sheet in Workbook
 To add title to the Worksheet
 To insert date, time, page numbers and image on
 Header/Title of Workbook
 To apply Conditional Formatting

 Interfaces
 Introduction to Interfaces
 Outbound Interfaces
 Using UTL_FILE package
 Inbound Interfaces
 Using SQL * Loader tool / dynamic table for files read( New concept)
 SQL * Loader Concepts
 Data File.
 Control File.
 Bad File.
 Discard File.
 Log File.
 Commands in Sql * Loader
 Registration Of control File in Oracle Apps.

 Conversions
 Overview on conversions
 Difference between Interfaces and conversions
 Working with staging table script
 Developing validations package
 Standards to be followed in conversions

 Flex Fields
 Overview of flex fields
 Types of Flex Fields
 Descriptive Flex Fields
 Key Flex Fields
 Step in creation of DFF
 Flex fields tables and relations

 Profiles
 Overview of profile options
 Different levels in Setting profiles
 Steps in setting a profile option
 Some important profile options
 Some important API’s of profiles

 Multi Org Concepts
 What is Multi Org and why we need.
 Multi Org Tables.
 Multi Org Views.

 PO Overview and tables
 Overview of purchasing
 Major setups and transactions
 Overview of some purchasing tables

 INV Overview and Tables
 Overview of inventory
 Major setups and transactions
 Overview of some INV Tables

 OM Overview and Tables
 Overview of order management
 Major setups and transactions
 Overview of some Order Management Tables

 GL Overview and Tables
 Overview of GL
 Major setups and transactions
 Overview of some GL tables

 AP Overview and tables
 Overview of payables
 Major setups and transactions
 Overview of some payable tables

 Alerts
 Overview on alerts
 Types of alerts
 Creation of alerts

 Workflows
 Introduction to workflow
 Workflow builder
 Attributes
 Creating Processes

 XML Publisher
 Introduction to XML Publisher
 Generating XML file using reports
 Creating Templates
 Creating Data Definitions

call me @9738001024