Oracle Waveset Forensic Query With Date Range Gives Oracle Database Error ORA-01861: Literal Does Not Match Format String

(Doc ID 1605288.1)

Last updated on OCTOBER 19, 2016

Applies to:

Oracle Waveset - Version 8.1.1 and later
Information in this document applies to any platform.

Goal

If the Data Exporter is configured with the warehouse in an Oracle Database, then each Forensic Query specifying a date range does throw an Oracle Database error:

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