My Oracle Support Banner

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.


On : 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'.


To view full details, 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 a vibrant support community of peers and Oracle experts.