Oracle Fusion Middleware 11g: Build Applications with Oracle Forms Ed 1 -

Oracle Fusion Middleware 11g: Build Applications with Oracle Forms Ed 1

Duration : 5 Days (40 Hours)

Overview

Course Details

Prerequisites

Oracle Fusion Middleware 11g: Build Applications with Oracle Forms Ed 1 Course Overview:

In this course, students will learn to utilize Oracle Forms Builder 11g to rapidly develop scalable and high-performance web applications. The course guides students through building a sample Forms application for an order entry system, utilizing various GUI controls. Students will enhance the appearance and functionality of the form using PL/SQL triggers, JavaBeans, and Pluggable Java Components. They will also learn to customize transaction processing using WebUtil and pass values between forms. Emphasis is placed on designing objects and code for reuse, enabling students to create efficient and maintainable applications. Additionally, students will learn to validate user input, control navigation, and display meaningful messages to enhance the user experience. By the end of the course, participants will have the skills to design and develop powerful Oracle Forms applications for the Web.

Intended Audience:

Application Developers: Professionals responsible for designing and building applications using Oracle Forms.
Technical Consultants: Individuals providing expertise and guidance on Oracle Forms application development.
Software Engineers: Developers involved in creating and customizing applications using Oracle Forms.
Database Administrators: Professionals interested in integrating Oracle Forms with their database applications.
System Analysts: Individuals involved in analyzing business requirements and designing solutions using Oracle Forms.
IT Managers: Decision-makers overseeing application development projects and seeking to leverage Oracle Forms for their organization’s needs.

Learning Objectives of Oracle Fusion Middleware 11g: Build Applications with Oracle Forms Ed 1:

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.

Module 1: Running a Forms Application

Running a Form
Identifying the Data Elements
Navigating a Forms Application
Using the Modes of Operation
Querying Data
Inserting, Updating, and Deleting Records
Saving Changes
Displaying Errors

Module 2: Working in the Forms Builder Environment

Forms Builder Key Features
Forms Builder Components
Forms Builder Components
Forms Builder Module Object Hierarchy
Customizing Your Forms Builder Session
Forms Executables and Module Types
Defining Environment Variables
Testing a Form with the Run Form Button

Module 3: Creating a Basic Form Module

Creating a New Form Module
Creating a New Data Bock
Using Template Forms
Saving and Compiling a Form Module
Saving and Compiling a Form Module
Deploying a Form Module
Producing Documentation

Module 4: Creating a Master-Detail Form

Creating Data Blocks with Relationships
Running a Master-Detail Form Module
Modifying the Structure of a Data Block
Modifying the Structure of a Data Block

Module 5: Working Data Blocks and Frames

Managing Object Properties
Creating Visual Attributes
Controlling the Behavior and Appearance of Data Blocks
Controlling Frame Properties
Displaying Multiple Property Palettes
Setting Properties on Multiple Objects
Copying Properties
Creating Control Blocks

Module 6: Working with Text Items

Creating a Text Item
Modifying the Appearance of a Text Item
Controlling the Data of a Text Item
Altering the Navigational Behavior of a Text Item
Enhancing the Relationship between Text Item and Database
Adding Functionality to a Text Item
Displaying Helpful Messages

Module 7: Creating LOVs and Editors

LOVs and Record Groups
Creating an LOV Manually
Creating an LOV Manually
Creating an LOV Manually
LOV Column Mapping
Defining an Editor
Setting Editor Properties
Associating an Editor with a Text Item

Module 8: Creating Additional Input Items

Input Items Overview
Creating a Check Box
Creating a List Item
Creating a Radio Group

Module 9: Creating Noninput Items

Noninput Items Overview
Creating a Display Item
Creating an Image Item
Creating a Push Button
Creating a Calculated Item
Creating a Hierarchical Tree Item
Creating a Bean Area Item

Module 10: Creating Windows and Content Canvases

Displaying a Form Module in Multiple Windows
Creating a New Window
Displaying a Form Module on Multiple Layouts
Creating a New Content Canvas

Module 11: Working with Other Canvas Types

Overview of Canvas Types
Creating a Stacked Canvas
Creating a Toolbar
Creating a Tab Canvas

Module 12: Producing and Debugging Triggers

Trigger Overview
Creating Triggers in Forms Builde
Specifying Execution Hierarchy
PL/SQL Editor Features
Using the Database Trigger Editor
Using Variables in Triggers
Adding Functionality with Built-in Subprograms
Using the Forms Debugger

Module 13: Adding Functionality to Items

Coding Item Interaction Triggers
Interacting with Noninput Items

Module 14: Displaying Run-Time Messages and Alerts

Interacting with Noninput Items
Controlling System Messages
The FORM_TRIGGER_FAILURE Exception
Triggers for Intercepting System Messages
Creating and Controlling Alerts
Creating and Controlling Alerts

Module 15: Using Query Triggers

Query Processing Overview
SELECT Statements Issued During Query Processing
Setting WHERE and ORDER BY clauses and ONETIME_WHERE property
Writing Query Triggers
Query Array Processing
Coding Triggers for Enter-Query Mode
Overriding Default Query Processing
Obtaining Query Information at Run Time

Module 16: Validating User Input

Validation Process
Controlling Validation by Using Properties
ontrolling Validation by Using Triggers
Performing Client-Side Validation with PJCs
Tracking Validation Status
Using Built-ins to Control When Validation Occurs

Module 17: Validating User Input

Using Object Properties to Control Navigation
Writing Navigation Triggers
Avoiding the Navigation Trap
Using Navigation Built-Ins in Triggers

Module 18: Overriding or Supplementing Transaction Processing

Transaction Processing Overview
Using Commit Triggers
Testing the Results of Trigger DML
DML Statements Issued during Commit Processing
Overriding Default Transaction Processing
Getting and Setting the Commit Status
Implementing Array DML

Module 19: Writing Flexible Code

What is Flexible Code?
Using System Variables for Flexible Coding
Using Built-in Subprograms for Flexible Coding
Copying and Subclassing Objects and Code
Referencing Objects by Internal ID
Referencing Items Indirectly

Module 20: Sharing Objects and Code

Benefits of Reusable Objects and Code
Working with Property Classes
Working with Object Groups
Copying and Subclassing Objects and Code
Working with Object Libraries
Working with SmartClasses
Reusing PL/SQL
Working with PL/SQL Libraries

Module 21: Using WebUtil to Interact with the Client

Benefits of WebUtil
Integrating WebUtil into a Form
Interacting with the Client

Module 22: Introducing Multiple Form Applications

Multiple Form Applications Overview
Starting Another Form Module
Defining Multiple Form Functionality
Defining Multiple Form Functionality

Oracle Fusion Middleware 11g: Build Applications with Oracle Forms Ed 1 Course Prerequisites:

Experience with SQL and PL/SQL basics

Discover the perfect fit for your learning journey

Choose Learning Modality

Live Online

Convenience
Cost-effective
Self-paced learning
Scalability

Classroom

Interaction and collaboration
Networking opportunities
Real-time feedback
Personal attention

Onsite

Familiar environment
Confidentiality
Team building
Immediate application

Training Exclusives

This course comes with following benefits:

Practice Labs.
Get Trained by Certified Trainers.
Access to the recordings of your class sessions for 90 days.
Digital courseware
Experience 24*7 learner support.

Request Free Demo

Got more questions? We’re all ears and ready to assist!