Oracle Forms Personalization ALTERABLE (APPLICATION COVER) Property

The ALTERABLE (APPLICATION COVER) property is used to allow or disallow INSERT and UPDATE activities on a specific instance of an item regardless of the activity (new record or update record) being performed on the row.

Example:
Let’s use the Sales Order form to understand this property better.
Suppose we need to make Payment Terms field of Sales Order form to be non-editable to restrict users from updating the Payment Terms.

In order to achieve the above requirement, you may use the ALTERABLE (APPLICATION COVER) property as below.

– Open the Forms Personalization window by clicking on the Help -> Diagnostics -> Custom Code -> Personalize menu option.
o Seq – 10
o Description – Payment Terms Read Only
o Level – Function
o Enabled – Yes

– Condition:
o Trigger Event – WHEN-NEW-ITEM-INSTANCE
o Trigger Object – ORDER.TERMS
o Condition – 
o Processing Mode – Not in Enter-Query Mode

– Actions:

o Seq – 10

o Type – Property

o Description – Payment Terms Read-only

o Language – All

o Enabled – Yes

o Object Type – Item

o Target Object – ORDER.TERMS

o Property Name – ALTERABLE (APPLICATIONS COVER)

o Value – False

Save the record.