Clarity on Oracle throws ORA-01861: literal does not match format string in app-ca.log on any actions in UI that involve dates (such as filters, power filters etc.)
System error in UI will happen when filtering on portlets including dates, or running jobs including dates.
For example, if you filter for a timesheet in a prior or current time period, you see "System Error. Contact system administrator."
When looking in the app-ca log or bg-ca.log for jobs, error message is thrown:
ORA-01861: literal does not match format string
NLS_DATE_FORMAT should be set correctly on the database schema level.
Release: Any Supported Release
If the issue is only with NLS_DATE_FORMAT, to resolve this, try one of the following solutions:
Basic reset of NLS_DATE_FORMAT:
1. Run the command:
alter system set nls_date_format='YYYY-MM-DD HH24:MI:SS' scope=spfile
2. Restart the database (the change requires a restart)
Advanced reset of NLS_DATE_FORMAT
0. create pfile from spfile;
1. Edit the pfile ora file and change this to
2. Then recreate the SPFILE.
- Edit the pfile
- Shutdown the instance
- Create spfile from pfile
- Startup the database
For additional comments here: Communities post