Oracle Fusion Middleware 11g: Build Applications with Oracle Forms

Suggested Prerequisite

• Experience with SQL and PL/SQL basics
• Experience in advanced SQL & PL/SQL

Audience

• Application Developers
• Forms Developer
• Developer
• Support Engineer
• Technical Consultant
• PL/SQL Developer

Course Topics

1. Running a Forms Application

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

2. Working in the Forms Builder Environment

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

3. Creating a Basic Form Module

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

4. Creating a Master-Detail Form

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

5. Working Data Blocks and Frames

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

6. Working with Text Items

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

7. Creating LOVs and Editors

• Defining an Editor
• Creating an LOV Manually
• LOV Column Mapping
• Setting LOV Properties
• Setting Editor Properties
• Associating an Editor with a Text Item
• Using the LOV Wizard to Create an LOV
• LOVs and Record Groups

8. Creating Additional Input Items

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

9. Creating Noninput Items

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

10. Creating Windows and Content Canvases

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

11. Working with Other Canvas Types

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

12. Producing and Debugging Triggers

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

13. Adding Functionality to Items

• Interacting with Noninput Items
• Coding Item Interaction Triggers

14. Displaying Run-Time Messages and Alerts

• Triggers for Intercepting System Messages
• Built-Ins and Handling Errors
• Controlling System Messages
• Handling Server Errors
• Creating and Controlling Alerts
• The FORM_TRIGGER_FAILURE Exception

15. Using Query Triggers

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

16. Validating User Input

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

17. Controlling Navigation

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

18. Overriding or Supplementing Transaction Processing

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

19. Writing Flexible Code

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

20. Sharing Objects and Code

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

21. Using WebUtil to Interact with the Client

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

22. Introducing Multiple Form Applications

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