Peaddasd.sql error when applying 21900901 (Doc ID 2301823.1)

Last updated on AUGUST 29, 2017

Applies to:

Oracle Human Resources - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

When applying the patch:21900901, the following error occurs in the file "peaddasd.sql"

ERROR
-----------------------
API User Hook Pre-Processor One Module Report
=============================================
Created on 2017/XX/XX XX:XX:XX (YYYY/MM/DD HH:MM:SS)

CREATE_PERSON_ADDRESS(Business Process API) successful.

UPDATE_PERSON_ADDRESS(Business Process API) successful.

Module Name: UPDATE_PERS_ADDR_WITH_STYLE
Module Type: Business Process API

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:21900901



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