Bounded Dynamic Picklist Functionality
Last updated on MARCH 02, 2017
Applies to:Siebel Tools - Version 188.8.131.52 SIA  and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 184.108.40.206  Hospitality
Database: IBM DB2 7.2 FixPack 3sa
Application Server OS: Microsoft Windows 2000 Server SP 3
Database Server OS: IBM zOS
This document was previously published as Siebel SR 38-1165352001.
As soon as the user changes the opportunity status to Inactive, the Sales Stage should be null. If the status is “Active” then the Sales Stage will retain the current value unless the user changes the value in the field
A) A script in the Opportunity PreSetFieldValue
if(FieldName == "Status" && FieldValue =="Inactive")
But when we change the status from Active to Inactive in the application, gives an error message
"Wrong field values or value type detected in field Opportunity Status. Please re-enter your field values. If you need an additional assistance, please refer to the documentation(SBL-UIF-00299)
 Script Error occurred in procedure 'SetFieldValue' of object BusComp[Opportunity]"
B) Business Component User Prop
Business Component User Properties Name = On Field Update Set 22
Business Component User Properties Value = "Status","Sales Stage","IIF([Status]=LookupValue(""OPTY_STATUS"",""Inactive""), """",[Sales Stage])"
The application does not give any error but it does not satisfy the requirement.
In the Opportunity BC, Sales Stage is join field (NAME) with S_STG table. The Sales Stage field is associated to PickList Sales Stage which is bounded. Picklist Sales Stage is a dynamic picklist. Not able to set a null value in Sales Stage field.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms