Its not recommended to update fnd_concurrent_requests(any table) from the back-end
However can you share more details. Whats the status of the request ..its already cancelled status (completed/error) . That you wanted to run again by updating from the back-end.?
Absolutely not. Use the API.
declare message varchar2(4000); a boolean; begin a := fnd_concurrent.cancel_request(:request_id, message); dbms_output.put_line(message); end;
If you have 100 requests, obviously just loop through the jobs, calling the above API for each.
I cancel the request without error. Yes. I want to resubmit it by updating backend. But if this is not recommend by using method, I will submit it one by one.
This is too hard for me to do API. Thanks.
Sorry, I may have misunderstood your previous message - I thought you wanted to cancel requests, but what you are saying is you want to re-submit concurrent requests that have already been cancelled? If so, then I certainly wouldn't recommend doing back-end updates.
You shouldn't but if you are curious...try it for fun. Try it in a non-PROD environment that you can delete and see what happens. NEVER do this in PROD even if it works....