Oracle Apps Functional Training Institute@SoftgeninfotechBTM

Oracle Apps Functional Training Institute@SoftgeninfotechBTM
hat is Oracle Apps Training?
oracle database is a collection of data treated as a unit. The purpose of a data base is to store and retrieve related information. A database server is the key to solve the problems of information management. In general, a server reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. Oracle database is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications. Enterprise grid computing creates large pools of industry –standard, modular storage and servers. The database has logical structures and physical structures.
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

Softgen Infotech

#766, 1st Floor, 16th Main,

BTM Layout,2nd Stage, Mico layout,

Near Udipi Garden. Above foodworld,

Bangalore - 560078.

Bus Stop: Udipi Garden.

Contact no: +91 98801 56789, 98802 56789