Description
Oracle Apps Technical Training Details (Offline and Online)
Duration : 25 Days
For Course Fee, Demo and Time Slots, Mail to [email protected] or Call Me On +91-9581017828
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
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
• 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 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
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
• 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
• Reports with Barcode
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
Alerts
• Overview on alerts
• Types of alerts
• Creation of alerts
FAQ’s in Oracle Apps
Oracle Apps Technical Training Details (Offline and Online)
Duration : 1 Month
For Course Fee, Demo and Time Slots, Mail to [email protected] or Call Me On
+91-9!1"1#!$! % &ttp'(())).oracleappstec&nical.com
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
• Data!ase structure of OA
• "sin# $OAD
Types of Roles
• %unctional Consultant and Roles
• $echnical Consultant and Roles
• $echno&%unctional Consultant and Roles
• Oracle Application D'A and Roles
Application Object Library
• S(stem Administration and Application O!)ect *i!rar( +AO*,
• Definin# an Applications "ser and Assi#nin# the Responsi!ilities
• "nderstandin# AO* and its Components
• -.O columns
• Creatin# Responsi!ilities
• Re/uest #roup creation
• Menu Creation
Application development
• Definin# concurrent pro#ram
• Concurrent pro#rams with parameters
• -or0in# with multiple concurrent pro#rams
• Schedulin# the Concurrent Pro#ram
• Concurrent Pro#ram incompati!ilities
• Creatin# Re/uest Set
• Default $(pes
• 1alue sets
• Messa#es
• *oo0ups
Registration of Custom Objects
• Report re#istration
• Re#istration of a $a!le
• "sin# AD2DD Pac0a#e to re#ister Data!ase Component in AO*
Interfaces and Conversions
• Introduction to Interfaces
• Difference 'etween Interfaces and Conversions
• Out!ound Interfaces
o "sin# "$*2%I*E pac0a#e
• In!ound Interfaces
o "sin# S3* 4 *oader tool
• S3* 4 *oader Concepts o Data %ile
o Control %ile
o 'ad %ile
o Discard %ile
o *o# %ile
o Commands in S/l 4 *oader
o Re#istration Of control %ile in Oracle Apps
• -or0in# with sta#in# ta!le script
• Developin# validations pac0a#e
• Standards to !e followed in conversions
• "sin# oracle API’s in Interfaces and Conversions
• Interface $a!les and Error $a!les
Fle Fields
• Overview of fle5 fields
• $(pes of %le5 %ields
o Descriptive %le5 %ields
o 6e( %le5 %ields
• Step in creation of D%%
• %le5 fields ta!les and relations
Profiles
• Overview of profile options
• Different levels in Settin# profiles
• Steps in settin# a profile option
• Some important profile options
• Some important API’s of profiles
!alue sets
• Overview of value sets
• Options in value sets
• $(pes of value sets
• Creation of value set
• Overview of value set ta!les
• "sa#e of 7%*E8 and 7PRO%I*E
"ulti Org Concepts
• -hat is Multi Or# and wh( we need
• Multi Or# $a!les
• Multi Or# 1iiews
Functional "odules Overvie#
• Overview of Procure to Pa( %low +P9P C(cle,
• Overview of Order to Cash %low +O9C C(cle,
• Ma)or setups and transactions
• Overview of important ta!les in PO:I;1:OM:AP:AP:<*
Reports in Oracle Applications
• Introduction and "sa#e of "SER2E8I$S
• Developin# a Report from scratch as per Client Re/uirement
• Developin# a Report !ased on MD => Document
• Customi?ation of Oracle Standard Reports
• Reports Re#istration Steps in Oracle Applications
• Standards to develop a report in Oracle Apps
• Multi&*an#ua#e Report Development
• Reports with 'arcode
Forms in Oracle Applications
• ;ew %orm Development Process
• %orm Re#istration in Oracle Applications
• Callin# one %orm to another %orm !( usin# 'utton
• Master&Detailed %orms
• %orm Personali?ation in Oracle Applications
• %orm Personali?ation v@s %orm Customi?ation
Alerts
• Overview on alerts
• $(pes of alerts
• Creation of alerts
FA$%s in Oracle Apps Tec&nical
doc_563008439.docx
Oracle Apps Technical Training Details (Offline and Online)
Duration : 25 Days
For Course Fee, Demo and Time Slots, Mail to [email protected] or Call Me On +91-9581017828
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
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
• 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 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
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
• 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
• Reports with Barcode
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
Alerts
• Overview on alerts
• Types of alerts
• Creation of alerts
FAQ’s in Oracle Apps
Oracle Apps Technical Training Details (Offline and Online)
Duration : 1 Month
For Course Fee, Demo and Time Slots, Mail to [email protected] or Call Me On
+91-9!1"1#!$! % &ttp'(())).oracleappstec&nical.com
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
• Data!ase structure of OA
• "sin# $OAD
Types of Roles
• %unctional Consultant and Roles
• $echnical Consultant and Roles
• $echno&%unctional Consultant and Roles
• Oracle Application D'A and Roles
Application Object Library
• S(stem Administration and Application O!)ect *i!rar( +AO*,
• Definin# an Applications "ser and Assi#nin# the Responsi!ilities
• "nderstandin# AO* and its Components
• -.O columns
• Creatin# Responsi!ilities
• Re/uest #roup creation
• Menu Creation
Application development
• Definin# concurrent pro#ram
• Concurrent pro#rams with parameters
• -or0in# with multiple concurrent pro#rams
• Schedulin# the Concurrent Pro#ram
• Concurrent Pro#ram incompati!ilities
• Creatin# Re/uest Set
• Default $(pes
• 1alue sets
• Messa#es
• *oo0ups
Registration of Custom Objects
• Report re#istration
• Re#istration of a $a!le
• "sin# AD2DD Pac0a#e to re#ister Data!ase Component in AO*
Interfaces and Conversions
• Introduction to Interfaces
• Difference 'etween Interfaces and Conversions
• Out!ound Interfaces
o "sin# "$*2%I*E pac0a#e
• In!ound Interfaces
o "sin# S3* 4 *oader tool
• S3* 4 *oader Concepts o Data %ile
o Control %ile
o 'ad %ile
o Discard %ile
o *o# %ile
o Commands in S/l 4 *oader
o Re#istration Of control %ile in Oracle Apps
• -or0in# with sta#in# ta!le script
• Developin# validations pac0a#e
• Standards to !e followed in conversions
• "sin# oracle API’s in Interfaces and Conversions
• Interface $a!les and Error $a!les
Fle Fields
• Overview of fle5 fields
• $(pes of %le5 %ields
o Descriptive %le5 %ields
o 6e( %le5 %ields
• Step in creation of D%%
• %le5 fields ta!les and relations
Profiles
• Overview of profile options
• Different levels in Settin# profiles
• Steps in settin# a profile option
• Some important profile options
• Some important API’s of profiles
!alue sets
• Overview of value sets
• Options in value sets
• $(pes of value sets
• Creation of value set
• Overview of value set ta!les
• "sa#e of 7%*E8 and 7PRO%I*E
"ulti Org Concepts
• -hat is Multi Or# and wh( we need
• Multi Or# $a!les
• Multi Or# 1iiews
Functional "odules Overvie#
• Overview of Procure to Pa( %low +P9P C(cle,
• Overview of Order to Cash %low +O9C C(cle,
• Ma)or setups and transactions
• Overview of important ta!les in PO:I;1:OM:AP:AP:<*
Reports in Oracle Applications
• Introduction and "sa#e of "SER2E8I$S
• Developin# a Report from scratch as per Client Re/uirement
• Developin# a Report !ased on MD => Document
• Customi?ation of Oracle Standard Reports
• Reports Re#istration Steps in Oracle Applications
• Standards to develop a report in Oracle Apps
• Multi&*an#ua#e Report Development
• Reports with 'arcode
Forms in Oracle Applications
• ;ew %orm Development Process
• %orm Re#istration in Oracle Applications
• Callin# one %orm to another %orm !( usin# 'utton
• Master&Detailed %orms
• %orm Personali?ation in Oracle Applications
• %orm Personali?ation v@s %orm Customi?ation
Alerts
• Overview on alerts
• $(pes of alerts
• Creation of alerts
FA$%s in Oracle Apps Tec&nical
doc_563008439.docx