How to schedule concurrent program

I share my Oracle knowledge through this blog. All my posts in this blog are based on my experience, reading oracle websites, books, forums and other blogs.

I invite people to read and suggest ways to improve this blog. Labels: SQL Scripts. Unknown September 21, at AM. Does this functionality exist? Appreciate your help in advance Thanks SR. Hi, I created a temporary table with two date columns. I am passing the date parameter values from these table to the scheduled concurrent program. The same Date Parameter is getting repeated for each run. Even if the table is updated with a new value the scheduled program is not fetching the recent date from the table.

How to dynamically pass the date parameter values to the scheduled concurrent program? When you create your concurrent set you can attached parameters to each request within it. Edit you request parameters within the set to automatically insert the dates you require. Hi, Why do you want to schedule the AP accounting for one particular month only? This way, it will create accounting for all the pending transactions to be accounted, irrespective of the month.

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. 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. This is built-in scheduling available in Oracle Apps. I am going to use the Gather Schema Statistics program for demonstration. You can use any of standard or custom concurrent program.

The scheduling option is available when you submit a concurrent program. Navigate to respective responsibilities and open the SRS form. 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.

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.

Click on Run at a box to open a calendar. At any point of time, if you need to change the schedule, you can select the scheduled request and click on View Details button. Then click on Schedule button. Here you can change the schedule as per your wish.

If you wish to cancel a scheduled request, select the request in the Requests window and click on Cancel Request in Requests window. This will prevent the program from running. If you see the below screenshot, status is cancelled. Previous post. Next post.