HRMS Patch: R12.HR_PF.B.delta.7 (18004477)

Issues faced During HRMS Patch: R12.HR_PF.B.delta.7 (18004477)

 

Error:

All workers failed with below error in patch log.

    ATTENTION: All workers either have failed or are waiting:

               FAILED: file payzztabdic00150.ldt on worker  1.
               FAILED: file payzzvewdic00017.ldt on worker  2.
               FAILED: file sspzztabdic00000.ldt on worker  3.
               FAILED: file ghrzztabdic00000.ldt on worker  4.
               FAILED: file payzztabdic00016.ldt on worker  5.
               FAILED: file perzzvewdic00065.ldt on worker  6.
               FAILED: file perzztabdic00016.ldt on worker  7.
               FAILED: file perzztabdic00031.ldt on worker  8.
               FAILED: file payzztabdic00005.ldt on worker 12.

    ATTENTION: Please fix the above failed worker(s) so the manager can continue.

    All FNDLOAD log files are showing the same error :

    A syntax error occurred at line 893 in file $FND_TOP/patch/115/import/afdict.lct

Note that in case all the workers are failing at a time there is big chance that you missed to apply pre-requisite.

 

Cause : 

There is a pre-requisites patch R12.ATG_PF.B - 14069503 which needs to be applied which is not mentioned in patch Readme.

Pre-requisites :
    * R12.AD.B.delta.3
    * R12.ATG_PF.B.delta.3
    * CPU PATCH FOR OCT 2011 (12794417)
    * R12.ATG_PF.B - 14069503 : Reference doc id 1907056.1

 

Solution

Please execute the following steps:

1. Stop patch 18004477:
   
    Using adctrl tell workers to quit choosing below option.
   
    3.    Tell worker to quit

2. Take backup of below:

•     Take backup of following tables & drop them: "AD_DEFERRED_JOBS" & "FND_INSTALL_PROCESSES".

•     Take backup of restart directory located at: $APPL_TOP/admin/<ORACLE_SID>

   
3. Download and apply pre-requisites for patch 14069503 ATG CONSOLIDATED PATCH FOR R12.1 HRMS RUP5 ().

4. Restore backup tables & directory from backup taken at step 2.

5. Re-apply the main patch: 18004477
   
    Using adctrl as workers to restart jobs choosing below option,
    2.    Tell worker to restart a failed job

Thanks,
Achal