How to update patch adwork process manually

Hi All,

Here the way to update patch adwork process manually when the process is stuck during the patch apply:

1. Update the worker status :
UPDATE applsys.fnd_install_processes
SET status = 'F'   --- F = Failed
WHERE worker_id = 1 --- Number of stuck adworker process

2. Find the SID and the SERIAL# of stuck adworker process
select sid,serial#  from v$session where sid=xxx;

3. Kill the session
alter system kill session 'xxx,yyy';

Useful documentation:
Inadvertently Closing a Session of Adpatch Causes 'Unable to find job ' Error (Doc ID 257505.1)

Good Luck ....