Configuring Siebel Business Applications > About Business Components, Fields, Joins, and Links > About Business Component Fields >

How a Business Component Field Calculates a Value


A calculated field is a type of business component field that gets values from other fields that reside in the same business component or from the parent business component in an active link where the current business component is the child business component. The Calculated property of a calculated field contains a check mark and the Calculated Value property contains a value that is not empty.

The Calculated Value property contains an expression that Siebel CRM builds from field names, predefined functions, and string, numeric, and logical operators. For example, the Calculated Value property of the Full Name field that resides in the Contact business component includes the following value:

IIf (Language () = "JPN", [Last Name] + ' ' + [First Name],
[First Name] + ' ' + [Last Name])

This expression does the following:

  • If the active client language is Japanese, then create the Full Name from the Last Name, an empty space, and the First Name.
  • If the active client language is not Japanese, then create the Full Name from the First Name, an empty space, and the Last Name.

If you create a calculated field, then consider the following:

  • If Siebel CRM modifies the calculated value of a field, then it does not refresh this calculated field, by default. It only refreshes a calculated field after it commits the record. To refresh the field immediately after Siebel CRM modifies the value in this field, you can make sure the Immediate Post Changes property of this field contains a check mark.
  • A calculated field cannot reference itself in the Calculated Value property. For example, you cannot use Last Name in a calculation expression for the Last Name field.
  • If the Cache Data property of the business component contains a check mark, then Siebel CRM does not support a query on a calculated field in this business component.
  • You cannot use a script on a calculated field.

For more information, see Siebel Developer's Reference.

Configuring Siebel Business Applications Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.