0845 450 6120

Oracle 11g Fusion Forms Development

This Oracle 11g Forms course explores Oracle's latest product version in depth, with fully integrated hands on workshops throughout the course, allowing students to build enterprise applications.

We don't currently have any courses listed for Oracle 11g Fusion Forms Development, would you like to view all courses for Oracle?

Learning Objectives

Although Oracle's 11g Fusion Middleware strategy has much focus on Oracle ADF Java based applications or Oracle Express (APEX, Oracle Application Express (O139)) they have also stated continued support, development and enhancement for their Developer Tools (Forms & Reports).

This course will teach attendees to fully harness existing functionality in addition to 11g Oracle Access Manager Integration, JEE application interoperability, application server services and continued use of Objects and their reuse.

The course is delivered as a mixture of instructor led discussion and practical hands-on labs to provide both background and hands on experience.  Delivered as a single company course, content can be tailored to your specific project objectives and attendee experience.

Course Content

Introduction

  • Forms Builder Overview
  • Invoking Forms Builder
  • Customizing the Forms Builder Session
  • Property Palettes

Getting Started

  • Building a basic Form
  • Forms Runtime Overview
  • Forms Object structure
  • Object Navigator
  • Block concepts
  • Block data sources
  • Data Block Wizard (using a stored procedure)
  • Layout/Chart/LOV wizard

Formatting a Form

  • Layout Editor
  • Formatting Tools
  • Visual Attributes
  • Working with Frames
  • Working with Canvases
  • Property Classes

Multiple Block Forms

  • Creating forms based on multiple blocks
  • Building Block Relationships
  • Relationship properties

Windows and Canvases

  • Stacked Canvases
  • Toolbar Canvases
  • Tab Canvases
  • Window Properties
  • Items
  • Check Boxes
  • Radio Groups
  • Primary Key Display Items
  • Foreign Key Display Items
  • Synchronized Display Items
  • Calculated Items
  • Summary Items
  • Retrieving Image Items
  • Storing Images in the database
  • Buttons
  • JavaBean area

Reports

  • Create Report Objects based on a block
  • Report Object Properties
  • Run Existing Reports using Run Product Building
  • Parameter Lists to Run Reports

  Data Lists

  • List Items
  • Simple LOV
  • Multiple column LOV
  • LOV Properties
  • Populating list items with Record Groups
  • Creating record groups programmatically

PL/SQL in Forms

  • Program Units
  • PL/SQL Libraries
  • Forms Triggers
  • Forms Built Ins
  • The Navigation Unit
  • Basing a Form on a stored procedure
  • Using Debug Alerts

Navigating through Form Applications

  • Forms Parameters
  • Global Variables
  • Call/Open/New/Go Form

Menus

  • Basic Menu Modules
  • Popup Menus

Control Objects & Interface

  • Items
  • Property Palette
  • Renamed Properties
  • New Properties
  • Prompt Orientation
  • Query All Records Block
  • Property
  • ToolTips Property
  • Calculated Fields
  • Formula/Summary Calculations
  • Tab Canvasses
  • Stacked canvas enhancements
  • Frames Visual Attribute Enhancements
  • Graphic Object Functionality
  • Sound items
  • Images

Forms Events & PL/SQL

  • Triggers
  • System Variables
  • Built-in Subprograms
  • Dynamic SQL
  • Default Keyword
  • Composite Data types
  • PL/SQL Records
  • PL/SQL Tables
  • Combining PL/SQL Records and Tables

Development Techniques

  • Smart Triggers
  • Commit Triggers
  • Object Sub-classing
  • Object Libraries
  • Smart Classes
  • Template Forms
  • Building Hierarchy Trees
  • PL/SQL Editor Enhancements
  • Using Dynamic PL/SQL
  • Using Pluggable Java Components (PJC’s).
  • Client interaction with WebUtil  
  • Array DML Processing
  • Testing the Results of Trigger DML
  • DML Statements Issued during Commit Processing
  • Overriding Default Transaction Processing
  • Getting and Setting the Commit Status

Writing 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

Sharing Objects and Code

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

Using WebUtil to Interact with the Client

  • Benefits of WebUtil
  • Integrating WebUtil
  • Interacting with the Client

Multiple Form Applications

  • Starting Another Form Module
  • Defining Multiple Form Functionality
  • Sharing Data among Modules

One Month
Two Months
Three Months
More than Three Months
PRINCE2 Foundation & Practitioner
MSP Foundation & Practitioner
APMP Certificate
ITIL Foundation
Scrum in One Day
Certified ScrumMaster
ISTQB Software Test Foundation
Microsoft Project
BCS Business Analysis Practice
Other - Please Specify Below

Our Customers Include