My Oracle Support Banner

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

Last updated on JUNE 20, 2023

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"

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 parameters. 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



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


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