Oracle Apps Technical Online Training (One to one)

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

DURATION : 25 SESSIONS

EACH SESSION DURATION : 1 HR

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

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 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

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
• 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

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

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

Comments are Closed