HRMS RUP8 Patch 20000288 Fails On Peaddasd.sql PER_ZA_USER_HOOK_PKG.VALIDATE_PERSON_ADDRESS
(Doc ID 2020320.1)
Last updated on AUGUST 24, 2023
Applies to:
Oracle HRMS (South Africa) - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
When upgrading to HRMS Rup 8 - patch 20000288 the following error is generated
ERROR
-----------------------
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
-----------------------
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
Steps to Reproduce
The issue can be reproduced at will with the following steps:
1. Apply patch 20000288
2. Error occurs
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |