Error 'PLS-00201: INVALID_SEE_COMMENT_IN_SOURCE' On Pyelersd.Sql While Applying Patch 6394500 (Doc ID 763223.1)

Last updated on JULY 19, 2016

Applies to:

Oracle Human Resources - Version 12.0.4 and later
Information in this document applies to any platform.
INVALID_SEE_COMMENT_IN_SOURCE , Pyelersd.Sql , 6394500


Symptoms

-- Problem Statement:
On 12.0.4 in Development:
When upgrading from 11.5.10 to 12.0.4 the following error occurs:

ERROR
-----------------------
sqlplus -s APPS/***** @/u07/HR12/apps/apps_st/appl/pay/12.0.0/patch/115/sql/pyelersd.sql

PL/SQL procedure successfully completed.

Commit complete.

API User Hook Pre-Processor One Module Report
=============================================
Created on 2009/01/07 18:23:35 (YYYY/MM/DD HH:MM:SS)

Module Name: PAY_ELEMENT_ENTRIES_F
Module Type: Internal Row Handler

Hook Package: PAY_ELE_RKD
-------------------------

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

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

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

Time when worker failed: Wed Jan 07 2009 18:23:36
AdjavaWorker has reached the maximum wait timeout specified( 36000000 ). So Exiting

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