Oracle Apps Technical Online Training (One to One Personal Online Training)

1
Oracle Apps Technical Online Training (One to One
Personal Online Training)
Duration 25 Sessions, Fee 25,000 INR
For Course Fee, Demo and Time Slots, Contact at
training_at_oracleappstechnical.com
sridevikoduru_at_oracleappstechnical.com 91
9581017828 http//www.oracleappstechnical.com
ORACLE APPS Technical Course Content Introduction
to ERP
Definition of ERP Overview of popular ERPS
Comparison of Oracle Apps with other ERPS AIM
documentation standards Oracle Application
Architecture. Database structure of OA Using
TOAD
Types of Roles
Functional Consultant and Roles Technical
Consultant and Roles Techno-Functional
Consultant and Roles Oracle Application DBA and
Roles
Application Object Library
System Administration and Application Object
Library (AOL) Defining an Applications User and
Assigning the Responsibilities. Understanding
AOL and its Components WHO columns Creating
Responsibilities Request group creation Menu
Creation
Application development
Defining concurrent program Concurrent
programs with parameters Working with multiple
concurrent programs Concurrent Program
incompatibilities Creating Request Set
2
Default Types Value sets
Registration of Custom Objects
Report registration Registration of a Table
Using AD_DD Package to register Database
Component in AOL
Interfaces and Conversions
Introduction to Interfaces Difference Between
Interfaces and Conversions Outbound
Interfaces o Using UTL_FILE package Inbound
Interfaces o Using SQL Loader tool SQL
Loader Concepts o Data File. o Control File. o
Bad File. o Discard File. o Log File. Working
with staging table script Developing
validations package Standards to be followed in
conversions Using oracle APIs in Interfaces
and Conversions Interface Tables and Error
Tables
Flex Fields
Overview of flex fields Types of Flex
Fields o Descriptive Flex Fields o 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 APIs of profiles
3
Value sets
Overview of value sets Options in value
sets Types of value sets Creation of value
set Overview of value set tables Usage of
FLEX and PROFILE
Multi Org Concepts
What is Multi Org and why we need. Multi Org
Tables. Multi Org Viiews.
Functional Modules Overview
Overview of Procure to Pay Flow (P2P Cycle)
Overview of Order to Cash Flow (O2C Cycle)
Major setups and transactions Overview of
important tables in PO,INV,OM,AP,AP,GL
Reports in Oracle Applications
Introduction and Usage of USER_EXITS.
Developing a Report from scratch as per Client
Requirement. Developing a Report based on MD 50
Document. Customization of Oracle Standard
Reports. Reports Registration Steps in Oracle
Applications Standards to develop a report in
Oracle Apps
Forms in Oracle Applications
New Form Development Process Form
Registration in Oracle Applications. Calling
one Form to another Form by using Button
Master-Detailed Forms Form Personalization in
Oracle Applications Form Personalization v/s
Form Customization
Development of XML Reports
FAQS in Oracle Apps Technical
For Better Understanding about your Training
Sessions We have Furnished the Training Contents
as Session by Session
4
Session 1
Definition of ERP Introduction to Oracle
Applications Types of Data
Session 2
Functional Consultant and Roles Technical
Consultant and Roles DBA and Roles Types of
Projects
Session 3
Oracle Application Architecture Data Base
Structure of Oracle Applications Introduction
to Rice Components
Session 4
System Administration and Application Object
Library (AOL) Defining Application Users and
Assigning the Responsibilities. Creating
Responsibilities FND Tables and Understanding
AOL and its Components
Session 5
Registration of Tables Using AD_DD Package
Procedures to Register Database Tables in AOL
Module
Session 6
Report Registration Steps Register the Report
in AOL Module Executable Creation of Reports
Defining the Concurrent Program Creation of
Request Group
Session 7
Register the Parametric Report in AOL Module
Introduction to Report Parameters Types of
Parameters
5
Creating Value Sets Value Set Default Types
Session 8
Developing a Report from Scratch as per Client
requirement Default Report Styles
Customization of Oracle Standard Reports
Session 9
Introduction to Forms Form registration in
Oracle Applications
Session 10
Creating Functions in AOL Module Creation of
New Menu Oracle Application Default Menus
Session 11
Introduction to Template.FMB Appstand.FMB
Introduction to Pre Defined Objects in
Template.FMB
Session 12
Creating of New Template Creating of New
Block, Canvas in Template Registration Steps
for Template
Session 13
Overview of Flex Fields Types of Flex
Fields Introduction to Key and Descriptive Flex
Fields
Session 14
Steps for Creation of DFF Flex Field Tables
and Relations
6
Session 15
Overview of Profiles Options Different Levels
in Setting Profiles Some Important Profile
Options Steps in Setting Profile Options
Session 16
Multiple Organization Concepts Introduction
to Multi Org What is Multi Org and Why we need
it Defining Multi Org Structure
Session 17
Multi Org Tables Overview of Procure to Pay
(P2P Cycle) Overview of Order to Cash (O2C
Cycle) Overview of Important Tables in PO,
Inventory, OM, AP, AR, GL
Session 18
Introduction to Interfaces Difference between
Interfaces and Conversions Types of
Interfaces Inbound Interfaces Using SQL
Loader
Session 19
Working with Staging Table Scripts Developing
Validations Package Interface Tables and Error
Tables
Session 20
Introduction to Conversions Conversion Flow
Session 21
Introduction to AIM Documentation Preparation
of AIM Documents
7
Session 22
Introduction to Business Documents
Preparation of MD 50 Documents, MD 70 Documents
etc.
Session 23
Functional Flows of GL, AP, AR Back End Tables
Session 24
Introduction of XML Reports Developing XML
Reports
Session 25
Steps for Registering the XML Reports in AOL
Module Back End Tables
FAQS in Oracle Apps Technical
About Training
I am Sridevi Koduru, Senior Oracle Apps Trainer
at Oracleappstechnical.com
With 8 Yrs Exp on Oracle
Apps and 13 Yrs IT Exp Providing Online Training
on Oracle Apps Technical, Oracle Apps
Financial Functional, Oracle Apps SCM, Oracle
Apps HRMS, Oracle Financial for Indian
Localization, SQL, PL/SQL and D2K. I have
Provided Training for 500 Professionals Most of
them are Working in Real Time now.
Contact for (One to One Personal Online Training)
on Oracle Apps Technical, Oracle Apps
Financial Functional, Oracle Financial for Indian
Localization, Oracle Apps SCM, Oracle Apps HRMS,
SQL, PL/SQL and D2K at training_at_oracleappstechnica
l.com sridevikoduru_at_oracleappstechnical.com
91 9581017828 http//www.oracleappstechnical.
com
LinkedIn profile - http//in.linkedin.com/pub/srid
evi-koduru/8b/76a/9b8/