5
Dec

On Oracle Applications 12.2 version, Online Enablement patch fails on APPS.AD_ZD_PREP package

Author: Shakeeb Petkar | Category: EBS 12.2.x, TroubleshootingComments Off on On Oracle Applications 12.2 version, Online Enablement patch fails on APPS.AD_ZD_PREP package | Tags: , , , , , , , , , , , , ,

Symptoms:

On Oracle Applications 12.2 version, online enablement patch 13543062 fails with:


begin
*
ERROR at line 1:
ORA-04063: package body "APPS.AD_ZD_PREP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.AD_ZD_PREP"
ORA-06512: at line 4

 
Try to compile the package:

SQL> alter package apps.AD_ZD_PREP compile body;

Warning: Package Body altered with compilation errors.
 
SQL> show error
Errors for PACKAGE BODY APPS.AD_ZD_PREP:

LINE/COL ERROR
-------- -----------------------------------------------------------------
308/6 PL/SQL: Statement ignored
308/6 PLS-00201: identifier 'SYS.DBMS_OBJECTS_APPS_UTILS' must be
declared

670/4 PL/SQL: Statement ignored
670/4 PLS-00201: identifier 'SYS.DBMS_OBJECTS_APPS_UTILS' must be
declared

753/6 PL/SQL: Statement ignored
753/6 PLS-00201: identifier 'SYS.DBMS_OBJECTS_APPS_UTILS' must be
declared

LINE/COL ERROR
-------- -----------------------------------------------------------------

1152/4 PL/SQL: Statement ignored
1152/17 PLS-00201: identifier 'SYS.DBMS_OBJECTS_APPS_UTILS' must be
declared

Solution:


cd $ORACLE_HOME
sqlplus / as sysdba

alter session set current_schema=SYS;
@?/rdbms/admin/dbmsobj.sql
@?/rdbms/admin/dbmsxdbschmig.sql
@?/rdbms/admin/prvtxdbschmig.plb


Run adgrants.sql from patch 22200487 (EBUSINESS SUITE: CONSOLIDATED ONLINE PATCHING ENABLEMENT READINESS REPORT)
 
Copy adgrants.sql from patch directory to $ORACLE_HOME/appsutil/admin


$ sqlplus /nolog

SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql

SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql APPS

 
Try to compile the package again.

SQL> alter package apps.AD_ZD_PREP compile body;

Package body altered.
 
SQL> show error
No errors.

 

Check the status of all the AD_ZD objects:
 

SQL> col OWNER for a12;
col OBJECT_NAME for a25;
col STATUS for a15;
set pages 500;
select owner,object_name,status from dba_objects where object_name like 'AD_ZD%';

OWNER OBJECT_NAME STATUS
SYS AD_ZD_CTX VALID
SYS AD_ZD_SYS VALID
SYS AD_ZD_SYS VALID
APPLSYS AD_ZD_CLOB VALID
APPLSYS AD_ZD_DDL_HANDLER VALID
APPLSYS AD_ZD_DDL_HANDLER_DDL_S VALID
APPLSYS AD_ZD_DDL_HANDLER_N1 VALID
APPLSYS AD_ZD_DDL_HANDLER_U1 VALID
APPLSYS AD_ZD_LOGS VALID
APPLSYS AD_ZD_LOGS_S VALID
APPLSYS AD_ZD_LOGS_U1 VALID
APPS AD_ZD VALID
APPS AD_ZD VALID
APPS AD_ZD_ADOP VALID
APPS AD_ZD_ADOP VALID
APPS AD_ZD_CLOB VALID
APPS AD_ZD_CTX VALID
APPS AD_ZD_CTX VALID
APPS AD_ZD_DDL_HANDLER VALID
APPS AD_ZD_DDL_HANDLER_DDL_S VALID
APPS AD_ZD_LOG VALID
APPS AD_ZD_LOG VALID
APPS AD_ZD_LOGS VALID
APPS AD_ZD_LOGS_S VALID
APPS AD_ZD_MVIEW VALID
APPS AD_ZD_MVIEW VALID
APPS AD_ZD_PARALLEL_EXEC VALID
APPS AD_ZD_PARALLEL_EXEC VALID
APPS AD_ZD_PREP VALID
APPS AD_ZD_PREP VALID
APPS AD_ZD_SEED VALID
APPS AD_ZD_SEED VALID
APPS AD_ZD_TABLE VALID
APPS AD_ZD_TABLE VALID

 
Apply the patch again!

Back to Top