Search spec comparing Single and Multi value fields (Doc ID 546356.1)

Last updated on JULY 12, 2017

Applies to:

Siebel Tools - Version 7.5.3.2 SIA [16168] and later
z*OBSOLETE: Microsoft Windows 2000

Symptoms

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

Changes

 

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