Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Monday, 18 April 2016

Oracle Forms Introduction

Components of Forms:

     Oracle has provided “Forms Developer Suite” that enable business developers to easily and quickly construct sophisticated database forms and business logic with a minimum of effort. It consists of the following programs, or components:

Forms Developer
Form Compiler
Forms Runtime

Components of Form builder
Object Navigator: It is hierarchical browsing and editing interface that enables you locate and manipulate application objects quickly and easily.

Property Palette: It is used set and modify the properties for all objects in form modules.

Layout Editor: It is graphical design facility for creating and arranging interface items and graphical objects in your application.

PL / SQL Editor: It is the integrated functionality of oracle procedure builder that exists with in form builder.

Form Module types:
 Form Module: It is a collection of objectives such as block, canvas, items and event based PL/SQL code blocks called trigger.

 Menu Module: It is a collection of menu items. It can be main menu or sub menu.

 PL / SQL Libraries: The library module is a collection of PL/SQL function and package stored in a single library file. This library file is the attached to form / menu modules. All other objects in the form or menu can now access share the collection of PL/SQL functions and procedures.

Object Libraries: It is a collection of form objects that you can use in other modules. You can create it to store, maintain and distribute standard objects that can be reuse across the entire development organization.

Objects of forms:

Blocks:Block is logical owner of items. It provides a mechanism for grouping related items into a functional unit for storing, displaying and manipulating records.

Items:These are interface objects that present data values to the user or enable the user to interact with the form.

Canvas:A canvas is the background object upon which interface items appear.

Frames:Frames are used to arrange items with in a block.

Windows:Windows contains for all visual objects that make up a form builder application.

PL/SQL Code Block: It is used for event driven code. That code automatically executes when a specific event occurs.

Data Blocks:

In Forms Builder there are two main types of blocks

Database Blocks: A data block is associated with a specific database table (or view), a stored procedure, a FROM clause query, or transactional triggers.

Control Blocks: A control block is not associated with a database, and its items do not relate to any columns within any database table. Its items are called control items.

Canvas Types:
Form Builder provides four types of canvases, all of which can be displayed in the same window at runtime.  A canvas' type defines how Form Builder will display it in the window to which it is assigned.

Content Canvas:  The most common canvas type is the content canvas (the default type).  A content canvas is the "base" view that occupies the entire content pane of the window in which it is displayed.  You must define at least one content canvas for each window you create.

Stacked Canvas:  A stacked canvas is displayed a top of on the content canvas assigned to the current window.

Tab Canvas:  A tab canvas made up of one or more tab pages allows you to group and display a large amount of related information on a single dynamic Form Builder canvas object.

Toolbar Canvas:  A toolbar canvas often is used to create toolbars for individual windows.  You can create two types of toolbar canvases:  horizontal or vertical.  Horizontal toolbar canvases are displayed at the top of a window, just under its menu bar, while vertical toolbars are displayed along the far left edge of a window.

Form Module Hierarchy

Using trigger and program units, form functionality will be added.Trigger can be written at different levels in form module

Oracle has provided one template form (TEMPLATE.fmb) and stated that this form should be the starting point for all development of new forms in Oracle Application.
Oracle has already written minimum but all code which is required to implement Oracle Application Standard Functionality. The pre-written components of the template form includes platform-independent references to:
Object groups in the APPSTAND form

Special triggers
Predefined Program Units
Applications Color Palette

The APPSTAND form contains the master copy of the shared objects. It contains the following Object Groups

STANDARD_PC_AND_VA:contains the Visual Attributes and Property Classes required to implement much of the user interface for Forms-Based Products

STANDARD_TOOLBAR:Contains the windows, canvasses, blocks, and items of the Applications Toolbar

STANDARD_CALENDAR: contains the windows, canvasses, blocks, and items of the Applications Calendar

QUERY_FIND:contains a window, canvas, block, and items used as a starting point for coding a Find Window

Libraries in the TEMPLATE Form

The TEMPLATE form includes platform-independent attachments of several libraries. Few of these libraries are:

APPCORE:It contains the packages and procedures that are required of all forms to support the menu, Toolbar, and other required standard behaviors

APPCORE2:It is a near-duplicate of APPCORE intended for use with the CUSTOM library. Oracle recommends that you should use the corresponding routine in the APPCORE2 library in place of APPCORE. The various routines available are APP_ITEM_PROPERTY2, APP_DATE2, APP_SPECIAL2

APPDAYPK:It contains the packages that control the Calendar feature

FNDSQF:It contains packages and procedures for Message Dictionary, flexfields, profiles

CUSTOM:It allows extension of forms without modification of form code

GLOBE: It allows developers to incorporate regional features into forms. The GLOBE library calls routines in the JA (Asia/Pacific region), JE (Europe/Middle East/Africa), and JL (Latin America region) libraries

Form Creation Steps in oracle apps
1.    Open Template.fmb
2.    Delete BLOCKNAME from Windows, Canvas and Data Blocks
3.    Create New Window and set Subclass in formation as ‘Window’
4.    Create Canvas and set Subclass in formation as ‘Canvas’
5.    Attach Window in Canvas and canvas in window (Property palate)
6.    Create the Data Block using wizard
7.    Set the First Navigation block in Module Property
8.    Open PRE-FORM Trigger and provide the WINDOW NAME in place of BLOCKNAME.
app_window.set_window_position(' BLOCKNAME ', 'FIRST_WINDOW');
9.    Open APP_CUSTOM Package provide the WINDOW NAME in place of your first window
         if (wnd = '<your first window>') then app_window.close_first_window;
10. Compile the form.

Generate FMX
Transfer (in binary format) the FMB file to server at $AU_TOP/forms/US
Login to UNIX environment and run below command (from $AU_TOP/forms/US) to generate FMX

For 11i
f60gen module=XXForm.fmb module_type=form userid=apps/<apps_password> compile_all=special output_file=$XXLCB_TOP/forms/US/XXForm.fmx

For R12
frmcmp_batch module=XXFORM.fmb userid=apps/<apps_password> output_file=$XXLCB_TOP/forms/US/XXFORM.fmx
Share this article :


  1. Hi There,

    So bloody thorough! Ah! So happy and blessed out! I feel redeemed by reading out Oracle Forms Introduction Keep up the good work!

    I got a list of the INDEXES from DBA Team which are non value added to the Database with the following conditions
    Thank you very much and will look for more postings from you.

    Thanks and Regards,

  2. Hello,

    Oracle Forms Introduction being contrived to exist for many projects simply so it can be run will be the first to hit the wall, but those projects where the functions to make existing transactions cheaper in real world applications will find the elusive real world demand.

    I am trying to use this in a materialized view and got below error:

    SQL Error: ORA-12015: cannot create a fast refresh materialized view from a complex query

    12015. 00000 - "cannot create a fast refresh materialized view from a complex query"

    *Cause: Neither ROWIDs and nor primary key constraints are supported for

    complex queries.

    *Action: Reissue the command with the REFRESH FORCE or REFRESH COMPLETE

    option or create a simple materialized view.

    select IR.rowid MV_INST_LOBR_ROWID, J.rowid Job_ROWID, J.* FROM JOB J





    Basically, the intention is to get all the records joining MV_INST_LOB_R and JOB table
    where MV_INST_LOB_R do not have record for the joining condition J.I3200_CUST_AC_NO_PT1 / J.I3200_CUST_AC_NO_PT2

    Can you help me in converting to simple query, so that I can use simple materialized view.

    Follow my new blog if you interested in just tag along me in any social media platforms!


  3. This machine is very easy to use. Beginner sewers will only need a couple of stitches, but experienced sewers should look for a machine with a wider range of stitches. If you're an experienced sewer, you may prefer a machine that has free motion capabilities or embroidery capabilities. You'll also want a machine with tension settings to adjust the machine to the right level for you. The more options you have, the better. (

  4. The Importance of Fitness for Health and Well-Being.

    Physical fitness is the state of health and well-being and is essential for daily activities. Proper nutrition, moderate-vigorous exercise, adequate rest, and a formal recovery plan are all factors that contribute to being physically fit. Here are some tips to help you achieve this level of fitness:! Read on for some useful tips! This article will help you become fit and healthy. You can start your fitness journey today! Here are some of the most important steps. (
    First, know the importance of physical fitness. A person with good physical fitness is happy and energized, has glowing skin, and a positive outlook on life. But more than that, fitness involves mental and emotional health. As John F. Kennedy once said, "Physical fitness equates to mental fitness". By incorporating a healthy diet and regular exercise into your lifestyle, you will be on the right track toward achieving the healthiest body you can have.

  5. What is Cash Mobilya?

    The Cash Mobilya is a mobile payments platform for business and consumers. The company is a yenilikci and global dunya markas that has been around for many years. It is a leading online mobile payment company that provides customers with advanced point-to-point tracking systems and real-time quality monitoring of their vehicles. Its partnership with Tarafndan Ula will further improve its distribution infrastructure and customer service. It will also improve its profitability.
    This Malaysia-based company has outlets all over the world, and it is one of the largest companies of its kind in the textile industry. Besides its outlets in the United States and UK, Cash Mobilya has stores in several countries. The brand is widely recognized in the textile industry and has many customers in other countries. Here are a few of the company's products. These include clothing, shoes, accessories, and more.

    1. What is Cash Mobilya?
      A novel by Filipino lawyer Tanuwa Udayko, Cash Mobilya tells the story of a young woman who is arrested for DUI. She has just bought her first car and is looking for a driver who can take her to the birthday party. But, she is not able to afford a cab, so she hires a general who drives her to the party. Luckily, the general is a good guy, so she ends up hiring him and the whole process goes smoothly.
      The software developed by Cash Mobilya was designed with the assistance of local legends in the real estate industry. It helps the law firm make better business decisions, as it can simulate the entire process. Hundreds of trainees have joined the program and are now running their own real estate companies in Penang and other locations.

  6. What Is Fitness?
    The best way to achieve optimal healthis to exercise regularly. Achieving a healthy weight requires physical activity, and the right nutrition. Eating a healthy diet and exercising regularly will help you feel better physically. There are several different ways to get a healthy body. Try these exercises to stay fit and stay in shape. There are many benefits to physical fitness. If you exercise consistently, your health will improve and you will be able to participate in many activities.

  7. How Can I Improve My Health and Fitness?
    According to the World Health Organisation, health
    is a fundamental right, encompassing personal and social resources as well as physical capacities. In the world health context, it refers to a person's ability to maintain homeostasis, recover from adverse events, and live a happy, productive life. It also includes the mental and emotional capacities of an individual. In addition to physical characteristics, good health is the ability to manage stress, acquire skills, and form relationships.

  8. MP4 Vs MKV - What's the Difference?
    MP4 and MKV are both video formats, but both can be compressed in different ways. The first one is the most popular format for streaming video services, but there are some differences between them. Techsbase Both can be used on streaming media players, including Apple TV, Roku, and WDTV. MKV, on the other hand, is a more flexible format, allowing for multiple audio and subtitle tracks, while still maintaining quality.

  9. AVI Vs MP4 - How to Convert MP4 Files to AVI
    AVI is an Audio Video Interleave file and MP4 is an MPEG-4 video file. Both formats were developed by Microsoft and MPEG.(Techspecial You can use either format to watch videos. AVI is better for storing video files and MP4 is better for storing audio files. However, you should know that you can convert MP4 files to AVI with a variety of software. Here's how.
    AVI supports more video codecs than MP4, but you may have to tinker with both. AVI supports more codecs, while MP4 is better for downloading videos. Despite their similar name, AVI is compatible with more Windows players. Unlike AVI, it's also compatible with more file formats. And if you need a smaller file size, you'll need to download MP4 instead of AVI.

  10. The Benefits of Low-Energy Systems.
    There are numerous benefits of low-energy systems to build buildings and homes that are energy efficient. They offer better thermal comfort and the environment in addition to reducing the cost of energy.( The best low-energy systems have been built to be durable and simple to set up. They also come with the benefit of being cheaper. These benefits could make them an investment worth it for homeowners. Here are some. Learn more about them. Don't fret if you're unfamiliar with these new technologies.

  11. Competitive Intelligence - Four Major Forces That Affect Your Business
    Being competitive helps you plan and implement your business plan. In a dynamic market, your business might require more flexibility and devise strategies that are adaptive to make the most of opportunities.techycamps.comTechycamps Monitoring these factors is crucial for your business to remain at the top of its game and maximize the odds of success against its competitors. By analyzing your competitive intelligence will help you discover opportunities and limit the risk. Here are the four primary factors that can affect your company.

  12. Panasonic KX-TG833 Bluetooth Speakerphone Review
    The new KX-TG833 is a multi-purpose Bluetooth speaker, compatible with multiple devices, including iPhones, Android phones, and tablets. ( The metallic black body is aesthetically pleasing and can sync with two smartphones. It has Siri, Google Now, and S Voice. It also blocks up to 150 unwanted callers, and is expandable to six handsets. While it does not offer a lot of bells and whistles, it does come with a great price tag.

  13. How Does A Automobile Work?
    The automobile has had a profound impact on human life. It is a very important part of human history, economy, and social life. (Automobilebabe ) The automobile is responsible for the rapid growth in the United States during the twentieth century. Thousands of jobs are created by the automobile. As a result, cars are very important for our everyday lives. The world economy has become highly dependent on the automobile. It also contributes to the environment. Some cities are built with big roads for cars, leaving no space for walking or bicycling.

  14. This comment has been removed by the author.

  15. The basics of the automobile
    The automobile was first developed in Germany in the 19th century and then perfected in France in the 20th. (Automobilecamp) American manufacturers, including Henry Ford, began to dominate the automobile industry in the early 20th century. The automobile became a major economic and social power due to its mass production and affordability. The automobiles became the "Big Three" in the 1920s. After World War II, many manufacturers turned their attention to the military. However, after the war, the automobile market boomed, particularly in Japan and Europe. The automobile industry was globalized by 1980.

  16. What is automobile and types?
    There are different kinds of automobiles; passenger cars, cargo cars and cars for the construction of roads and buildings. ... Passenger cars are the automobiles to transport people. (Carsandbiker) Taxis, buses, and private cars are passenger cars.

  17. What is an automobile?
    Many parallels can be drawn between the history of automobiles and the history of railways. (Automobilenewsify) In the nineteenth century, people traveled long distances both by rail and road. The popularity of passenger cars has increased in the 20th century. There are now 1.4 billion cars in the world, with one-fourth being made in America. Americans drive approximately three trillion miles each year. Half of these cars are manufactured abroad. A car can be classified on many bases, including its engine and various parts.

  18. What is an automobile?
    There are many benefits and drawbacks to automobiles. (Automobilemagazineryx) Automobiles can have negative environmental effects, in addition to their economic and safety impacts. Automobiles emit hydrocarbons, carbon monoxide and nitrogen oxides into our atmosphere. Emissions from cars can be extremely dangerous and they are particularly harmful in large cities. The United States is well-known for its high levels of pollution. Major metropolitan areas have poor air quality that can be considered unacceptable, even dangerous for your health.

  19. How do you come up with Great Business Ideas
    A business is any entity that seeks to make an income by buying or selling products or services. (Businesstycoonbot) While there are various terms for business they're all tied to the pursuit of making money. For instance, a business like Apple is a business that operates by selling iPhones. A company like ExxonMobil conducts business through the provision of oil. A corporation, on other hand, runs its business through the provision of innovative and fresh items and solutions.

  20. What is a business?
    The term"business" is a broad term that is used to describe any business activity which is designed to generate revenue or profits.(Powerfullbusiness) There are many different kinds of businesses but there are a few common ones that are well-known. The first and most important thing is that businesses involve the manufacturing, selling and distribution of goods and services to earn a the purpose of earning profit. To be considered being a "business," it must regularly purchase and sell items and services. Business is never an event that happens once. For instance, if sell furniture regularly and you are operating.

  21. What is a business?
    The term"business" is a broad term that is used to describe any business activity which is designed to generate revenue or profits. (Businesszila) There are many different kinds of businesses but there are a few common ones that are well-known. The first and most important thing is that businesses involve the manufacturing, selling and distribution of goods and services to earn a the purpose of earning profit.