Symptoms:

Hook Package: HR_PERSON_ADDRESS_BK3

———————————–

217/1  PLS-00201: identifier ‘INVALID_SEE_COMMENT_IN_SOURCE’ must be declared

217/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

Time when worker failed: Tue Jun 27 2023 18:53:12 AdjavaWorker has reached the maximum wait timeout specified( 36000000 ). So Exiting.

Solution:

1. Check the status of package HR_PERSON_ADDRESS_BK3

SQL> select owner,object_name, object_type,status
from dba_objects
where object_name = ‘HR_PERSON_ADDRESS_BK3’; 2 3

OWNER

OBJECT_NAME

OBJECT_TYPE STATUS

---

APPS
HR_PERSON_ADDRESS_BK3
PACKAGE VALID

APPS
HR_PERSON_ADDRESS_BK3
PACKAGE BODY INVALID

OWNER

OBJECT_NAME

OBJECT_TYPE STATUS

---

SQL>

2. Skip the worker using adctrl option 8
3. Once the patch is applied, please check if the package HR_PERSON_ADDRESS_BK3 is valid.

select owner,object_name, object_type,status
from dba_objects
where object_name = ‘HR_PERSON_ADDRESS_BK3’;

4. Run peaddasd.sql manually

cd $PER_TOP/patch/115/sql/
sqlplus apps/
SQL> @peaddasd.sql

SQL> @peaddasd.sql

PL/SQL procedure successfully completed.

Commit complete.

API User Hook Pre-Processor One Module Report

Created on 2023/09/22 04:52:12 (YYYY/MM/DD HH:MM:SS)

CREATE_PERSON_ADDRESS(Business Process API) successful.

UPDATE_PERSON_ADDRESS(Business Process API) successful.

UPDATE_PERS_ADDR_WITH_STYLE(Business Process API) successful.
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production

Metalink Reference:

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