TECHNOLOGY : ORACLE FORMS

FORM COMPONENTS

1.        Triggers

2.       Alerts

3.       Attached Libraries

4.      Blocks

                       a.       Data Block

                       b.      Control Blocks

5.       Canvases

6.      Editors

7.       LOV’s

8.      Object Groups

9.      Parameters

10.    Popup Menus

11.     Program Units

12.    Property Classes

13.    Record Groups

14.    Reports

15.    Visual attributes

16.    Windows

17.    Menus

18.    Items

                        a.       Text Items

                        b.      Display Items

                        c.       Check Box

                       d.      Radio Button

                       e.      List Item

                       f.        Image Item

                       g.      Chart Item

                       h.      Custom Item

                        i.         Button

19.    Non-Data base Item

20.   Messages

21.    Navigation

22.   Form Built-in Functions (i.e. EXIT_FORM, COMMIT_FORM etc.,)

23.   Global Variables
24 .  Custom.pll
25.  Personalization
26. Customization
27 . Master Detail Form

OPERATIONS

• Creating and Utilizing Form Alerts

• How to setup form path
• Form Level Validations
• Block Level Validations
• Deleting Records
• Field Level Validations
• Avoid Duplicates
• Cannot be Left empty
• Should be greater than zero
• Avoid Non-Digits
• Making Unique ID for Details form from Master  form 

• Invoke the calendar for entering dates on a custom form
• How to enable Record History for a custom form

• How to Register the Form into Oracle Apps

• How to Register Form path in form_path

• How to develop a new form for Oracle Applications--DETAILED

• How to develop a new form for Oracle Applications--OVERVIEW

• How to Compile the Form

• System Variables in Oracle Forms
• How to Develop Query Find Form

VALIDATIONS

• Checking if supplier Id in the master block differs from that in the detail block

• Form checking empty field and non-digit data

• Checking duplicates and positive number

PERSONALIZATION - CUSTOMIZATION

• GL Date personalization in Journal Entry Form

• GL Date Personalization in Payment Form

• GL Date personalization in Invoice form

• Customer PO Number filed validation through custom.pll

• Make all responsibilities read-only for a user

• While Deleting Records

REAL TIME FORMS

• Dispatch Approval Form
• Discount Form
• Endorsement Form
• Item Creation Form
• Payment Advice Form
• QA Test Certificate Form
• Query Trip form
• Shipping Out Form
• Trip Allocation Form

R&D FORMS

• Category Master Form
• Customer Creation
• Customer Order Form
• Department Master Form
• Dispatch Note Form
• Employee Info Form
• FG Delivery Form
• Item Master Form
• Item PO Form
• Material Delivery Form
• Material Requision Form
• Menu Manager Form
• P.C. Delivery Challan
• P.C. Invoice Details
• P.C.Receipt
• Supplier Challan
• Supplier Info Form