Posts Tagged ‘Oracle’

LookupValue function in SIEBEL

Posted: Monday,November 8, 2010 in Siebel
Tags: , , ,


Finds a row in S_LST_OF_VAL where the TYPE column matches the type argument, the CODE column matches the lang_ind_code argument, and the LANG_ID column matches the language code of the currently active language. This function is used to obtain the translation of the specified untranslated value in the specified LOV into the currently active language.


val = TheApplication().InvokeMethod(“LookupValue”, type, lang_ind_cd)





Type as specified in the List of Values administration view.


Language independent code value as specified in the List of Values administration view.



Returns a string containing the display value (the VAL column) for the row.

Used With

COM Data Control, Java Data Bean, Mobile/Dedicated Web Client Automation Server, Server Script


The following eScript example returns the display value for currently active language for the account role of “Consultant”.

var LOVText=TheApplication().InvokeMethod (“LookupValue”,”ACCOUNT_ROLE”,”Consultant”);




Connect failed because target host or object does not exist
Cause: The address specified is not valid, or the program being connected to does not exist.
Action: Ensure the ADDRESS parameters have been entered correctly; the most likely incorrect parameter is the node name. Ensure that the executable for the server exists (perhaps “oracle” is missing.) If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the host name to a numeric IP address and try again.