My Oracle Support Banner

Case insensitive SQL when calling the Query method on the EAI Siebel Adapter with search spec. (Doc ID 535121.1)

Last updated on MARCH 01, 2018

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

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.