Case insensitive SQL when calling the Query method on the EAI Siebel Adapter with search spec.
(Doc ID 535121.1)
Last updated on FEBRUARY 04, 2019
Applies to:Siebel System Software - Version 6.0.1  and later
Siebel CRM - Version 7.8.2 SIA  and later
Information in this document applies to any platform.
- have an integration object based upon the contact BC.
- use EAI Siebel Adapter to query the BC using this integration object to query the contact BC for a contact with a particular email address (using BC field Email Address).
- The workflow process property used as input argument is similar to the following:
SearchSpec, Literal, [Contact.HSBC Notes Email] = “USER1@MYCOMPANY.COM”
- CaseInsensitive = TRUE in the .cfg file and DSCaseInsensitiveFlg = True for the named subsystem ServerDataSrc.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!