Bounded Dynamic Picklist Functionality (Doc ID 505191.1)

Last updated on MARCH 02, 2017

Applies to:

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


Symptoms

 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


BusComp_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.


Findings:


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.

Cause

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