Scribd
Upload
62 views5 pages

Oracle Forms Design and Compilation Guide

This document provides instructions for designing and registering an Oracle Forms form. It outlines the steps to: 1. Install Form Builder and download required files locally for form design. 2. Export the Forms path and compile the form on the server. 3. Design the form structure in Form Builder including creating windows, canvases, and datablocks. 4. Add different item types like text, radio buttons, lists, and checkboxes; and set their properties and triggers. 5. Configure form-level changes and enable audit columns using triggers.

Uploaded by

Mahesh
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
62 views5 pages

Oracle Forms Design and Compilation Guide

This document provides instructions for designing and registering an Oracle Forms form. It outlines the steps to: 1. Install Form Builder and download required files locally for form design. 2. Export the Forms path and compile the form on the server. 3. Design the form structure in Form Builder including creating windows, canvases, and datablocks. 4. Add different item types like text, radio buttons, lists, and checkboxes; and set their properties and triggers. 5. Configure form-level changes and enable audit columns using triggers.

Uploaded by

Mahesh
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

Oracle Forms Design and Registration:

Mandatory Steps to Design the Form in the Local Mechine:

1. Install Form Builder

1. Download the Resoure Folder AU_TOP/bin Folder

3. Download [Link] and [Link] and [Link]

4. Give the Resource Path to form Builder properties ( Start In )

Mandatory Steps to Compile the Form in Server:

1. Export the Forms Path to AU_TOP/12.0.0/Forms/US

syntax:

export FORMS_PATH=$
{FORMS_PATH}:/u01/oracle/VIS/fs1/EBSapps/appl/au/12.0.0/forms/US/

2. Compile the Form in serverlocation

Syntax:

frmcmp_batch Module=[Link] Userid=apps/apps Module_Type=FORM


Compile_All=Y
Output_File=/u01/oracle/VIS/fs1/EBSapps/appl/ont/12.0.0/forms/US/[Link]

fmb : Form Module binary


fmx : Form Module Executable

Design a Form in Form Builder:

1. Open the [Link] file and rename the file Name with Custom Name.

2. Delete the Block_name from the below locations.


1. Window
2. Canvas
3. Datablock -- Remove both BLOCK_NAME and DETAIL_BLOCK_NAME

The Form Strecture is like this:

1. Window --> Canvas -- > Data block

1. Create Window :

Create window by click on the plus sign and rename the window name.

Enter the subclass Information : WINDOW

Give the Window Name in Two Places:


1. PRE_FORM ( Change the BLOCK_NAME to Window Name)
and the chnage the Date and Custom top name where you want to complie the form

[Link] the Window Name in Program Units APP_CUSTOM package Body ( Give the window
Name)

3. Give the Form Name WHEN_NEW_FORM_INSTANCE

2. Create Canvas :

Go to Canvas and click and plus symbol and create Canvas


Give the Canvas Subclass Information as CANVAS

The Canvas is in Two Styles :


1. Form
2. Tabular

3. Create Datablock:

Go to Datablocks and click and plus symbol and create a Datablock.

Give the Subclass Information as BLOCK

1. Text Item: Text Item is Used for Database Fileds

Subclass Information : Text_Item

How to set Initial Value, Lowest , Highest and Hint at the Item Level:

Go To Property Pallet for the Item

Initial Value :
:
Lowest Allowed Value :

Highest Allowed value :

Hint :

How to change Color for the perticular filed:

Go to Item Property pallet:

Foreground Color:
Background Color:

2. Create a Radio Button:

Create Item and Change the Properrty Palette -> Item type -> Radio Group
Under Radio Group Radio buttons are avaliable

Example:

Lang : Column Name


Language values: English, Hindi, Telugu

So here we need to create three radio buttons for the Radio Group

Note: Number of Radio button need for radio group is based on the number of Unique
Values under the Item.

Mandatory Steps for the Radio Buttons:

While creating Radio buttons we have to set below Values:

1. Radio Group

( Example: Lang ( Database Column)

Give the Initial Value for the Item.

2. Radio Button

Give the Radio Button Value for the Button. ( Label is used to change the Name of
the button)

Triggers which we can use for the Radio Button:

WHEN-RADIO-CHANGED

Sample Trigger Code:

IF UPPER(:BLOCK_NAME.FILED_NAME) = 'ENGLISH' THEN


MESSAGE(' You Selected English');

ELSIF UPPER(:BLOCK_NAME.FILED_NAME) = 'HINDI' THEN


MESSAGE(' You Selected HINDI');
ELSIF UPPER(:BLOCK_NAME.FILED_NAME) = 'TELUGU' THEN
MESSAGE(' You Selected Telugu');

End If;

3. List Item :

List Item is used to give the list of the items in data base.

Chnage the Item type: List Item


Sub Class Information : List

Mandatory Things:
List of Element : It will diplay the Vlaue in Form

List Of Value: It will Store the Value In Database

Note: If the List of Value not matched with the Database the Record Values not
appared.

4. Check Box:

Check box is used when ever you want to use Yes/No Conditions in a perticular
Column.

item Type :Check Box


Subclass Information: Check Box

Functional:

Value when Checked: Yes


value when Unchecked: No

Optional Filed: We can assign the Initial Value for the Check Box.

Note: The Values you entered in the above fileds must match with Database values.

Difference Between Check Box and Radio Group:

Radio Group the Radio button is depend the Number of Values in the Column.

Checkbox is depending only for the column. Ie One Column one Check Box.

Trigger:
WHEN-CHECKBOX-CHANGED

Example:

IF UPPER(:BLOCK_NAME.FILED_NAME) = 'YES' THEN


MESSAGE(' You Selected Check Box');
ELSE
MESSAGE(' You are not Selected Check Box');

End If;
Form Level Change :

PRE_FORM Trigger : Change the Form Name and the Top Name for the Form

Enable Who Columns in table:

PRE_INSERT in block level :

FND_STANDARD.SET_WHO();

PRE_UPDATE in block level:

FND_STANDARD.SET_WHO();

How to attach or Enable Calander in Form:

Datablock Items : gotoperticular Filed and in the list of values give


ENABLE_LIST_LAMP

Column Triggers:KEY-LISTVAL :

[Link];

Common questions

Powered by AI

A radio button trigger in Oracle Forms is implemented using the WHEN-RADIO-CHANGED event. The purpose is to execute specific code when the radio button's value changes. A typical example would be using an IF-ELSIF construct to display a message based on the selected option, such as showing a message indicating which language has been selected (English, Hindi, Telugu) upon changes to the RADIO_GROUP's value .

The 'PRE_FORM' trigger in Oracle Forms is crucial for initializing the form before any interaction occurs. It is used to set form-specific attributes, such as changing the Form Name and Top Name, which are essential for ensuring that customized behaviors and initial settings are loaded with the form. This trigger helps in setting the stage for the form's operational context and ensures that environment-specific customizations are applied right before user interaction starts .

A form in Oracle Forms Design is structured as follows: it consists of Windows, Canvases, and Data Blocks. A Window contains a Canvas, which is essentially the display area for the user interface components. Data Blocks act as containers for data items such as text fields and other widgets that interact with the underlying database. Each component must be created and configured properly to ensure coherent interaction and presentation within the form .

Ensuring that database values match form values is crucial because discrepancies lead to improper data representation and potential errors in data manipulation. When using list items, misaligned values fail to correctly populate the form or update the database, disrupting user interaction with lists and potentially leading to transaction failures since only matched values correctly influence database operations .

To design a form using Oracle Forms Design and Registration on a local machine, the mandatory steps include: first, installing the Form Builder; second, downloading the Resource Folder from AU_TOP/bin; third, downloading TEMPLATE.fmb and other templates like APPSTAND.fmd and APSTAND.fmb; fourth, specifying the Resource Path in Form Builder properties under 'Start In'. These steps ensure the environment is correctly prepared for form design .

To enable calendar functionality for a date field in Oracle Forms, access the data block item and set the appropriate properties to interact with calendar widgets. Specifically, incorporate the KEY-LISTVAL trigger to call 'CALENDAR.SHOW', which prompts the calendar display linked to that field. This setup allows users to conveniently select dates from a visual calendar rather than manually inputting date values .

In Oracle Forms, a checkbox is used for single-option boolean conditions (Yes/No), with the class information 'Check Box'. A radio group is used where multiple options exist; the number of radio buttons corresponds to the number of unique values in a column, making them mutually exclusive. The checkbox implementation involves simply toggling between two states, whereas a radio group requires setting up a radio group container and defining each button's values and labels .

Form-level changes affect the overall form configuration and behavior, often involving global settings or initializations that apply to all components, such as using 'PRE_FORM'. Block-level changes, like 'PRE_INSERT' and 'PRE_UPDATE' triggers, specifically involve interactions with the data block, focusing on database transactions. For instance, 'FND_STANDARD.SET_WHO()' is used in 'PRE_INSERT' and 'PRE_UPDATE' to manage auditing information on the block level, ensuring correct transactional metadata is maintained .

To set properties and create an interface for a data block item in Oracle Forms, navigate to the Property Palette for the item. Set properties including Initial Value, Lowest Allowed Value, Highest Allowed Value, and hints for the item. Furthermore, you can change visual properties such as Foreground and Background Color by accessing the Item's Property Palette. This process allows customization of data presentations and interactions within the form .

Compiling an Oracle form on the server involves two key steps. First, exporting the Forms Path using the syntax: 'export FORMS_PATH=${FORMS_PATH}:/u01/oracle/VIS/fs1/EBSapps/appl/au/12.0.0/forms/US/'. Second, compiling the form using the command: 'frmcmp_batch Module=XXOCRCUSTHOLDS.fmb Userid=apps/apps Module_Type=FORM Compile_All=Y Output_File=/u01/oracle/VIS/fs1/EBSapps/appl/ont/12.0.0/forms/US/XXOCRCUSTHOLDS.fmx'. Exporting the path ensures the system recognizes the directory structure for form compilation, while the compilation command translates the form module (fmb) into an executable form (fmx) that can run on the server .

You might also like