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

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

This course teaches students how to use Oracle Forms Builder 11g to rapidly build scalable, high-performance applications for the Web.

Students build a sample Forms application for an order entry system, using a variety of GUI controls. They learn to enhance the appearance and functionality of the basic form by using PL/SQL trigger, JavaBeans, and Pluggable Java Components.

Students learn to replace or supplement default transaction processing. They use WebUtil to interact with the client machine, and also learn to pass values from one form to another. They learn how to validate user input, control navigation, and display meaningful messages to users.

Emphasis is placed on designing objects and code for reuse.

This course prepares you for Exam 1Z0-151.

Oracle Fusion Middleware 11g: Build Applications with Oracle Forms Ed 1 (40 Hours) Download Course Contents

Live Virtual Classroom
Group Training 3150
02 - 06 Aug 09:00 AM - 05:00 PM CST
(8 Hours/Day)

06 - 10 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 3650
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Course Modules

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
Download Course Contents

Request More Information

Course Prerequisites
  • Experience with SQL and PL/SQL basics

Upon Completion of this Course, you will accomplish following:-

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

Give an edge to your career with Oracle certifications and training courses. Students can join the classes for Oracle Fusion Middleware 11g Build Applications with Oracle Forms at Koenig Campus located at New Delhi, Bengaluru, Shimla, Goa, Dehradun, Dubai & Instructor-Led Online.