Oracle error
ORA-01861
ORA-01861: literal does not match format string
What usually causes it
A date string didn't match the format Oracle expected, usually the session's NLS_DATE_FORMAT.
What to check first
Use TO_DATE with an explicit format mask instead of relying on NLS settings.