Search Specification Containing IIf() Causes SBL-DAT-00479: CSSString doesn't support operator "OR"

(Doc ID 1265610.1)

Last updated on NOVEMBER 20, 2017

Applies to:

Siebel CRM - Version [20426] and later
Information in this document applies to any platform.
*** Checked for currency on 25 June, 2015 ***


A custom applet search specification causes an error in Fix Pack although it worked without problems in Fix Pack

Error Messages:
SBL-DAT-00479: CSSString doesn't support operator 'OR'

By following these steps the issue can be reproduced:

  1. Include the search specification

    IIf([Type] <> "Chain", IIf(GetProfileAttr ("Org.Country") IS NOT NULL, [Country] = GetProfileAttr ("Org.Country"),[Type] <> "Chain"), "") OR [Type] = "Chain"

    in the Affiliated Account Form List Applet or any other applet.
  2. Make sure there is a record under the applet with the Type value as "Chain".
  3. Try to do an empty query on the applet.


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