My Oracle Support Banner

Bounded Dynamic Picklist Functionality (Doc ID 505191.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version SIA [16161] and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: [16161] 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
Initial Analysis

A) A script in the Opportunity  PreSetFieldValue

if(FieldName == "Status" && FieldValue =="Inactive")
        this.SetFieldValue("Sales Stage","");

But when we change the status from Active to Inactive in the application, gives an error message
"[1]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)
[2] 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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.