Pyelersd.Sql Fails Ora-06512: At Apps.Hr_api_user_hooks_utility, Line 891 (Doc ID 753401.1)

Last updated on JULY 19, 2016

Applies to:

Oracle Human Resources - Version: 12.0.4 and later   [Release: 12.0 and later ]
Information in this document applies to any platform.

Symptoms

-- Problem Statement:
On 12.0.4 in Production:
When attempting to upgrade from 11.5.10.2 to 12.0.4, the following error occurs:

ERROR
adwork005.log ->
===============
Module Name: UPDATE_ELEMENT_ENTRY
Module Type: Business Process API

Hook Package: PAY_ELEMENT_ENTRY_BK2
127/1 PLS-00201: identifier 'INVALID_SEE_COMMENT_IN_SOURCE' must be declared
127/1 PL/SQL: Statement ignored
260/1 PLS-00201: identifier 'INVALID_SEE_COMMENT_IN_SOURCE' must be declared
260/1 PL/SQL: Statement ignored

Hook: After Process
(HR_NO_VALIDATE_PKG.UPDATE_ELE_ENTRY_AP) The call_procedure does not exist in th
e call_package. Code to carry out this hook call has not been created.

Hook: Before Process
(HR_NO_VALIDATE_PKG.UPDATE_ELE_ENTRY_BP) The call_procedure does not exist in th
e call_package. Code to carry out this hook call has not been created.

DELETE_ELEMENT_ENTRY(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

adwork006.log ->
================
Creating backup table AP_SUPPLIERS_BACKUP_6050423

DECLARE
*
ERROR at line 1:
ORA-20000: -942 - ORA-00942: table or view does not exist
ORA-06512: at line 63
--

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


-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Upgrade 11.5.10.2 to 12.0.4 through step 10 - "American English upgrade patch
driver"(u6394500.drv)" (Referred document -->>Part No. E12011-01)
There are 1243 invalid objects now between the upgrade. Before upgrade count was 16.

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