My Oracle Support Banner

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

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.