Oracle Fusion Middleware Build Applications with Oracle Forms

5 days training event


Course Outlines - Download PDF

This Oracle Fusion Middleware 11g: Build Applications with Oracle Forms training teaches you how to use Oracle Forms Builder 11g. Learn how to rapidly build scalable, high-performance applications for the Web.

Learn To

This Oracle Fusion Middleware 11g: Build Applications with Oracle Forms training explores building Oracle Forms Builder 11g. Expert instructors will teach you how to create high-performance applications for the Web that are also scalable.

  • Use Oracle Forms Builder 11g.

  • Enhance applications with various GUI controls.

  • Add functionality to applications by writing triggers.

  • Use the Forms Debugger to troubleshoot applications.

  • Validate user input and display meaningful error messages.

  • Use WebUtil to interact with client computers.

  • Validate user input, control navigation and display meaningful messages to users.

  • Use WebUtil to interact with the client machine and pass values from one form to another.

  • Replace or supplement default transaction processing.


  • Application Developers

  • Forms Developer

  • Forms Developer

  • Developer

  • Support Engineer

  • Support Engineer

  • Technical Consultant

  • PL/SQL Developer

Course Objectives

  • Link one form module to another

  • Create form modules, including components for database interaction and GUI controls

  • Display form modules in multiple windows and use a variety of layout styles

  • Test form modules in a Web browser

  • Debug form modules in a 3-tier environment

  • Implement triggers to enhance form functionality

  • Reuse objects and code

Course Topics

Running a Forms Application

  • Using the Modes of Operation

  • Identifying the Data Elements

  • Querying Data

  • Navigating a Forms Application

  • Displaying Errors

  • Inserting, Updating, and Deleting Records

  • Running a Form

  • Saving Changes

Working in the Forms Builder Environment

  • Defining Environment Variables

  • Customizing Your Forms Builder Session

  • Forms Builder Module Object Hierarchy

  • Forms Builder Components

  • Forms Builder Key Features

  • Forms Executables and Module Types

  • Navigating the Forms Builder Interface

  • Testing a Form with the Run Form Button

Creating a Basic Form Module

  • Using Template Forms

  • Saving and Compiling a Form Module

  • Deploying a Form Module

  • Creating a New Form Module

  • Producing Documentation

  • Module Types and Storage Formats

  • Creating a New Data Bock

Creating a Master-Detail Form

  • Creating Data Blocks with Relationships

  • Modifying the Structure of a Data Block

  • Modifying the Layout of a Data Block

  • Running a Master-Detail Form Module

Working Data Blocks and Frames

  • Controlling Frame Properties

  • Displaying Multiple Property Palettes

  • Setting Properties on Multiple Objects

  • Managing Object Properties

  • Controlling the Behavior and Appearance of Data Blocks

  • Copying Properties

  • Creating Control Blocks

  • Creating Visual Attributes

Working with Text Items

  • Altering the Navigational Behavior of a Text Item

  • Modifying the Appearance of a Text Item

  • Displaying Helpful Messages

  • Enhancing the Relationship between Text Item and Database

  • Adding Functionality to a Text Item

  • Creating a Text Item

  • Controlling the Data of a Text Item

Creating LOVs and Editors

  • Defining an Editor

  • Creating an LOV Manually

  • LOV Column Mapping

  • Setting LOV Properties

  • Setting Editor Properties

  • Associating an Editor with a Text Item

  • Using the LOV Wizard to Create an LOV

  • LOVs and Record Groups

Creating Additional Input Items

  • Creating a Radio Group

  • Input Items Overview

  • Creating a Check Box

  • Creating a List Item

Creating Noninput Items

  • Creating a Display Item

  • Creating a Calculated Item

  • Creating a Bean Area Item

  • Creating a Push Button

  • Creating an Image Item

  • Noninput Items Overview

  • Creating a Hierarchical Tree Item

Creating Windows and Content Canvases

  • Displaying a Form Module on Multiple Layouts

  • Creating a New Window

  • Creating a New Content Canvas

  • Displaying a Form Module in Multiple Windows

Working with Other Canvas Types

  • Creating a Stacked Canvas

  • Creating a Toolbar

  • Overview of Canvas Types

  • Creating a Tab Canvas

Producing and Debugging Triggers

  • Using Variables in Triggers

  • Using the Database Trigger Editor

  • Using the Forms Debugger

  • Trigger Overview

  • Creating Triggers in Forms Builde

  • Adding Functionality with Built-in Subprograms

  • Specifying Execution Hierarchy

  • PL/SQL Editor Features

Adding Functionality to Items

  • Interacting with Noninput Items

  • Coding Item Interaction Triggers

Displaying Run-Time Messages and Alerts

  • Triggers for Intercepting System Messages

  • Built-Ins and Handling Errors

  • Controlling System Messages

  • Handling Server Errors

  • Creating and Controlling Alerts


Using Query Triggers

  • Overriding Default Query Processing

  • Coding Triggers for Enter-Query Mode

  • Setting WHERE and ORDER BY clauses and ONETIME_WHERE property

  • Query Processing Overview

  • SELECT Statements Issued During Query Processing

  • Obtaining Query Information at Run Time

  • Query Array Processing

  • Writing Query Triggers

Validating User Input

  • Controlling Validation by Using Triggers

  • Using Built-ins to Control When Validation Occurs

  • Tracking Validation Status

  • Performing Client-Side Validation with PJCs

  • Controlling Validation by Using Properties

  • Validation Process

Controlling Navigation

  • Using Navigation Built-Ins in Triggers

  • Using Object Properties to Control Navigation

  • Avoiding the Navigation Trap

  • Writing Navigation Triggers

Overriding or Supplementing Transaction Processing

  • Transaction Processing Overview

  • Using Commit Triggers

  • Implementing Array DML

  • DML Statements Issued during Commit Processing

  • Overriding Default Transaction Processing

  • Testing the Results of Trigger DML

  • Getting and Setting the Commit Status

Writing Flexible Code

  • Copying and Subclassing Objects and Code

  • Referencing Items Indirectly

  • Using Built-in Subprograms for Flexible Coding

  • Using System Variables for Flexible Coding

  • What is Flexible Code?

  • Referencing Objects by Internal ID

Sharing Objects and Code

  • Working with Object Groups

  • Working with PL/SQL Libraries

  • Benefits of Reusable Objects and Code

  • Copying and Subclassing Objects and Code

  • Working with SmartClasses

  • Working with Object Libraries

  • Reusing PL/SQL

  • Working with Property Classes

Using WebUtil to Interact with the Client

  • Benefits of WebUtil

  • Integrating WebUtil into a Form

  • Interacting with the Client

Introducing Multiple Form Applications

  • Defining Multiple Form Functionality

  • Sharing Data among Modules

  • Multiple Form Applications Overview

  • Starting Another Form Module


أماكن ومقرات التدريب حول العالم



Kuala Lumpur

Kuala Lumpur






Sunny resort beach with palm tree at the coast shore of Red Sea in Sharm el Sheikh, Sinai, Egypt, Asia in summer hot. Bright sunny light

Sharm El Sheikh