EAI Siebel Adapter Query Generates IN Operator When Searchspec Includes UTCDATETIME. (Doc ID 2066142.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Financial Services CRM - Version 8.1.1.11.15 [IP2013] and later
Information in this document applies to any platform.

Symptoms

Environment:
-------------------
Product Type: Siebel Financial Services CRM
Version: 8.1.1.11.15 [IP2013]
OS platform: Microsoft Windows (32-bit)
DB: N/S
Env type: Dev

Statement of Issue:
-----------------------------
Assets are queried using the bus comp Asset Mgmt - Asset and the following search criteria:

[Install Date] = ""09/15/2015"" or [Install Date} = ""09/16/2015""

When executed in the UI, the following ranges are included in the select statement criteria generated by Siebel:

((T23.INSTALL_DT >= 09/14/2015 16:00:00 AND T23.INSTALL_DT <= 09/15/2015 15:59:59) OR (T23.INSTALL_DT >= 09/15/2015 16:00:00 AND T23.INSTALL_DT <= 09/16/2015 15:59:59))

When executed using the QueryPage method on the EAI Siebel Adapter using the IO SWIAssetIO, the select statement criteria includes:

(T21.INSTALL_DT IN (09/14/2015 16:00:00, 09/15/2015 16:00:00))

Obviously, this produces a different result to the query executed in the UI.

If the search criteria includes 1 date (e.g. [Issue Date] = ""09/15/2015""), a date range is included in both cases:

((T21.INSTALL_DT >= 09/14/2015 16:00:00 AND T21.INSTALL_DT <= 09/15/2015 15:59:59))

Expected Behavior:
---------------------------
Ranges are included in the query executed using the EAI Siebel Adapter.

Actual Behavior:
-----------------------
Ranges are not included in the query executed using the EAI Siebel Adapter.

Business Impact:
-------------------------
The functionality is required by the end of October, when UAT starts.

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