My Oracle Support Banner

12.2.0 Upgrade - Peasgasd.sql, Peperasd.sql And Peempasd.sql Failed PLS-00201: identifier 'INVALID_SEE_COMMENT_IN_SOURCE' must be declared ORA-06501: PL/SQL: program error (Doc ID 1636918.1)

Last updated on JUNE 11, 2023

Applies to:

Oracle Human Resources - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to run the merged driver for a 12.1.6 to 12.2 upgrade, the following errors occur.


adwork003.log

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





adwork007.log

API User Hook Pre-Processor One Module Report
=============================================

Module Name: UPDATE_PERSON
Module Type: Business Process API

Hook Package: HR_PERSON_BK1
---------------------------

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


Hook: After Process
-------------------
(PER_ASG_AGGR.UPDATE_RTI_AGG_PERSON) The call_procedure does not exist in the call_package. Code to carry out this hook call has not been created.


DELETE_PERSON(Business Process API) successful.
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



adwork012.log

API User Hook Pre-Processor One Module Report
=============================================

Module Name: CREATE_EMPLOYEE
Module Type: Business Process API

Hook Package: HR_EMPLOYEE_BK1
-----------------------------

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


Hook: After Process
-------------------
(PER_ASG_AGGR.UPDATE_RTI_AGG_NEW_PERSON) The call_procedure does not exist in the call_package. Code to carry out this hook call has not been created.


Module Name: CREATE_EMPLOYEE
Module Type: Business Process API

Hook Package: HR_EMPLOYEE_BK1
-----------------------------


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

Hook: After Process
-------------------
(PER_ASG_AGGR.UPDATE_RTI_AGG_NEW_PERSON) The call_procedure does not exist in the call_package. Code to carry out this hook call has not been created.


RE_HIRE_EX_EMPLOYEE(Business Process API) successful.

APPLY_FOR_INTERNAL_VACANCY(Business Process API) successful.


HIRE_INTO_JOB(Business Process API) successful.
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
The issue can be reproduced at will with the following steps:

1. Run the 12.2.upgrade driver
2. Upgrade driver fails

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.