Oracle
Apps Technical Week End Training (One to One Personal Online Training)
Week
End Online Training Will be held on Every Saturday and Sunday
Duration
: 13 Sessions
Each
Session Duration : 2 Hr
For Course Fee, Demo and Time Slots,
Contact at training@oracleappstechnical.com | sridevikoduru@oracleappstechnical.com | +91 – 9581017828 | http://www.oracleappstechnical.com
ORACLE
APPS Technical Course Content
Introduction
to ERP
• Definition of ERP
• Overview of popular ERP’S
• Comparison of Oracle Apps with other ERP’S
• AIM documentation standards
• Oracle Application Architecture.
• Database structure of OA
• Using TOAD
• Overview of popular ERP’S
• Comparison of Oracle Apps with other ERP’S
• 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
• 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
• 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
• Default Types
• Value sets
• Concurrent programs with parameters
• Working with multiple concurrent programs
• Concurrent Program incompatibilities
• Creating Request Set
• Default Types
• Value sets
Registration
of Custom Objects
• Report registration
• Registration of a Table
• Using AD_DD Package to register Database Component in AOL
• 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 API’s in Interfaces and Conversions
• Interface Tables and Error Tables
• 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 API’s 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
• 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 API’s of profiles
• 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
• Usage of $FLEX and $PROFILE
• 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.
• 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
• 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
• 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
• 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
FAQ’S
in Oracle Apps Technical
For
Better Understanding of Your Training Sessions We have Furnished the Training
Contents as Session by Session
Session
1
• Definition of ERP
• Introduction to Oracle Applications
• Types of Data
• Functional Consultant and Roles
• Technical Consultant and Roles
• DBA and Roles
• Types of Projects
• Introduction to Oracle Applications
• Types of Data
• Functional Consultant and Roles
• Technical Consultant and Roles
• DBA and Roles
• Types of Projects
Session
2
• Oracle Application Architecture
• Data Base Structure of Oracle Applications
• Introduction to Rice Components
• System Administration and Application Object Library (AOL)
• Defining Application Users and Assigning the Responsibilities.
• Creating Responsibilities
• FND Tables and Understanding AOL and its Components
• Data Base Structure of Oracle Applications
• Introduction to Rice Components
• 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
3
• Registration of Tables
• Using AD_DD Package
• Procedures to Register Database Tables in AOL Module
• Report Registration Steps
• Register the Report in AOL Module
• Executable Creation of Reports
• Defining the Concurrent Program
• Creation of Request Group
• Using AD_DD Package
• Procedures to Register Database Tables in AOL Module
• Report Registration Steps
• Register the Report in AOL Module
• Executable Creation of Reports
• Defining the Concurrent Program
• Creation of Request Group
Session
4
• Register the Parametric Report in
AOL Module
• Introduction to Report Parameters
• Types of Parameters
• Creating Value Sets
• Value Set Default Types
• Developing a Report from Scratch as per Client requirement
• Default Report Styles
• Customization of Oracle Standard Reports
• Introduction to Report Parameters
• Types of Parameters
• Creating Value Sets
• Value Set Default Types
• Developing a Report from Scratch as per Client requirement
• Default Report Styles
• Customization of Oracle Standard Reports
Session
5
• Introduction to Forms
• Form registration in Oracle Applications
• Creating Functions in AOL Module
• Creation of New Menu
• Oracle Application Default Menus
• Form registration in Oracle Applications
• Creating Functions in AOL Module
• Creation of New Menu
• Oracle Application Default Menus
Session
6
• Introduction to Template.FMB
• Appstand.FMB
• Introduction to Pre Defined Objects in Template.FMB
• Creating of New Template
• Creating of New Block, Canvas in Template
• Registration Steps for Template
• Appstand.FMB
• Introduction to Pre Defined Objects in Template.FMB
• Creating of New Template
• Creating of New Block, Canvas in Template
• Registration Steps for Template
Session
7
• Overview of Flex Fields
• Types of Flex Fields
• Introduction to Key and Descriptive Flex Fields
• Steps for Creation of DFF
• Flex Field Tables and Relations
• Types of Flex Fields
• Introduction to Key and Descriptive Flex Fields
• Steps for Creation of DFF
• Flex Field Tables and Relations
Session
8
• Overview of Profiles Options
• Different Levels in Setting Profiles
• Some Important Profile Options
• Steps in Setting Profile Options
• Multiple Organization Concepts
• Introduction to Multi Org
• What is Multi Org and Why we need it
• Defining Multi Org Structure
• Different Levels in Setting Profiles
• Some Important Profile Options
• Steps in Setting Profile Options
• Multiple Organization Concepts
• Introduction to Multi Org
• What is Multi Org and Why we need it
• Defining Multi Org Structure
Session
9
• 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
• Introduction to Interfaces
• Difference between Interfaces and Conversions
• Types of Interfaces
• Inbound Interfaces
• Using SQL * Loader
• 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
• Introduction to Interfaces
• Difference between Interfaces and Conversions
• Types of Interfaces
• Inbound Interfaces
• Using SQL * Loader
Session
10
• Working with Staging Table Scripts
• Developing Validations Package
• Interface Tables and Error Tables
• Introduction to Conversions
• Conversion Flow
• Developing Validations Package
• Interface Tables and Error Tables
• Introduction to Conversions
• Conversion Flow
Session
11
• Introduction to AIM Documentation
• Preparation of AIM Documents
• Introduction to Business Documents
• Preparation of MD 50 Documents, MD 70 Documents etc.
• Preparation of AIM Documents
• Introduction to Business Documents
• Preparation of MD 50 Documents, MD 70 Documents etc.
Session
12
• Functional Flows of GL, AP, AR
• Back End Tables
• Introduction of XML Reports
• Developing XML Reports
• Back End Tables
• Introduction of XML Reports
• Developing XML Reports
Session
13
• Steps for Registering the XML
Reports in AOL Module
• Back End Tables
• Back End Tables
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@oracleappstechnical.com | sridevikoduru@oracleappstechnical.com
| +91 – 9581017828 | http://www.oracleappstechnical.com
LinkedIn profile -
http://in.linkedin.com/pub/sridevi-koduru/8b/76a/9b8/
No comments:
Post a Comment