My Oracle Support Banner

Online Enablement Patch 13543062 fails on ADZDPREP.sql with ORA-20997: E-Business Suite Database Preparation for Editions: -6508 ORA-06508 (Doc ID 2984549.1)

Last updated on NOVEMBER 03, 2023

Applies to:

Oracle Applications DBA - Version 12.2 to 12.2 [Release 12.2Cloud]
Information in this document applies to any platform.

Symptoms

When attempting to apply Online Enablement Patch 13543062 during the EBS 12.2.x upgrade activity, the following error occurs -

sqlplus -s APPS/***** @/applprod/EBSPROD/product/apps/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/applprod/EBSPROD/product/apps/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/ADZDPREP.sql &un_apps &pw_apps &systempwd'
Connected.

PL/SQL procedure successfully completed.

Connected.

Session altered.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

Commit complete.

PL/SQL procedure successfully completed.

Commit complete.

0 rows deleted.

Commit complete.

29 rows updated.

Commit complete.

0 rows deleted.

Commit complete.

PL/SQL procedure successfully completed.

Commit complete.

Connected.
declare
*
ERROR at line 1:
ORA-20997: E-Business Suite Database Preparation for Editions: -6508 ORA-06508:
PL/SQL: could not find program unit being called
ORA-06512: at line 48

ADZDSHOWLOG.sql reports the following error -

30-OCT-2023 18:33:05.453 ad.plsql.ad_zd_prep.DO_PREP STATEMENT Invoking ad_zd_mview.upgrade_db API.
30-OCT-2023 18:33:05.453 ad.plsql.ad_zd_prep.DO_PREP ERROR E-Business Suite Database Preparation for Editions:-6508 ORA-06508: PL/SQL: could not find program unit being called

Changes

 Upgrading EBS from 11i/12.1 to 12.2.x

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.