PER_ZA_USER_HOOK_PKG.VALIDATE_PERSON_ADDRESS--Code to carry out this hook call has not been created (Doc ID 1071124.1)

Last updated on JUNE 20, 2017

Applies to:

Oracle HRMS (South African) - Version 12.0 HRMS RUP 7 and later
Information in this document applies to any platform.

Symptoms


Applied Year End (YE) patching for South Africa Human Resources (ZAHR) and these 2 patches failed: <Patch:9345302> and <Patch:9137076>.

Errors from ADWORK log1

Log shows the following errors

Hook Package: HR_PERSON_ADDRESS_BK3
-----------------------------------


233/1 PLS-00201: identifier 'INVALID_SEE_COMMENT_IN_SOURCE' must be declared
233/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 parameters. Code to carry out this hook call has not been created.

Hook Package: HR_PHONE_BK1
--------------------------

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

Hook: Before Process
--------------------

There is a parameter to the legislation function which is not available at this
hook. This API module will not execute until this problem has been resolved.

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

 

Changes

Applied Year End patches for ZAHR

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