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

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

Environment:
-------------------
Product Type: Siebel CRM
Version: 8.1.1.8 [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:

SELECT /*+ ALL_ROWS */
  T30.CONFLICT_ID,
  ...
  T3.ROW_ID,
  :1
  FROM
  ...
  SIEBEL.S_SRV_REQ T30
  WHERE
  ...
  (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.

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