5 Replies Latest reply on Jul 31, 2015 2:39 PM by 1466728

    Patch fails 20000288 .. worker failed peaddasd.sql ....PER_ZA_USER_HOOK_PKG.VALIDATE_PERSON_ADDRESS

    1466728


      HI Experts,

       

      While applying 20000288 patch ..Patch error with following worker failed peaddasd.sql.

       

      --------------worker failed

              Control
      Worker  Code      Context            Filename                    Status
      ------  --------  -----------------  --------------------------  --------------
           1  Run       AutoPatch R120                                 Wait
           2  Run       AutoPatch R120     peaddasd.sql                FAILED
           3  Run       AutoPatch R120                                 Wait
           4  Run       AutoPatch R120                                 Wait
           5  Run       AutoPatch R120                                 Wait
           6  Run       AutoPatch R120                                 Wait
           7  Run       AutoPatch R120                                 Wait
           8  Run       AutoPatch R120                                 Wait


      ----------------------------------------------------------------------------

      -------------------------Worker2 Log

      Hook Package: HR_PERSON_ADDRESS_BK3

      -----------------------------------

      241/1  PLS-00201: identifier 'INVALID_SEE_COMMENT_IN_SOURCE' must be declared
      241/1  PL/SQL: Statement ignored

      Hook: Before Process
      --------------------
      (PER_ZA_USER_HOOK_PKG.VALIDATE_PERSON_ADDRESS) There is a parameter to the call
      procedure which is not available at this hook. Check your call procedure paramet
      ers. Code to carry out this hook call has not been created.

      BEGIN hr_api_user_hooks_utility.clear_hook_report; END;

      *
      ERROR at line 1:
      ORA-06501: PL/SQL: program error
      ORA-06512: at "APPS.HR_API_USER_HOOKS_UTILITY", line 891
      ORA-06512: at line 1

       

      Regards

      Maddy