Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

New Note 1459045.1 11.5.10.2 Maintenance Pack 3480000 Failed On Sript Asocruhk.sql ORA-04063: packag

edited Jun 22, 2018 9:52AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered

 While applying maintenance pack Patch 3480000, the following error occurs:

sqlplus -s APPS/***** @/.../aso/11.5.0/patch/115/sql/asocruhk.sql
DECLARE
*
ERROR at line 1:
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "APPS.JTF_USR_HKS" has errors
ORA-06512: at line 57
ORA-06512: at line 128

Manual attempt to compile .JTF_USR_HKS fails.
SQL> alter package JTF_USR_HKS compile body;

Warning: Package Body altered with compilation errors.

SQL> sho err
Errors for PACKAGE BODY JTF_USR_HKS:

LINE/COL ERROR
-------- -----------------------------------------------------------------
931/3 PLS-00201: identifier 'XMLGEN.CLEARBINDVALUES' must be declared
931/3 PL/SQL: Statement ignored
935/3 PLS-00201: identifier 'XMLGEN.SETBINDVALUE' must be declared
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center