My Oracle Support Banner

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

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
Goal
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.