HRMS Patch: R12.HR_PF.B.delta.8(20000288)

Issues faced During HRMS Patch: R12.HR_PF.B.delta.8(20000288)

 

Error:

ATTENTION: All workers either have failed or are waiting:

           FAILED: file pycnpbtt.ldt on worker  1.
           FAILED: file paycnbcattl.ldt on worker  2.
           FAILED: file paycnutabtl.ldt on worker  3.
           FAILED: file pycnglbtt.ldt on worker  4.
           FAILED: file payaurug.ldt on worker  5.
           FAILED: file pycapettt.ldt on worker  6.
           FAILED: file pyacvmap.ldt on worker  7.
           FAILED: file pycaudtltable.ldt on worker  8.
           FAILED: file pycougp.ldt  on worker  9.
           FAILED: file payhkbcattl.ldt on worker 10.
           FAILED: file pycapbttt.ldt on worker 11.
           FAILED: file pycapectt.ldt on worker 12.
           FAILED: file pycnpect.ldt on worker 13.
           FAILED: file pycapyttt.ldt on worker 14.
           FAILED: file paycndimtl.ldt on worker 15.
           FAILED: file pycapivtt.ldt on worker 16.

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

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 are pre-requisites patches "9817770:R12.ATG_PF.B" & "9966055:R12.FND.B" which needs to be applied which is not mentioned in patch Readme.

Pre-requisites :

From Patch Readme:

     * R12.AD.B.delta.6
     * R12.ATG_PF.B.delta.3
     * R12.FWK.B.delta.4
   
From Metalink reference : Doc ID 1989740.1 - point 2 give below reference docs as pre-requisite

2. Apply Mandatory Patches Before Applying R12.1 HRMS RUP8 (R12.HR_PF.B.delta.8) [Required]

Attention:Read and follow the instructions in the R12.ATG_PF.B.Delta.3 Patch 8919491 Readme Document 1066312.1. All necessary steps including Post-install steps must be performed before applying Release 12.1 HRMS RUP8 [R12.HR_PF.B.Delta.8, Patch 20000288].

      * 9817770:R12.ATG_PF.B (POST-R12.ATG_PF.B.DELTA.3 CONSOLIDATED PATCH)
      * 9966055:R12.FND.B, Patch 9966055   
     
Oracle Payables and Oracle Payments customers Document 1931412.1
      *16983427

Solution

Please execute the following steps:

1. Stop patch 20000288:
   
    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 patches 9817770 & 9966055.

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

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

• Check my other relative posts on: 

 *DataInstall and Hrglobal.drv installation     *    License EBS HRMS/Payroll product in EBS application

Thanks,
Achal