forms builder

Oracle Forms Builder 11g Main Screen

Once the appropriate menu item has been clicked on (for Windows), the Oracle Forms Builder Object Navigator will appear. . Note that the Oracle Forms Builder screen has remained virtually unchanged between Versions 9i, 10g and 11g. After starting up Oracle Forms, the main screen will be presented. The menu bar across the top provides […]

Oracle Forms and Reports 11g Starting Information

nstallations for Oracle 10g Developer and Oracle 11g Forms and reports should have similar Oracle Home start menu items. For example, the Oracle 11g Forms and Reports is installed on top of the Oracle Fusion Middleware (also called Weblogic Server) and has the following Start menu items: To run the Oracle 11g Forms Builder under […]

Oracle 9i, 10g and 11g Developer Suite Tools

Oracle Developer Suite contains the following main components: Oracle 9i, Oracle 10g and Oracle 11g Forms – For designing data entry forms. Oracle 9i and Oracle 10g Reports – For designing reports. Oracle 9i, 10g or 11g JDeveloper – For developing Java applications or applets Oracle 9i, 10g or 11g Warehouse Builder and Discoverer – […]

Oracle 9i, Oracle 10g and Oracle 11g Developer Suite Forms and Reports Prerequisites

Before following this tutorial, a student must have a valid user account in an Oracle server or a local installation of an Oracle database. Contact your DBA or systems administrator to learn the details of how Oracle server is set up in your organization. If you have a local instance of the Oracle database, please […]

Introduction To Oracle 9i / 10g / 11g Developer Suite Forms and Reports Tutorial

This tutorial introduces the Oracle 9i, Oracle 10g and Oracle 11g Developer Suite Release 2 that includes Oracle Forms and Oracle Reports. The main objectives are to demonstrate and provide hands-on instructions for creating and modifying data entry and query forms in various configurations, reports and graphics. Caveats: I have been working on this tutorial […]

Chapter No.10 How to save the data in database in Oracle?

In this chapter we will store the data in oracle database. In Chapter No.6 we have designed a form by using oracle forms builder with wizard.  We will store a data of these fields in database now. As we know that we are already created tables in database in Chapter No. 2. Open a form […]

How to set Item property in oracle forms builder?

You can easily set Item’s property of different items in form builder. For restrict Insert/Update in item: SET_ITEM_PROPERTY(‘TRANS_ID’,INSERT_ALLOWED,PROPERTY_FALSE); SET_ITEM_PROPERTY(‘TRANS_ID’,UPDATE_ALLOWED,PROPERTY_FALSE); For set required property No in item: SET_ITEM_PROPERTY(‘TRANS_ID’,REQUIRED,PROPERTY_FALSE); For set Enabled/Disabled item: SET_ITEM_PROPERTY(‘TRANS_ID’,ENABLED,PROPERTY_FALSE); For any color to Item: Set_Item_Instance_Property( ‘TRANS_ID’, CURRENT_RECORD,VISUAL_ATTRIBUTE,’VISUAL_ATTRIBUTE_NAME’);    

How to set Form’s Builder windows property?

By using this code we will set window property of the form. Just paste this code on form level in “WHEN-NEW-FORM-INSTANCE”. When you will run form then it will automatically set the property of the windows. ———————————————- set_window_property(forms_mdi_window, window_state, maximize); set_window_property(‘window1’, window_state, maximize); set_window_property(‘window1’, title, ‘Form Header Name’); ———————————————- * If you like this article […]

Pass Parameter from One Form to another

You can easily pass parameters from one form to another form by using this code. we need to transfer values of parent form to child form for different purposes for example for Login name ect…. 1- Make one parent form in oracle forms builder 2- Write this code behind the button of parent form that […]

How to call report through form builder and pass parameter.

You can call report through form builder also you can pass parameters through form to report. Just paste this code behind the button on form builder then call a report On report parameter name: “indent_id” On form parameter name :    “indent_trans_id” Report Name and location: D:\INDENTS.REP ——————————————– declare temp_id paramlist; begin temp_id := CREATE_PARAMETER_LIST(‘V_A’); ADD_PARAMETER(temp_id,’indent_id’,text_parameter,:indent_trans_id); […]

Dynamic List of Values

By using this code you will create dynamic List of values in oracle forms builder. 1- Create table and insert data in to. create table uom ( uom_id number, uom_name varchar2(25) ); insert into uom values(1,’pieces’); insert into uom values(2,’meters’); insert into uom values(3,’yards’); 2- Open forms builder and draw one field on forms builder […]