My Oracle Support Banner

EAI Siebel Adapter Generates Incorrect Select Statement When User Key Field value Includes \ Followed By *. (Doc ID 1962762.1)

Last updated on MARCH 01, 2018

Applies to:

Siebel CRM - Version [23012] and later
Information in this document applies to any platform.


Product Type: Siebel CRM
Version: [23012]
OS platform: Microsoft Windows Itanium (64-bit)
DB: Oracle Database - Enterprise Edition
Env type: Test

Statement of Issue:
An external application puts a message on a JMS queue that includes a XML document that includes a service request that exists in the Siebel database. A JMS Receiver task picks up the message ans passes it to a workflow. The XML document is converted into a SiebelMessage and passed to the Execute method on the EAI Siebel Adapter, which should update the existing service request. SR Number is used as the user key. The problem is that the SR Number includes a backslash (GM_GC7UHRD&\$+5R;*). As a result, when the EAI Siebel Adapter generates a select statement to retrieve the existing service request, the backslash is being escaped by another backslash:

  (T30.SR_NUM = :2 AND T30.BU_ID = :3)

19:13:18 Bind variable 1: WfProcMgr_EP,S2,28311590,SADMIN,0003108f54790e74:0,,Service Request EAI CARMEN,
19:13:18 Bind variable 2: GM_GC7UHRD&\\$+5R;*
19:13:18 Bind variable 3: 1-2N0H

As a result, the existing service request isn’t returned and an error occurs because the update can’t be carried out.

Expected Behavior:
The existing service request is found and updated.

Actual Behavior:
The existing service request isn’t found and isn’t updated.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.