Oracle Apps Technical

now browsing by category

 

Oracle Apps R12 Technical Online Training (One to One)

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

Duration : 25 Sessions

Each Session Duration : 1 HR

Oracle Apps Technical Online Training 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 Views.

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

Introduction to Work Flow

• Workflow Introduction
• Workflow development process
• Running the workflow
• Sending notifications
• Branching the workflow using result out variable

FAQS In Oracle Apps Technical

Oracle D2K | Oracle Forms and Reports 10g Online Training Details

Oracle D2K | Oracle Forms and Reports 10g Online Training Details (One to One Online Training)

Duration : 12 Sessions

D2K Course Content

Forms 10g

. Introduction and Role in Oracle APPS
. Fundamentals of D2K

Types of Blocks

. Creation of blocks Through wizard and Manually
. Creation of Master-Detail Data Blocks

Canvases

. Creation of Different Types of Canvases and Working with Canvases

Windows

. Types of windows and working with windows and changing windows properties

Triggers in Forms

. Different types of Triggers
. Working with Triggers and Applying to Different Controls

Alerts

. Creation of alerts and Calling of Alerts Changing Properties at runtime and Re-using Alerts

Editors

Creation of Editors, Types of Editors and Calling editors through Code

Creation of Object Groups

. Creating and Using Object Groups
. Creating and Using Object Libraries

Using Image Items

. Storing and Retrieving Images
. Working With Image Items

Record Groups

. Creation of Record Groups Based On Query and Using Static Values

Lovs

. Creation of Lov through wizard and Manually
. Working with Lov Properties

Menus

. Creation of Menus, popup Menus and attaching menus to Forms

Program Units

. Working with Procedures, Functions and Packages in Forms

PL/SQL Libraries

. Usage of PL/SQL Libraries in Forms and Attached Libraries
. Using Database Objects and Creating Database objects through forms.

Reports 10g

. Introduction
. Fundamentals of Reports
. Advantages, Features and role of Reports in D2K

Creation of Reports using Wizards

. Creation of Different types of Reports
. Creation of Reports Manually
. Creation of Reports with different Parameters
. User Parameters
. System Parameters
. Manual Reports
. Creation of Reports through Data Model SQL Query
. Working with Formula Columns
. Working with Summary Columns
. Working with Place Holder Columns
. Working with Data links
. Working with Cross Products
. Creating Report With Parameters

Reports in Triggers

. Before Parameter Form
. After Parameter Form
. Before Report
. Between Pages
. After Report

Creation of Templates

. Creation of Layout in Reports
. Drill Down Reports
. Calling Reports from Forms
. Calling Reports from Reports

FAQS in D2K

Oracle Apps R12 Technical Week End Online Training Details (One to One)

Oracle Apps R12 Technical Week end Online Training (One to One Online Training)

Oracle Apps Technical Week End Online Training Will be held on Every Saturday and Sunday

Duration : 16 Sessions

Each Session Duration : 1.5 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