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

Duration : 5 Days (40 Hours)

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:

  1. Application Developers: Professionals responsible for designing and building applications using Oracle Forms.
  2. Technical Consultants: Individuals providing expertise and guidance on Oracle Forms application development.
  3. Software Engineers: Developers involved in creating and customizing applications using Oracle Forms.
  4. Database Administrators: Professionals interested in integrating Oracle Forms with their database applications.
  5. System Analysts: Individuals involved in analyzing business requirements and designing solutions using Oracle Forms.
  6. 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • 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
  • Input Items Overview
  • Creating a Check Box
  • Creating a List Item
  • Creating a Radio Group
  • 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
  • Displaying a Form Module in Multiple Windows
  • Creating a New Window
  • Displaying a Form Module on Multiple Layouts
  • Creating a New Content Canvas
  • Overview of Canvas Types
  • Creating a Stacked Canvas
  • Creating a Toolbar
  • Creating a Tab Canvas
  • 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
  • Coding Item Interaction Triggers
  • Interacting with Noninput Items
  • Interacting with Noninput Items
  • Controlling System Messages
  • Triggers for Intercepting System Messages
  • Creating and Controlling Alerts
  • Creating and Controlling Alerts
  • 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
  • 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
  • Using Object Properties to Control Navigation
  • Writing Navigation Triggers
  • Avoiding the Navigation Trap
  • Using Navigation Built-Ins in Triggers
  • 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
  • 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
  • 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
  • Benefits of WebUtil
  • Integrating WebUtil into a Form
  • Interacting with the Client
  • 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


  • Interaction and collaboration
  • Networking opportunities
  • Real-time feedback
  • Personal attention


  • 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.

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

Request More Details

Please enable JavaScript in your browser to complete this form.

Subscribe to our Newsletter

Please enable JavaScript in your browser to complete this form.