Oracle forms personalization:
What can be implemented through forms personalization?
Zoom from one form to another.
Enable/disable/hide fields dynamically.
Display user friendly message when required.
Launch URL directly from oracle form.
Call custom library dynamically.
The form personalization features allows to declaratively altering the behavior of form based
screens, including changing properties.
Executing built - INS
Displaying messages
Adding menu entries
The form contains mainly four sections.
Rules, conditions
Context
Actions
Personalization tables:
Fnd_form_custom_rules
Fnd_form_custom_actions
Fnd_form_custom_scopes
Fnd_form_custom_params
Fnd_form_custom_prop_list
Fnd_form_custom_prop_values
Invoking the personalization screen:
-> The personalization form should be used to implement the custom rules on a specific form.
-> The specific form refers to the desired form on which you want to apply the custom business logic or
modify the form behavior.
Navigation: help-diagnostics-custom code-personalize
Trigger events:
When new form instance - change field name, hiding a field, changing prompt in the form.
When new block instance -
When new record instance
When new item instance
When validate record (not in all forms)
Oracle forms personalization case_restriction:
This property is used to setup upper or lower case for a form field.
Open the forms personalization window by clicking on the help-diagnostics-custom code-
personalize menu options.
Seq-10
Description-move order header description uppercase setup.
Level-function
Enabled-yes
Condition:
Trigger event-when new form instance
Processing mode-not in enter query mode
Actions:
Seq-10
Type-property
Description-
Language-all
Enabled-yes
Object type-item
Target object – tomai_main_header_blk.description
Property name- case_restriction
Value – uppercase(uppercase/none/lowercase)
Save the record.
Now, whatever you type in the description field it will be entered using uppercase through caps lock in your keyboard is off.
Trigger can be created in three levels:
Form level trigger
Block level trigger
Item level trigger
When new form instance:
This trigger event is fired when a form is opened in response to clicking/double clicking a menu item in the oracle applications.
This may be used to fulfil following business requirements.
- Prompt a message as soon as form is opened
- Default a value in a field.
- Data sorting.
- Enable / disable a form field
- Show/hide field
- Change physical attributes(height,width)
When new record instance:
This trigger is fired when you create a new line/record in the block.
When new item instance:
This trigger is fired at the field level. That means based on the below screen shot this trigger may be fired at fields such as
number, price, need by date etc.
When new block instance:
This trigger is fired when the focus of an activity is moved to block.
Meaning of special fields in forms personalization:
Menu (1-15) will be in tools.
Populate tools menu (special 1-15):
Populate reports menu (special 16 – 30)
Populate action menu (special 31 – 45)
