HRMS RUP8 Patch 20000288 Fails On Peaddasd.sql PER_ZA_USER_HOOK_PKG.VALIDATE_PERSON_ADDRESS (Doc ID 2020320.1)

Last updated on JULY 12, 2016

Applies to:

Oracle HRMS (South African) - Version 12.1.3 and later
Information 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

Steps to Reproduce
The issue can be reproduced at will with the following steps:
run patch 20000288 using adadmin



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