Queries In Multi-valued Fields 'MVG Format Id' Require The Term 'EXISTS' Within Your Query Criterion
Last updated on MAY 04, 2017
Applies to:Siebel CRM - Version 8.0 SIA  and later
Information in this document applies to any platform.
""CHECKED FOR RELEVANCE ON 05-May-2017""
On : 220.127.116.11 SIA  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'.
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