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 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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.