My Oracle Support Banner

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

Last updated on JULY 12, 2017

Applies to:

Siebel Tools - Version SIA [16168] 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




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.