Does anybody dealer with ORA-01861 error with date?

Does anybody dealer with ORA-01861 error with date?

I'm trying to export data to a table in Zoho Reports using Zoho Upload Tool. I can successfully run the query and get the results in Oracle (using TO_DATE conversion for text fields with date value), but using the exactly same query in database_sql_queries.xml gives me the following error when I run the UploadFromDB.bat:

java.sql.SQLException: ORA-01861: o literal não corresponde à string de formato
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
at oracle.jdbc.driver.T4CStatement.fetch(T4CStatement.java:620)
at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:258)
at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:193)
at com.adventnet.zoho.client.report.advancedtool.SqlUploader.fetchDbAndWriteCsv(SqlUploader.java:82)
at com.adventnet.zoho.client.report.advancedtool.WriterThread.run(WriterThread.java:47)

Has anyone issued this?