Queries In Multi-valued Fields 'MVG Format Id' Require The Term 'EXISTS' Within Your Query Criterion (Doc ID 1572964.1)

Last updated on MAY 04, 2017

Applies to:

Siebel CRM - Version 8.0 SIA [20405] and later
Information in this document applies to any platform.
""CHECKED FOR RELEVANCE ON 05-May-2017""

Symptoms

On : 7.8.2.16 SIA [19255] version, Configuration - General

When attempting to use the search spec "NOT EXISTS([MVG Promotion Id]=[Promotion Id Calc])"in BC no error occur but when EXISTS([WHV MVG Format Code Id] =[Code Id])" is added,why
the following error occurs - SBL-DAT-00508: Exists search not necessary for search on non-multi-valued field 'Format Code Id'.



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