Form Personalization with Examples

Form Personalization with Examples

Form Personalization:

1. Form Personalization is a feature in Oracle Apps that allows us to change the behavior of form based screens.
2. It can be moved easily through FNDLOAD from one instance to another, It can be restricted at   Site/User/Responsibility Level.

What can be done through Form Personalization?

1.        Zoom from One form to another.

2.        Pass data from one form to another through global variables.

3.        Enable/Disable/Hide fields dynamically.

4.        Launch URL directly from oracle form.

5.        Call PL/SQL procedure.

Components of Form Personalization:

 

 

How To make a Field Mandatory in the Form:

 

Go for Any Perticular Form If you want to personalize, Open that form

 

 

 

Go as specified Navigation in Help ->Diagnostics-> Custom Code -> Personalize

 

 

 

Once Open That let we create 10.1 Seq For Make Field Mandatory (Make sure that This should be Enabled). 

 

Condition->Trigger Event we are selection as WHEN-NEW-FORM-INSTANCE.

 

 

 

Object_type:Item(Column)

Target_Object :MTL_SYSTEM_ITEMS.LIST_PRICE_PER_UNIT_MIP(Which field you want to make it mandatory select that column as target Object).

Property_Name:Required

 

 

 

 

 How to perform calculations in the field:

 

 

 

 

Calculations will be done through per each Record so we selected as WHEN-NEW-RECORD-INSTANCE

 

Let we calculate this in attirbute_13 in PO_LINES

 

 

 

Meaning of Special fields in Form Personalization:

•      Menu(1-15) will be in tools

•       Populate tools menu (SPECIAL 1-15)

•       Populate reports menu (SPECIAL 16-30)

•       Populate actions menu (SPECIAL 31-45)

•       It is recommended to use Menu before Tools

Various components used In Form Personalization:

Trigger Event  - These are predefined event. Based on the value chosen the function will execute only when that particular event triggers on the form.

Processing Mode - Query mode or Not in Query mode or   Both

Context   - At what level like user or Responsibility level

Menu      -    this is used to call one form from another. it is used to implement the zoom functionality. There are 45 menu entries which are used to call                      one form from current form.

Built In    -   It allows you to call Oracle standard built-in and Functions

 

Launch a URL

 

 

How to hide a field