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
Siebel CRM - Version 220.127.116.11  and later Information in this document applies to any platform.
Environment: ------------------- Product Type: Siebel CRM Version: 18.104.22.168  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)