oracle forms creation

Creating a Simple Form Module

Oracle APPS Blog-http://ebiztechnics.blogspot.co

m

Objectives

• Creating a Simple Form Module Using wizards• Types of Blocks• Control Block • Discuss properties of Data Block• Creating a Master-Detail Form• Relationship between data blocks


m

Crating a New Form Module

• Use one of the options to create a new form module 1. Use The Data Block Wizard

2. Build a new form manually3. Build a form Based on a Template.


m

Using Wizards..

Use Form Builder Wizards:

• Data Block Wizard: Used to create a data block with a data source.

• Layout Wizard: Used to display the data block items for Presentation.


m

Data Block wizard- Type of data block


m

Data Block wizard- Table or view name


m

Layout wizard- Changing Prompts


m

Layout wizard- Layout Style


m

Layout wizard-Rows Page


m

Data Block Functionality

Once you create a data block with the wizards, Form Builder automatically creates:

• A form module with database functionality including query, insert, update, delete

• A frame object• Items in the data block• A prompt for each item


m

Modifying the Layout

• You can modify the layout after creating the data block by using re-entrant wizards

– Select Tools -> Data block wizard to modify the data block– Select Tools -> Layout wizard to modify the Layout of the form.– Changes can be made manually also.


m

Types of Blocks

Data Block Control Block

- Base Table Block - Non Base Table Block


m

Creating a Control Block

• Select the Data Blocks node and click the Create icon. or Select Navigator—>Create.• Select the “Build a new data block manually” option in the New Data

Block dialog box.

– Invoke the property pallet for the block– Change the name of the block to CONTROL– Set the Database Data block property to No.


m

Data Block Properties

• General• Navigation• Records• Database• Advanced Database• Scrollbar• Font and Color• Character Mode• International


m

Database Properties for Data block

Use properties in the Database group to control:

• Type of block—data block or control block• Query, insert, update, and delete operations on the data block• Data block’s data source type and Name• Query search criteria and sort order• Maximum query time• Maximum number of records fetched


m

Navigation PropertiesORDERS

Order

Next NavigationData Block

SameRecordChangeRecord

PreviousNavigation Block


m

Visual Attributes

• Visual attributes are font, color and pattern properties applied for form and menu objects.


m

Data blocks and Relationships

Master

Detail

Master

Detail

Detail

Detail Detail

Master


m

Data block wizard – Master-Detail Relationship


m

Relation Object

• Relationship object is always created on the master block• Triggers and program units are generated automatically by form

builder• The default name of the relation object is Masterblock_DetailBlock


m

Creating Relation Manually


m

Deletion Behavior

• Non-Isolated (default setting) Prevents the deletion of a master record when associated

detail records exist in the database. • Isolated Allows the master record to be deleted

and does not affect associated detail records in the database.

• Cascading Allows the master record to be deleted and automatically deletes any

associated detail records in the detail block's base table at commit time.


m

Block Coordination

Immediate Deferred

WithAutoQuery

WithoutAutoQuery


m

Text files and Documentation

• Convert a binary file to a text file OR text file to birnary.By Selecting File-> Administration -> Convert.

• Create a text file for a form module for Documentation.By Selecting File->Administration -> Object List Report

.fmb .fmt


m

Summary

• Creating a simple Form module• Types of blocks• Master-Detail Form• Data block relationships • Data block Properties


m

oracle forms creation

Software