Upgrade from R11i to R12.1, Applying R12.HR_PF.B.delta.5 On Top Of 12.1.3 Errors ORA-06512: at "APPS.HR_API_USER_HOOKS_UTILITY"; After Process (PER_ASG_AGGR.UPDATE_RTI_AGG_UPDATE_ASG) The call_procedure does not exist in th e call_package. (Doc ID 1562868.1)

Last updated on JULY 12, 2016

Applies to:

Oracle Payroll - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to upgrade from 11.5.10.2 with 11i.HR_PF.K.delta.7 to 12.1.3 R12.HR_PF.B.delta.5 (Patch 13418800), the following error occurs.

ERROR
-----------------------
ATTENTION: All workers either have failed or are waiting:

         FAILED: file peperasd.sql on worker  1.
         FAILED: file peempasd.sql on worker  2.
         FAILED: file peasgasd.sql on worker  3.

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


...

Module Name: UPDATE_EMP_ASG
Module Type: Business Process API

Hook Package: HR_ASSIGNMENT_BK2
-------------------------------

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

Hook: After Process

-------------------
(PER_ASG_AGGR.UPDATE_RTI_AGG_UPDATE_ASG) The call_procedure does not exist in th
e call_package. 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


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms