My Oracle Support Banner

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

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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.