Siebel Open UI, Tools, Scripting and EAI (MOSC)

MOSC Banner

On Update Field - IIF Function

edited Dec 11, 2011 11:29PM in Siebel Open UI, Tools, Scripting and EAI (MOSC) 1 commentAnswered
Hi there,

I have added the 'On Field Update Set' user property in Opportunity BC with following definition:

Name: On Field Update Set 36
Value: "Sales Stage", "Opportunity Status",
"IIF (Left([Sales Stage], 1) < ""3"", LookupValue(""REASON_WON_LOST"",""Active""),
IIF (Left([Sales Stage], 1) = ""3"", LookupValue(""REASON_WON_LOST"",""Won""),
IIF (Left([Sales Stage], 1) = ""4"", LookupValue(""REASON_WON_LOST"",""Lost""))))"

But it seems that it is not working.
Can anybody please tell me if anything is wrong in the above definition and what should be the cause why it isn't working?

Is it possible that three options are not supported?

Many thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center