Oracle : 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
update FND_CONCURRENT_REQUESTS set phase_code='C',status_code='D' where phase_code='P' ;