Print      Open PDF Version of Online Help

Previous Topic

Next Topic


The LookupValue function in Expression Builder returns a specified picklist value that is translated into the currently active language.

Picklist values are stored in the List of Values table. The LookupValue function returns the value in the VAL column of a row where all of the following are true:

  • The TYPE column matches the type argument.
  • The CODE column matches the lang_ind_code argument.
  • The LANG_ID column matches the language code of the currently active language.

The LookupValue function allows Oracle CRM On Demand to evaluate expressions involving picklist values uniformly across locales. For example, the value White in English is evaluated in the same way as the value Blanc in French.

TIP: When specifying the parameters for the LookupValue function, click Show Acceptable Values to display the acceptable values for the field that you selected in the Fields list. (If a field is a picklist field, Show Acceptable Values displays all the options configured for that picklist. If a field is not a picklist field, Show Acceptable Values opens a window that describes the acceptable values for different data that the field can hold.)

NOTE: The Sales Stage field in opportunity records is not a true picklist field. The LookupValue function does not work on this field.


LookupValue (type, lang_ind_code)

Result Type



The following table describes the arguments for the function.




The type of the row to be searched for.


The untranslated value in the list of values.

Related Topics

See the following topics for related Expression Builder information:

Published 5/4/2012 Copyright © 2005, 2012, Oracle. All rights reserved. Legal Notices.