Creating User Hook with HR_API_USER_HOOKS_UTILITY Fails with "PLS-00201: identifier 'INVALID_SEE_COMMENT_IN_SOURCE' must be declared"
(Doc ID 2664899.1)
Last updated on NOVEMBER 12, 2023
Applies to:
Oracle Human Resources - Version 12.2 and laterInformation in this document applies to any platform.
Symptoms
Problem Statement:
When loading hrahkall.sql to create user hook package source code, following error occurs. The issue occurs on other hook packages as well (e.g. HR_PERSON_ABSENCE_BK2, HR_ASSIGNMENT_BKM)
===================================================
Created on XXXX/XX/XX XX:XX:XX (YYYY/MM/DD HH:MM:SS)
Module Name: CREATE_PERSON_ABSENCE
Module Type: Business Process API
Hook Package: HR_PERSON_ABSENCE_BK1
-----------------------------------
116/1 PLS-00201: identifier 'INVALID_SEE_COMMENT_IN_SOURCE' must be declared
116/1 PL/SQL: Statement ignored
===============
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
Hook: After Process
-------------------
(hr_person_absence_be1.CREATE_PERSON_ABSENCE_A) The P_COMMENTS parameter to the
call procedure must have the same datatype as the value available
at the hook. Code to carry out this hook call has not been created.
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
- Upgrade from 12.1.3 to 12.2.9.
- Execute hrahkall.sql
- Script fails with the error.
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 |