adpatch tables fnd_install_processes & ad_deferred_jobs

Adpatch will create  workers  to run some task .It creates 2 tables before to maitain record  of job .

1)fnd_install_processes
2)ad_deferred_jobs

1)fnd_install_processes - This table is used to store the information about the job given to the worker. It will insert a row for each worker when it assigned a job.

2)ad_deferred_jobs - this table is used to store the information about the deferred jobs (jobs failed to run).


After the job is finished the tables are dropped automatically.

Reffer ML note for more details :
Oracle E-Business Suite Patching FAQ for Release 12 (Doc ID 459156.1)

R12 ADPATCH RESTART

 1. Using the adctrl utility, shutdown the workers.
    a. adctrl
    b. Select option 3 “Tell worker to shutdown/quit”


    2. Backup the FND_INSTALL_PROCESSES table which is owned by the APPLSYS schema
    a. sqlplus applsys/
    b. create table fnd_Install_processes_back
    as select * from fnd_Install_processes;
    c. The 2 tables should have the same number of records.
    select count(*) from fnd_Install_processes_back;
    select count(*) from fnd_Install_processes;


    3. Backup the AD_DEFERRED_JOBS table.
    a. sqlplus applsys/
    b. create table AD_DEFERRED_JOBS_back
    as select * from AD_DEFERRED_JOBS;
    c. The 2 tables should have the same number of records.
    select count(*) from AD_DEFERRED_JOBS_back;
    select count(*) from AD_DEFERRED_JOBS;

    4. Backup the .rf9 files located in $APPL_TOP/admin//restart directory.
    At this point, the adpatch session should have ended and the cursor should
    be back at the Unix prompt.
    a. cd $APPL_TOP/admin/
    b. cp restart restart_back
    
    
    6. Fix the issue which stopped patch

    7. Restore the .rf9 files located in $APPL_TOP/admin//restart_back
    directory.
    a. cd $APPL_TOP/admin/
    b. mv restart restart_
    c. mv restart_back restart

    8. Restore the FND_INSTALL_PROCESSES table which is owned by the APPLSYS
    schema.
    a. sqlplus applsys/
    b. create table fnd_Install_processes
    as select * from fnd_Install_processes_back;
    c. The 2 tables should have the same number of records.
    select count(*) from fnd_Install_processes;
    select count(*) from fnd_Install_processes_back;

    9. Restore the AD_DEFERRED_JOBS table.
    a. sqlplus applsys/
    b. create table AD_DEFERRED_JOBS
    as select * from AD_DEFERRED_JOBS_back;
    c. The 2 tables should have the same number of records.
    select count(*) from AD_DEFERRED_JOBS_back;
    select count(*) from AD_DEFERRED_JOBS;

    10. Re-create synonyms
    a. sqlplus apps/apps
    b. create synonym AD_DEFERRED_JOBS for APPLSYS.AD_DEFERRED_JOBS;
    c. create synonym FND_INSTALL_PROCESSES FOR APPLSYS.FND_INSTALL_PROCESSES;

    11. Start adpatch, it will resume where it stopped previousl