Oracle Fusion Middleware 11g- Build Applications with Oracle Forms

Duration

5 days

Overview

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.

This course is also suitable for customers using Forms 12c.

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.

Learn To:

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.

Benefits to You

When you walk away from this course, you will know how to build a sample Forms application for an

order entry system using a variety of GUI controls. You'll have the knowledge and skills to enhance

the appearance and functionality of the basic form by using PL/SQL trigger, JavaBeans, and

Pluggable Java Components.

Please Note:

Emphasis is placed on designing objects and code for reuse.

Prerequisites

Suggested Prerequisite

Experience with SQL and PL/SQL basics

Experience in advanced SQL & PL/SQL

Audience

Application Developers

Forms Developer

Developer

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

The FORM_TRIGGER_FAILURE Exception

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

Programme scope, delivery arrangements and suitability are confirmed during enquiry.