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 laterInformation 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>
<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)
"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 |