How to Stop Concurrent Requests from Executing on New Cloned Environment

 If you do not want concurrent requests scheduled in Source to run on a newly cloned environment, Follow the below steps

1. Run “perl adcfgclone.pl appsTier” as normal.
Before starting the application services, run the below update commands


-Take Backup of fnd_concurrent_requests

create table  fnd_concurrent_requests_bkp as select * from fnd_concurrent_requests;

-Terminate ‘Running’ Requests

UPDATE fnd_concurrent_requests
SET phase_code = ‘C’, status_code = ‘X’
WHERE status_code =’R’
OR phase_code = ‘R’
/

-Set Pending jobs to ‘On Hold’

UPDATE fnd_concurrent_requests
SET hold_flag = ‘Y’
WHERE phase_code = ‘P’
AND status_code in (‘Q’,’I’)
/

13 thoughts on “How to Stop Concurrent Requests from Executing on New Cloned Environment”

  1. It’s an awesome article designed for all the online viewers; they will obtain benefit from it I
    am sure.

    Also visit my site :: Vpn

  2. Excellent goods from you, man. I have understand your stuff previous to and you are just
    too excellent. I actually like what you’ve acquired here, really like what you’re stating and
    the way in which you say it. You make it entertaining and you
    still care for to keep it sensible. I cant wait
    to read far more from you. This is actually a tremendous site.

    gamefly 3 month free trial https://tinyurl.com/235hnz7u

  3. I’ve been exploring for a little bit for any high quality articles or
    weblog posts on this kind of house . Exploring in Yahoo
    I ultimately stumbled upon this website. Studying this info So i’m glad to
    express that I have a very just right uncanny feeling I discovered exactly what I needed.
    I so much unquestionably will make certain to do not put out of your mind this web site and give it a look regularly.

  4. That is a great tip particularly to those new to the blogosphere.
    Short but very precise information… Thanks for sharing this one.

    A must read post!

Leave a Reply

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