Oracle Ebusiness suite Cancel All Pending Concurrent Request
Cancel All Pending Concurrent Request
Updating base tables directly is not supported or recommended by Oracle – this update would be OK to execute in a non-production instance. In a production instance, use APIs or cancel the pending requests thru the forms interface
connect apps user and run the below command
SQL> update FND_CONCURRENT_REQUESTS set phase_code='C',status_code='D' where phase_code='P' ;
251 rows updated.
SQL>
SQL> commit;
Commit complete.
SQL>
