Recompiling Objects (HR_ASSIGNMENT_BK1 and HR_ASSIGNMENT_BK2) error PLS-00201: Identifier 'INVALID_SEE_COMMENT_IN_SOURCE' Must Be Declared (Doc ID 1551749.1)

Last updated on DECEMBER 09, 2022

Applies to:

Symptoms

Data Corruption issue. 

After R12 upgrade and applying the patches suggested by Note 1174964.1 - R12.1: Upgrade Patch 6678700 Fails on APPS.HR_API_USER_HOOKS_UTILITY to resolve the user hooks utility issue, the following objects are still invalid.


OBJECT_NAME OBJECT_TYPE
------------------------------ -------------------
HR_ASSIGNMENT_BK1 PACKAGE BODY
HR_ASSIGNMENT_BK2 PACKAGE BODY
HR_EMPLOYEE_BK1 PACKAGE BODY
HR_PERSON_BK1 PACKAGE BODY

When attempting to re-compile those objects the following error occurs:

Module Name: CREATE_SECONDARY_EMP_ASG
Module Type: Business Process API

Hook Package: HR_ASSIGNMENT_BK1
-------------------------------

384/1  PLS-00201: identifier 'INVALID_SEE_COMMENT_IN_SOURCE' must be declared
384/1  PL/SQL: Statement ignored

Hook: After Process
-------------------
(PER_ASG_AGGR.UPDATE_RTI_AGG_PERSON) The call_procedure does not exist in the ca

ll_package. Code to carry out this hook call has not been created.


Module Name: UPDATE_EMP_ASG
Module Type: Business Process API

Hook Package: HR_ASSIGNMENT_BK2
-------------------------------

294/1  PLS-00201: identifier 'INVALID_SEE_COMMENT_IN_SOURCE' must be declared
294/1  PL/SQL: Statement ignored

Hook: After Process

-------------------
(PER_ASG_AGGR.UPDATE_RTI_AGG_UPDATE_ASG) The call_procedure does not exist in th
e call_package. Code to carry out this hook call has not been created.

Cause

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