Real Time Experts
4.9 out of 5 based on 337 Reviews
Best Oracle Apps Technical Course in Bangalore & Top Oracle
Apps Technical Training Institute
Best Oracle Apps Technical Course in Bangalore & Top Oracle
Apps Technical Training Institute
Oracle Application Technical Course Contents
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
Menu construction
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
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
Interfaces
Introduction to Interfaces
Outbound Interfaces
Using UTL_FILE package
Inbound Interfaces
Using SQL * Loader tool
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
Value
sets
Overview of value sets
Options in value sets
Types of value sets
Creation of value set
Overview of value set tables
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
Form
personalization
Forms personalization: need and benefits
Use validate feature to confirm conditions and strings
Form Personalization v/s Form Customization
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
FAQ’s in
Oracle Apps
Job Assistance