Home » Oracle » How to change Priority for Concurrent Program

How to change Priority for Concurrent Program

Many times in Oracle Apps env,user  complain there request get stuck or takes time to start processing. Majority of time Support team can’t do anything, unless waiting or asking Oracle 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 priority,then you can change the Priority for Concurrent Program or user or request to get it resolved

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.

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

The steps are very simple  to set Priority for Concurrent Program

  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. “Check writer”
  3. On this screen you can set priority of this request by entering value in “Priority” field(1 is highest, 99 is lowest, 50 is the default) , Save and exit.
See also  forward cross edition triggers in R12.2

3) If you want to set priority for a particular concurrent request

By changing the priority of concurrent requests you can run the important concurrent request before the non-priority concurrent requests.
1. Open “System Administrator” responsibility. Go to Concurrent > Requests
2. Select “Specific Requests”. In the field called “Requester” put the User ID for whom you want to change the priority.
3. Select “View Details”. Change the Priority from the default “50”. Change it to “10” for high priority. [1 for highest and 99 for lowest].

If there are multiple requests, you can use sql  and change the priority using the update on the FND_CONCURRENT_REQUEST table

 It is advisable to go with the program instead of setting it as User level,This way you can execute the critical program submit by any user processed faster

Related Articles
Concurrent Manager Queries: This article contains awesome top 30 Concurrent Manager Queries for Concurrent Manager troubleshooting, resolution, run time, details
ORA-01427: Check out this for the solution on ORA-01427: single-row subquery returns more than one-row error, how to resolve it when it happens with Concurrent Manager
request set in oracle apps: Request set gives the capability to submit the same set of requests regularly using a single transaction.
Concurrent Manager Interview questions: Check out 24 Concurrent Manager Interview questions to help you in the EBS interview. This consists of all sorts of questions on the standard manager, service manager
Parallel Concurrent Processing: What is PCP, How to setup it, how to define internal monitor
Oracle Concurrent Manager: How an E-Business Suite Concurrent Manager Process Works, Oracle Concurrent Manager, What is internal monitor, What is the service manager and troubleshooting

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top