How to schedule Concurrent Program/Request in Oracle Apps

Oracle apps provide built-in functionality to schedule concurrent programs so that they run at specified times and intervals. This leads to effective utilisation of hardware, software, and human resources.

Concurrent Program is one of the most important functionalities available in Oracle Apps. It allows users to submit jobs parallelly. These programs run in the background and asynchronous manner. You can submit multiple instances of the same program. A concurrent manager controls and manages the running of all these programs.

This is the way users interact with concurrent programs.

User submits concurrent program. The concurrent manager picks this program depending on the existing load and available resources and executes it. User views log and output post completion of the program.

What if the program is a big report which takes a lot of time and consumes more resource. This impacts other users and the overall Oracle ERP production environment. So, it is always better to run such programs when there is less load on the system e.g. during late night or early morning.

But, who is going to wait until the late night to submit the program? What if you can tell Oracle Apps to schedule a run of the program at midnight or early morning.

In this article, let’s see how to schedule a concurrent program in Oracle Apps. This is built-in scheduling available in Oracle Apps. There are many third-party tools available to achieve complex scheduling requirement like UC4 / Appworx – Automation Platform, Cisco/Tidal – Tidal, Control-M, etc

I am going to use the Gather Schema Statistics program for demonstration. You can use any of standard or custom concurrent program.

How to Schedule Concurrent Program in Oracle Apps

The scheduling option is available when you submit a concurrent program. Navigate to respective responsibilities and open the SRS form.

In this case, navigate to System Administrator->View->Requests->Submit a New Request->Single Request and select Gather Schema Statistics program.

submit-and-schedule-concurrent-program

The default scheduling option is As soon as Possible. Click on the Schedule button to change it. This opens a window showing different schedule options.

Scheduling Options

Orale Apps provide different scheduling options like As Soon as Possible, Once, Periodically, On Specific Days, and Advanced.

scheduling-options

As soon as possible – This is the default option. As the name suggests, the concurrent manager starts it as soon as it has a necessary resource available like a concurrent process.

Once – This scheduling option allows you to submit the program on a specific date and time

once-scheduling-option

Click on Run at a box to open a calendar. Choose the date and time when the program should run. You can use the arrow to change month and year. Mention date in 12 hours format with AM and PM option and click OK.

Periodically – This option allows you to schedule a concurrent program for the specific interval.

periodically-scheduling-option

Starts At – Select when the schedule starts.

End At – Select date and time when schedule ends. Leaving it blank makes the schedule run indefinite duration, till it canceled.

Re-run every – Specify the re-run interval. options available are month(s) , Week(s) , Day(s), Hour(s) and Minute(s).

e.g Re-Run Every 1 Day(s) – this program runs each day at the specified time.

Apply the Interval…

When next scheduled instance of the program should run.

  • From the start of the prior run – Next scheduled instance run from the start of the prior run.
  • From the completion of the prior run – Next scheduled instance run from the completion of the prior run.

Increment date parameter each run – This is applicable when the concurrent program has a current date parameter. When it enables the date parameter is modified to show the current date.

Recalculate parameters – This recalculates the program parameter which are default values using SQL statement and other functions.

On Specific Days – You can specify date Dates of Every month of Days of Every week the program should run

on-specific-days-scheduling-option

Apply a Saved Schedule – Click this button to select the exiting saved schedule. It opens a LOV showing all saved schedules.

pre-defined-schedules

Select the one which you want and click on OK. This copies that schedule to the current concurrent program as shown below.

apply-saved-schedule

Save this schedule – Select this check box to save the schedule with a user-defined name. This is helpful if you want to reuse the same schedule for different concurrent programs.

Select the option you want and click on the OK button. This submits the concurrent program. The program stays in Pending Scheduled state till the scheduled time is reached.

scheduled-program

A new request(Pending Scheduled ) is submitted post completion of the prior request.

scheduled-request-completed

How to Modify or Cancel Schedule?

Modify Schedule

Select the scheduled concurrent request (35353537) and click on the View Details… button. It opens Submit Request window. Click on the Schedule button and select the new schedule as per requirement.

Cancel Schedule

If you have mentioned the end date while defining the schedule, it ends at that specified time. In case end date is blank and you want to cancel the schedule, just query the request and click on Cancel Request button. This cancels the current request and all future schedule requests.

I hope this article covers all aspect of concurrent program scheduling and you liked it. Please do subscribe and share.