Forgot your password?    
+ Reply to Thread
Results 1 to 3 of 3

Thread: To Put a Concurrent Request on Hold

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427

    To Put a Concurrent Request on Hold

    How to Put a Concurrent Request on Hold
    Update 'hold_flag' in FND_CONCURRENT_REQUESTS

    Log in to sqlplus as 'apps' user and execute:

    To hold:

    SQL> update fnd_concurrent_requests
    set hold_flag='Y' where Phase_code='P' and status_code='I';

    SQL> commit;

    To release:
    SQL> update fnd_concurrent_requests
    set hold_flag='N' where Phase_code='P' and status_code='I';

    SQL> commit;


    Alternatively , Individual Concurrent Requests can be put on hold from the front End , from the Concurrent Requests Screen.

  2. #2
    Oracle Administrator
    Join Date
    Apr 2012
    Posts
    53
    I submitted a concurrent request.It was running fine and it takes just 5 minutes to finish..Bt today its taking 1hr bt still its not yet been finished.Then how do you troubleshoot?

    Plz explain all the possibilites...

  3. #3
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    How to proceed to Troubleshoot a slow running concurrent request is already given in a seperate thread.

+ Reply to Thread

Similar Threads

  1. priority for concurrent request set
    By Amit in forum Concurrent Processing Server / Workflow
    Replies: 1
    Last Post: 10-16-2012, 09:57 PM
  2. Concurrent request help needed
    By saioracleappsdba in forum Concurrent Processing Server / Workflow
    Replies: 1
    Last Post: 06-15-2012, 04:38 AM
  3. Active users Concurrent Request
    By yogeshsaraswat in forum Concurrent Processing Server / Workflow
    Replies: 0
    Last Post: 11-21-2011, 12:19 AM
  4. Retrieving Concurrent Request Id from the Session SID
    By Hemant in forum SCRIPTS : Concurrent Requests & Concurrent Request Sessions
    Replies: 0
    Last Post: 10-31-2011, 10:07 PM
  5. Manager that ran a Concurrent Request
    By Hemant in forum SCRIPTS : Concurrent Requests & Concurrent Request Sessions
    Replies: 0
    Last Post: 10-31-2011, 08:27 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics