ADOP - Patch 13543062 fails on ADZDPREP.sql - ORA-20001: ORA-06508: PL/SQL: could not find program unit being called (Doc ID 1630377.1)

Last updated on SEPTEMBER 07, 2016

Applies to:

Oracle Applications DBA - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

During upgrade from 11i to 12.2 according to the document "Oracle E-Business Suite,
"Upgrade Guide Release 11i is a 12.2" section "Download and apply the Online Patching Enablement patch" patch 13543062 is not enabling "adop.
The patch fails while running:
  sqlplus -s APPS/***** @/pko/12i/SSGW1/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/pko/12i/SSGW1/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/ADZDPREP.sql &un_apps &pw_apps &systempwd'
with the error message:

ERROR at line 1:
ORA-20001: ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "APPS.AD_ZD", line 29
ORA-06512: at "APPS.AD_ZD_PREP", line 460
ORA-06512: at line 4

 

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