Value

The value of the On Field Update Set user property consists of three quoted parameters (double quotation marks) separated by a comma and a space, as follows:

"FieldToCheck", "FieldToSet", "Value", "Condition"

where Value and Condition are optional parameters.

The field FieldToSet is set to Value when the field FieldToCheck is updated. If the Value parameter is not defined, FieldToSet is set to the value of FieldToCheck. If the Condition parameter is defined, then FieldToSet is updated only if Condition evaluates to TRUE.

Use the following guidelines when using this user property:

• Do not use this user property to set a multivalue or calculated field. That is, if FieldToSet is a multivalue or calculated field, it does not update when FieldToCheck is updated.
• Do not define FieldToCheck as a field on a multivalue group. This user property does not recognize changes to a multivalue group field, including changing the primary field by changing the primary record of a multivalue group.

  For example, if On Field Update Set has the value
  "Primary Address Id", "Email Address", "my@oracle.com"
  on the Contact business component, it fails to update Email Address when the primary on the multivalue group Street Address is changed.

Usage

The Value parameter may be an expression. In the following example, the Done field is set using an expression when the Done Flag field is updated:

"Done Flag", "Done", "IIF ([Done Flag] = "Y", Today (), "")"

NOTE:  If you use an expression, it must evaluate to the data type of the targeted field. In the following example, the ToChar function is used to convert the date to a string before concatenating with another string and setting the value of the field.

"Agreement Start Date", "Name", "ToChar([Agreement Start Date]) + [Agreement Type]"

The following example shows how the Condition parameter is used. The Revenue field of the Opportunity business component is set when the Primary Revenue Amount field is updated, but only when the IsParentBCRevn field has a value of N:

"Primary Revenue Amount", "Revenue", "[Primary Revenue Amount]", "[IsParentBCRevn] = 'N'"

Various address business components, such as Business Address, populate their Address Name field with a concatenation of street address, city, and state. This field is updated, or not, by using a few On Update Field Set instances and the value of a calculated field whenever the street address, city, or state are updated. For example, when the city is updated, an On Update Field Set user property with the following value is used:

"City", "Address Name", "IIF( [Address Name Locked Flag] = ""N"", [Calculated Address Name], [Address Name])"

Similar numbered instances of the user property are used to update the Address Name field when the street address or state are updated.

You can create additional instances of this user property as needed. If you have more than one instance of this user property for a business component, they are executed sequentially by number (for example, On Field Update Set 1, then On Field Update Set 2, and so on). If there is only one such user property, then no number is required.

See also About Setting Numbered Instances of a User Property.

Parent Object Type

Business Component

Functional Area

CSSBCBase