Error Message :
ErrorMsg: AwE-9999 Internal error (8/6/15 11:59 PM)
Details: Invalid year value
This issue is specific to Applications Manager (AM) version 8.0x using Oracle 11g with a RA Banner Agent using 12c installed on the same machine as the Master.
When the AM database (DB) is Oracle 11g and the Banner DB is Oracle 12c and is located on the Master's server, you are required to replace the ojdbc14 driver for ojdbc6 to allow this configuration to work. One of the side affects of doing this is that the FORECAST job will appear to run successfully but will actually fail with an 'Invalid year value" error similar to this in the Master log:
ErrorMsg: AwE-9999 Internal error (8/6/15 11:59 PM)
Details: Invalid year value
aw_web_api.aw_prod_sched
0 start_date: IN:TIMESTAMP:java.sql.Timestamp:12-31-1969 18:00:00 CST
1 end_date: IN:TIMESTAMP:java.sql.Timestamp:08-17-292278994 01:12:55 CST
2 levels: IN:NUMERIC:java.lang.Integer:33
3 granularity: IN:VARCHAR2:java.lang.String:1
jdbc:oracle:thin:@appworx.home.edu:1521:AMPRD:APPWORX
ErrorMsg: AwE-9999 Internal error (8/6/15 11:59 PM)
Details: java.lang.IllegalArgumentException: Invalid year value
forecast cache thread This invalid year value error may also be seen when executing any job that uses our standard SQLP script while the ojdbc14 driver is in place and you are using AM v8.0x against Oracle 11g.