Expand my Community achievements bar.

ORA-210000 Oracle error: ORA-01878: specified field not found in datetime or interval

Avatar

Employee

Hi,

I have a query in my workflow and I am using an expression

DateOnly(@START_DATE) greater than or equal to DateOnly(DaysAgo(14)).

When the query runs, for a few records which fall on Daylight saving time shift, is throwing an error.

Tried to use ToDate(@START_DATE) as well, and still the same issue.

Can someone assist on how to get rid of this.

Thanks,

Vignesh

2 Replies

Avatar

Level 10

Hi Vignesh,

Can you psot a screenshot of your workflow or the activity throwing the error to check how it's configured?

Florent

Avatar

Employee

Hi Florent,

Issue was because of a few records which were present in the database which were in the Daylight saving time difference. Deleted those records and now the workflow runs fine without any issue.

Thanks,

Vignesh