Issue: One of the concurrent request was running for 10 hours which will complete in less time usually. And there were number of child requests are submitted along with the parent request.

  So, we tried to dig the issue in all our conventional methods like blocking locks, parameters comparision, trace& tkprof and gatherstats. But, everything was looking good. And finally, I came to know that, it was the issue with the number of  workers that was assigned to that manager needs to be increased. So, modified the number from from 15 to 25 to avoid the issue and found that it was occuring after every clone.So, added to post-clone steps.

Below is the navigation patch:

 

Login to Oracle Applications as sysadmin

Go to

system administrator ->

Concurrent Manager -> Define -> press F11 --> type MRP Manager -> press ctrl + F11

And then click on Work Shifts -> here modify number of Processes from 15 to 25 and then save it. Verify again once after closing the form.

Thanks

Satya