My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.