To Cancel Request In Oracle Apps using SqlPlus Command run the below Query :
Update Fnd_Concurrent_Requests
SET Phase_Code = ‘C’,
Status_Code = ‘E’
Where Request_ID = ;
Or you can Replace Retest_id with CONCURRENT_PROGRAM_ID.
Thank you
Osama Mustafa