Priority for Concurrent Program

Posted on September 29th, 2010 by Sanjit Anand | Print This Post | Email This Post

If you are working in big user environment, user always complain there request get stuck or takes time to start processing. Majority of time Support team cann't do anything, unless waiting or asking DBA to check the server performance.

There is couple of option you can try , if you know a demanding user and there request name( Concurrent Program) he/she always want in periority.

Options 1: If you know what particular program user required in priority.

In oracle EBS you need to set the priority of specific users so that when they run specific reports, those reports should be run on high priority. The steps are very simple:

1. Go to Sysadmin Responsibility and go to menu Profile > System.
2. Make sure Site and User boxes are checked.
3. Select the user name for the user for whom you want to increase the priority
4. Enter the following within the Profile box and click on Find: Concurrent:Request Priority
5. Change the priority for the user as you see fit (1 is highest, 99 is lowest, 50 is the default) , Save and exit.

Options 2: You know the Program name, and want to make execution in priority

The steps are very simple:

1. Login system administrator /Application developer and go to define concurrent screen
   Under Concurrent >> Program >> Define
2. Find the Program name whose priority you wish to change for ex. "Payable Transfer to GL"
3. On this screen you can set priority of this request by entering value in "Priority" field( as mark in red) (1 is highest, 99 is lowest, 50 is the default) , Save and exit.

Oracle definition for Priority

Priority is used to indicate the priority that the concurrent request will be assigned when it is submitted. If you do not assign a priority, the user's profile option Concurrent:Priority sets the request's priority at submission.

Profile : Concurrent:Request Priority

This displays the default priority number for your concurrent requests. Only a system administrator can change your request priority.

Requests normally run according to start time, on a "first-submitted, first-run" basis. Priority overrides request start time. A higher priority request starts before an earlier request.

Priorities range from 1 (highest) to 99 (lowest). The standard default is 50.

Users can see this profile option, but they cannot update it. This profile option is visible and updatable at all four levels.

1. Beginner’s Guide : Administering Concurrent Program – Part – II
2. Beginner’s Guide : Concurrent program/Manager output and log file- Part – IV
3. Oracle API Availability – Concurrent Program
4. 4 Steps for Host based concurrent program
5. Concurrent: Report Access Level and R12