D2K | DEVELOPER 2000 | ORACLE FORMS AND REPORTS TRAINING ONLINE

D2K | DEVELOPER 2000 | ORACLE FORMS AND REPORTS TRAINING ONLINE

 

Schedule/Purchase	Training Formats	Price	Duration	Course Materials	Language
	Live Virtual Class	12000 INR	Full Week	English	English

 

 

• What You Will Learn
• Audience
• Course Topics
• Course Objectives

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

Opraprofiles links:-

Facebook

Twitter

LinkedIn

Google+

Youtube

Pinterest

ORACLE APPS TECHNICAL WEEK END ONLINE TRAINING (ONE TO ONE ONLINE TRAINING)

Schedule/Purchase	Training Formats	Price	Duration	Course Materials	Language
	Live Virtual Class	25000 INR	Week Ends	English	English

• What You Will Learn
• Audience
• Course Topics
• Course Objectives
• Related Training

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

Opraprofiles links:-

Facebook

Twitter

LinkedIn

Google+

Youtube

Pinterest