I was trying to debug an an ORA-01843 Not a Valid Month error that has happened for some users in our app when I stumbled upon the following in the debug trace and am wondering if it has anything to do with a date format error we're getting on that page.
I've tried to simulate various conditions to try and recreate the error in my own session but have failed. Also the default application date format is MM/DD/YYYY and that's how all the dates are formatted on that page.
So I'm wondering if the debug trace shown below might have something to do with it. [[username]] and [[workspace Id]] are substitutions for the actual values. The errors happened around 4:30PM EST on 12/16/2016 and the "cannot assign file" message timestamps start at 16-DEC-16 04.41.45.833703 PM -05:00, if this is at all relevant.
Note
| 0.38964 | 0.00002 | Cookies: LOGIN_USERNAME_COOKIE=[[username]]; fullcalendar_defaultView=month; fc_year=2016; fc_month=11; fc_date=11 | 9 | 13% |
| 0.38966 | 0.00015 | could not assign file "" to workspace "[[workspace Id]]" | 1 | 101 |
| 0.38981 | - | could not assign file "" to workspace "workspace Id]]" | |