0345 4506120

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

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the request service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

Our Customers Include