Case insensitive SQL when calling the Query method on the EAI Siebel Adapter with search spec.

(Doc ID 535121.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel System Software - Version 6.0.1 [2848] and later
Siebel CRM - Version 7.8.2 SIA [19213] and later
Information in this document applies to any platform.

Symptoms

SearchSpec, Literal, [Contact.HSBC Notes Email] = “USER1@MYCOMPANY.COM”

However, when the workflow was executed using the Simulator or the Workflow Process Manager the generated select statement was case sensitive and the contact was not returned. When the same query was executed in the UI the contact was found.

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