How to query date fields in EAI / Inbound web services requests?

(Doc ID 1584058.1)

Last updated on MARCH 02, 2017

Applies to:

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

Goal

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?

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