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 JULY 18, 2016

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





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 ca
ll_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 th
e 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 th
e 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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms