Error Message :
ORA-20999: General Failure "schedule start from date is null"
After upgrading from version 8.x.x to version 9.x.x, FORECAST Job fails with an error similar to the following:
Root Cause: Since version 8.0.x, the 'Reschedule From” date value for Weekly and Monthly Schedules is a required field. This error indicates that there are these types of schedules without the 'Reschedule From” date value
OS Version: N/A
Use the below sql to find Schedules without a 'Reschedule from date" value. For each result, edit the Schedule and add a 'Reschedule from date' value.
select so_module, aw_sch_name, aw_sch_start, aw_sch_frm_date, aw_sch_units from aw_module_sched, so_job_table
where aw_job_seq=so_job_seq and aw_sch_units in (-1, -2) and aw_sch_frm_date is null;
Fix Status: No Fix