How to Query for IS NOT NULL on Date Field in EAI Siebel Adapter / Query

(Doc ID 2085489.1)

Last updated on MARCH 01, 2018

Applies to:

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

Goal

When using EAI Siebel Adapter to query with an input SiebelMessage, and trying to query for a date field with 'IS NOT NULL', an error occurs.  For example, an input SiebelMessage :-

<?xml version="1.0" encoding="UTF-8"?>
<SiebelMessage MessageId="1-1JV5" IntObjectName="Service Request" MessageType="Integration Object" IntObjectFormat="Siebel Hierarchical" >
<ListOfWc_Service_Request_Io>
  <ServiceRequest>
    <SRNumber>1-1856251</SRNumber>
    <CommitTime>IS NOT NULL</CommitTime>
  </ServiceRequest>
</ListOfWc_Service_Request_Io>
</SiebelMessage>

An error is reported :-

Error invoking service 'EAI Siebel Adapter', method 'Query' at step 'Business Service 0'.(SBL-BPR-00162) -- Method 'Execute' of business component 'Service Request' (integration component 'Service Request') returned the following error:
"The value 'IS NOT NULL' cannot be converted to a date time value.(SBL-DAT-00359)"(SBL-EAI-04376)

 

Solution

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