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

[vigneshn9321496]

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

[florentlb]

Hi Vignesh,

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

Florent

[vigneshn9321496]

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