PER_ZA_USER_HOOK_PKG.VALIDATE_PERSON_ADDRESS--Code to carry out this hook call has not been created
Last updated on FEBRUARY 06, 2018
Applies to:
Oracle HRMS (South African) - Version 12.0 HRMS RUP 7 and laterInformation 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
-----------------------------------
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