How To Use Timestamp() in SearchSpec for EAI Siebel Adapter Query From Workflow ?

(Doc ID 1177434.1)

Last updated on MARCH 01, 2018

Applies to:

Siebel Financial Services CRM - Version 7.8.2 SIA [19213] and later
Siebel CRM - Version 7.8.2 SIA [19213] and later
Information in this document applies to any platform.


Goal

A Workflow Process is used to invoke the EAI Siebel Adapter, Query method.

In the input arguments, when SearchSpec is applied as a Literal, expected results are returned :-

SearchSpec=[Account.Created] < '08/09/2009 00:00:00'

How can a query be provided (using Timestamp() function) to retrieve Accounts created over 365 days ago ?

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