Thursday, April 24, 2014

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 ....


  1. This comment has been removed by a blog administrator.

  2. Are you monetizing your premium shared links?
    Did you know that AdscendMedia will pay you an average of $0.50 per file download?

  3. When choosing a domain name for your site, you should never settle for something irrelevant just because your preferred domain has been taken. google backlink search

  4. Thanks For Posting Valuable Information..And keep posting Upon the tutorials of Selenium

  5. Need To Increase Your ClickBank Banner Traffic And Commissions?

    Bannerizer made it easy for you to promote ClickBank products with banners, simply go to Bannerizer, and grab the banner codes for your favorite ClickBank products or use the Universal ClickBank Banner Rotator Tool to promote all of the available ClickBank products.