SQL Errors "Invalid date. (180,112) - While running AE on process scheduler
This is an intermittent error. The same AE that fails works fine the other days.
We need your help -
Q1 - Doc ID 2483285.1 says "#1. All PSAESRV processes when start, it create a permanent primary db session with below SQL to set the date
format to PS standard by default, e.g. YYYY-MM-DD
ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD';"
How can we verify that this alter is happening everytime the AE is run? We applied the trace but cant see this alter.
Q2. Doc ID 2792831.1 talks about altering the date at session level and then restarting process scheduler domain. How will that help? As soon as you would exit the oracle session to start process scheduler domain, the session level alter will be gone.