Concurrent Program/Request Scheduling in Oracle Apps – Guide

Concurrent Program is one of the most important functionality available in Oracle Apps. It allows users to submit job 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 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 existing load and available resource 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 overall Oracle ERP production environment. So, it is always better to run such programs when there is less load on system e.g. during late night or early morning.

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

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

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 PlatformCisco/Tidal – TidalControl-M, etc

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

How to Schedule Concurrent Program in Oracle Apps

Scheduling option is available when you submit concurrent program. Navigate to respective responsibility and open 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

Default scheduling option is As soon as Possible. Click on 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 concurrent process.

Once – This scheduling option allows you to submit the program on 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 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 exiting saved schedule. It opens an LOV showing all saved schedule.

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 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 OK button. This submits the concurrent program. The program stays in Pending Scheduled state till 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 View Details… button. It opens Submit Request window. Click on Schedule button and select new schedule as per requirement.

Cancel Schedule 

If you have mentioned 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 schedules requests.

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

Related Post