Monday, April 3, 2017

Scheduling a concurrent program in Oracle apps.

Scheduling a concurrent program in oracle apps:

In my previous article you have seen how to schedule a concurrent program from back end, now let us see how to schedule a concurrent program through oracle application.

You might be having couple of requirement where you want to run the report daily, weekly, monthly or on specific day at specific time.
For example: In finance company they want to run GL daily rate report every day midnight at 01:00 AM or other reports like 'Invoice hold report' run on specific days at specific time so every time submitting concurrent program is not possible manually. So Oracle introduced scheduling feature where users can schedule concurrent program as per their need.

Before we step in how to schedule a concurrent program, let us see what are the different scheduling features we have,
  1. Once
  2. Periodical
  3. On specific day
  4. Advanced (majorly not used)
Let us see how to schedule a concurrent program for ONCE:
Nav: Go to desired responsibility --> View --> request click on submit request and click on single request




 Now enter the concurrent program name, parameters and click on schedule button

 under run the job.. click on Once and enter the run time as per your requirement 



Now click on submit button



In the below screen shot you can see the program status has scheduled and phase as pending. on specific time it will change the status to running.



 Now on time the program has scheduled


Now the program completed sucessfully



  •  Periodical Schedule:

 Now under run the job.. click on 'Periodically' and enter the run time as per your requirement



 Now click on ok and submit the request




 Now on time the program has scheduled
 



 As soon as it completes the program a new program has schedule after a minute
 


Now on time the program has scheduled
 

 you can see both the programs had completed successfully




  • On Specific Days Schedule:
Now under run the job.. click on 'On Specific Days' and enter the run time as per your requirement.
But for the below request it run on 3rd, 5th and last day of the month.
 
 
click on Ok and submit the request.


Program has submitted as per the scheduled time.
 

 Now the next program has scheduled with status as scheduled to check the schedule time click on 'schedule'

 if you see the requested start date next schedule is on 5th.


In these way we can schedule the concurrent programs according to your requirements.


4 comments:

  1. We are really grateful for your blog post. You will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work. Technical Action Group IT Solutions

    ReplyDelete
  2. We need to Schedule a Program for Every 4 hours in every 5 days (Not on Friday & Saturday) of the week. how can i do it?

    ReplyDelete
  3. We are really grateful for your blog post. You will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work.
    https://www.technicalactiongroup.ca/

    ReplyDelete
  4. I wish to show thanks to you just for bailing me out of this particular trouble. As a result of checking through the net and meeting techniques that were not productive, Same as your blog I found another one Oracle Fusion Financials.Actually I was looking for the same information on internet for Oracle Fusion Financials and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.

    ReplyDelete