Exforsys

Oracle Apps 11i

  1. ERP Overview
  2. Oracle Apps 11i: Overview of popular ERP Products
  3. Oracle Apps 11i: Advantages of Oracle E-Business Suite
  4. Oracle Apps 11i : Getting started with Oracle Applications
  5. Oracle Apps 11i: Internationalization Support and Multiple Reporting Currencies
  6. Oracle Apps 11i : File System
  7. Oracle Apps 11i Installation - System Requirements
  8. Oracle Apps 11i - Using Rapid install and the Steps Before Apps Installation
  9. Single Node and Multi Node Installation Part 1
  10. Single Node and Multi Node Installation Part 2
  11. Oracle Apps Application Framework
  12. Oracle Apps Table Registration API
  13. Oracle Apps Concurrent Processing
  14. Oracle Apps Concurrent Library Window
  15. Oracle Apps Message Dictionary
  16. Oracle Apps Flex fields
  17. Oracle Apps Implementing Key Flex field and Descriptive Flex field
  18. Oracle Apps Template Form
  19. Special Triggers in the Template Form in Oracle Apps 11i
  20. Creating New Forms in Oracle Apps 11i
  21. Creation of Master Detail Block in Oracle Apps 11i
  22. Registering New Forms in Oracle Apps 11i
  23. Oracle Apps 11i: Setting up Chart Of Accounts (COA)
  24. Oracle Apps Sys Admin - Users and Responsibilities
  25. Oracle Apps 11i : Creating Journals through Oracle GL
  26. Oracle Apps 11i : Suppliers
  27. Oracle Apps 11i : Asset Management - Asset Book Positioning
  28. Oracle Apps 11i : Asset Management - Asset Books Regions
  29. Oracle Apps 11i : Asset Management - Manual and Quick Additions
  30. Oracle Apps 11i : Asset Management - Mass Additions
  31. Oracle Apps 11i : Asset Management - Asset Adjustments
  32. Oracle Apps 11i : Asset Management - Mass Transfers
  33. Oracle Apps 11i : Asset Management - Depreciation
  34. Oracle Apps 11i : Asset Management - Retirements
  35. Oracle Apps 11i : Asset Management - Journal Entries
  36. Oracle Reports 6i

Ads


Home arrow Technical Training arrow Oracle Apps 11i

Oracle Apps Template Form

Page 1 of 2
Author : Exforsys Inc.     Published on: 3rd Jul 2005    |   Last Updated on: 1st Jan 2009

Oracle Apps 11i : Template Form in Oracle Apps 11i

This document provides an overview of the template form. This form derives its importance from the fact that this form is the starting point of all development involving forms. The document highlights the importance of Template.fmb in forms development and also provides a detailed explanation of the various components of the Template form.

Ads

Figure -1 Template.fmb

Overview of the Template Form

The TEMPLATE form is the starting point for all development of new forms. The first step in creating a form for use in Oracle Applications is to copy the template form from $AU_TOP/forms/US, to a local directory and renaming it.

The Template form is unique because it contains some special libraries and triggers that render the application using the template form some standard characteristics. The components of the template form are:

  • References to object groups: The template form contains platform–independent references to predefined standard object groups in the APPSTAND form (STANDARD_PC_AND_VA,STANDARD_TOOLBAR, and STANDARD_CALENDAR).
  • Libraries: The template form contains platform–independent attachments of several libraries (including FNDSQF, APPCORE, and APPDAYPK).
  • Special triggers: The template form contains several form–level triggers with required code. These are responsible for standard the behavior of the form.
  • Predefined Program Units: The template form contains predefined program units that include a spec and a body for the package APP_CUSTOM, which contains default behavior for window opening and closing events.
  • Applications Color Palette: The template form contains the application color palette. This gives the forms developed using the template form the look and feel of Oracle applications.
  • Many referenced objects (from the object groups) that support the Calendar, the toolbar, alternative regions, and the menu. These objects include LOVs, blocks, parameters, and property classes, and so on.
  • The TEMPLATE form contains sample objects that can be seen as examples for the expected layout cosmetics. These samples can be completely removed from the form later as they are only examples and are not required. The following objects are the samples and can be removed:
    • Blocks: BLOCKNAME, DETAILBLOCK
    • Window: BLOCKNAME
    • Canvas–view: BLOCKNAME

Hence, the template form comes along with many attachments, predefined program units, and defined visual attributes as well as examples that not only give the forms that are developed using the template.fmb a standard look and feel, but also make t easier to develop forms with consistent and standard functionality.

Libraries in the Template form

As stated above, the template form contains platform–independent attachments of several libraries. These libraries are used while running the form as a part of Oracle Applications. Hence, these libraries should not be changed or modified. There are three main libraries that are attached to the template form:

Figure -2 Template Form attached libraries

APPCORE

APPDAYPK

FNDSQF

Each of these libraries is explained in detail below.

Ads

APPCORE

APPCORE contains the packages and procedures that are responsible for the standard ‘Oracle Applications’ behavior of the forms. The forms have to support the menu, toolbar, and other required standard behaviors in compliance with oracle applications.

The Oracle Applications forms also have to display specific runtime behaviors in accordance with the Oracle Applications User Interface Standards, such as the way in which fields are enabled, behaviors of specific types of windows etc. APPCORE contains the procedures to support this standard runtime behavior.

APPCORE also contains various other utilities for exception handling, message levels, and so on.



 
This tutorial is part of a Oracle Apps 11i tutorial series. Read it from the beginning and learn yourself.

Oracle Apps 11i

  1. ERP Overview
  2. Oracle Apps 11i: Overview of popular ERP Products
  3. Oracle Apps 11i: Advantages of Oracle E-Business Suite
  4. Oracle Apps 11i : Getting started with Oracle Applications
  5. Oracle Apps 11i: Internationalization Support and Multiple Reporting Currencies
  6. Oracle Apps 11i : File System
  7. Oracle Apps 11i Installation - System Requirements
  8. Oracle Apps 11i - Using Rapid install and the Steps Before Apps Installation
  9. Single Node and Multi Node Installation Part 1
  10. Single Node and Multi Node Installation Part 2
  11. Oracle Apps Application Framework
  12. Oracle Apps Table Registration API
  13. Oracle Apps Concurrent Processing
  14. Oracle Apps Concurrent Library Window
  15. Oracle Apps Message Dictionary
  16. Oracle Apps Flex fields
  17. Oracle Apps Implementing Key Flex field and Descriptive Flex field
  18. Oracle Apps Template Form
  19. Special Triggers in the Template Form in Oracle Apps 11i
  20. Creating New Forms in Oracle Apps 11i
  21. Creation of Master Detail Block in Oracle Apps 11i
  22. Registering New Forms in Oracle Apps 11i
  23. Oracle Apps 11i: Setting up Chart Of Accounts (COA)
  24. Oracle Apps Sys Admin - Users and Responsibilities
  25. Oracle Apps 11i : Creating Journals through Oracle GL
  26. Oracle Apps 11i : Suppliers
  27. Oracle Apps 11i : Asset Management - Asset Book Positioning
  28. Oracle Apps 11i : Asset Management - Asset Books Regions
  29. Oracle Apps 11i : Asset Management - Manual and Quick Additions
  30. Oracle Apps 11i : Asset Management - Mass Additions
  31. Oracle Apps 11i : Asset Management - Asset Adjustments
  32. Oracle Apps 11i : Asset Management - Mass Transfers
  33. Oracle Apps 11i : Asset Management - Depreciation
  34. Oracle Apps 11i : Asset Management - Retirements
  35. Oracle Apps 11i : Asset Management - Journal Entries
  36. Oracle Reports 6i
 

Comments