My Oracle Support Banner

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 APRIL 29, 2020

Applies to:

Oracle Human Resources - Version 12.2 and later
Information 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)

API User Hook Pre-Processor All Module Error Report
===================================================
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:

  1.  Upgrade from 12.1.3 to 12.2.9.
  2.  Execute hrahkall.sql
  3.  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


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