To cancel particular concurrent program

update
apps.fnd_concurrent_requests
set
phase_code = ‘X’,
status_code = ‘C’
where
request_id in (select REQUEST_ID
from
apps.fnd_concurrent_worker_requests
where phase_code=’P’ and hold_flag!=’Y’ and USER_CONCURRENT_PROGRAM_NAME=’&a’
and requested_start_date

  • April 20, 2017 | 12 views
  • Comments