Next Run Date is not calculated in a Calendar Schedule using a new Calendar without clicking on the Calculate button

Document ID : KB000084991
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
N/A

In Applications Manager (AM) version 9, the default Schedule end dates were extended from 12-31-2020 to 12-31-2040.  

However, if you upgrade from version 8.0 to version 9, any non-default Calendar Schedules that were created in AM 8 with a Scheduled end date of 12-31-2020 are not automatically updated when a new date is entered into the Calendar.  

The only way the next run date can be updated is by clicking on the Calculate button within the Schedule or by changing the Schedule end date to 2040.

 
Environment:
OS Version: N/A
Cause:
Cause type:
Defect
Root Cause: Only default AM schedules were changed to have a Scheduled end date of 12-31-2040. All other schedules created in AM8 with an end date of 12-31-2020 were not changed so are not updating correctly without calculating them first.
Resolution:
Update to a fix version listed below or a newer version if available.

 

Fix Status: Released

Fix Version(s):
Applications Manager 9.2.0 - Available
Applications Manager 9.1.2 - Available
Additional Information:
Workaround :
Update the schedule end dates via SQLPlus.

Log in as the Applications Manager Oracle user and run the following statement: 
 
update aw_module_sched set aw_sch_end=to_date ('31-DEC-2040', 'DD-MON-YYYY') where trunc( aw_sch_end)=to_date ('31-DEC-2020', 'DD-MON-YYYY'); commit;