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 NOVEMBER 22, 2019

Applies to:

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


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" >
    <CommitTime>IS NOT NULL</CommitTime>

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)



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.