ORA-06512: at "APPS.HR_API_USER_HOOKS_UTILITY", line 891

When attempting to apply 12.2.6 patch: 21900901:oracle e-business suite 12.2.6 release update pack
the following error occurs.

ERROR:

(XX_HR_USER_HOOK_PKG.POSITION_BEFORE_UPDATE_BK2) The call_package does not ex

ist in the database. Code to carry out this hook call has not been created.

DELETE_POSITION(Business Process API) successful.

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

To implement the solution, please execute the following steps:

1. Run the following sql.

SQL> select CALL_PACKAGE, CALL_PROCEDURE, ENABLED_FLAG from HR_API_HOOK_CALLS;

This will provide you a list of the user hooks, procedures and enabled_flag values

From this table, update the user hook in question and set it to 'N.'

2. Run the following in sql:

cd $PER_TOP/admin/sql

Log into SQLPLUS as the APPS user

SQL> @hrahkall.sql

This will clear up the child process that are still enabled.

3. Restart the failed worker and allow the patch to complete.

4. Properly create your user hook