My Oracle Support Banner

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

Last updated on NOVEMBER 22, 2019

Applies to:

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


Product Type: Siebel Financial Services CRM
Version: [IP2013]
OS platform: Microsoft Windows (32-bit)
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.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.