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 laterInformation 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.
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
=============================================
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
=============================================
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 |