Search spec comparing Single and Multi value fields
Last updated on JULY 12, 2017
Applies to:Siebel Tools - Version 184.108.40.206 SIA  and later
z*OBSOLETE: Microsoft Windows 2000
Desired functionality is to only pick products that correspond to a calculated field for a Product Line/Agreement Type.
If the Calculated (Single value) Field ‘LE Agreement Type’ for instance has the value 'Telephone', we want to be able to pick all the products that are part of the Product Line 'Telephone'. The problem is that the products that are listed are only those that have this Product Line as Primary. But one also want to be able to pick products that belongs to this Product Line but that have other Product Lines as Primary. Is there any thing one can do with the Search Spec on the Picklist or do we need a total different approach here?
Search Spec on PickList Internal Product:
((([Product Line] = [LE Agreement Type]) OR ([LE Agreement Type] IS NULL)) AND (Sales Product Flag <> 'N'))
ps: Tried to apply EXISTS on the Search Spec but retrieves an error message because the Calculated field is a Single Value field
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms