My Oracle Support Banner

How to query date fields in EAI / Inbound web services requests? (Doc ID 1584058.1)

Last updated on DECEMBER 11, 2019

Applies to:

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


For an inbound webservice e.g OrderDetailWebservice, method OrderDetailQueryPage, the requirement is to query all Orders created from "07/20/2013" to "07/29/2013".

We tried various searchspec it throws errors .

Error 1 :The value '2013/07/23 08:18:00' cannot be converted to a date time value.(SBL-DAT-00359)"(SBL-EAI-04376)


Error 2: An invalid assignment error has occurred. Please try again or ask your systems administrator to check your application configuration if the problem persists.(SBL-DAT-00421)"

How to query records using date fields in web services requests?


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.