My Oracle Support Banner

Upgrade to 12.2.4 Fails With Error ORA-04063: package body "APPS.AD_ZD_PREP" has errors (Doc ID 1935965.1)

Last updated on AUGUST 18, 2017

Applies to:

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


While applying Patch 18288881 with 18886213 and 18942757 in hot patch mode as part of upgrading the E-Business Suite (EBS) R12.2.0 to 12.2.4, it failed with the following error on the Applications Tier:

AutoPatch error:
Error: Unable to run enable_custom_user

AutoPatch - aiuoraEnableCustom: INFO: 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 1

We also followed the MOS 932985.1, no luck.
The high level steps which we followed to upgrade the EBS R12.2.0 to 12.2.4
1) Installed EBS R12.2.0 DB Tier on an LPAR1
2) Installed EBS R12.2.0 Apps Tier on LPAR2
3) Followed the note 1594274.1 for upgrading the DB Tier
- Upgraded to the latest OPatch version
- Upgraded the startCD from to and updated the staging area.
- Applied all of the DB patches shown in StartCD and additional DB patches required in the "No included in any startCD"
- StartCD Patches
- 17600719, 17693770, 18116376, 18259911
- Patches no included in StartCD
- 16989137, 17875948, 17912217, 18419770, 18614015, 18685209, 19078951
- Applied some more additional patches that were shown as output of the script "" in DB Tier
4) After all DB patches, there is no "required patches" or any list of patches from "". It was clean.
5) Following the note 1617458.1 to upgrade the Apps Tier and Choose Path A.
- Executed the SQL script ADZDDTFIX.sql from the patch 17268684:R12AD.c patch.
- Applied Apps patch 17204589 for Seed table upgrade. (Hot Patch)
- Executed adgrants.sql of patch 18283295 in DB tier as SYSDBA.
( sqlplus /nolog , connect sys as sysdba, @adgrants.sql APPS)
- Applied Apps patch 18283295:R12.AD.C.Delta.5 in hot patch mode
- while applying Patch 18288881:R12.TXK.C.Delta.5 merging with 18886213:R12.TXK.C and 18942757:R12.TXK.C, got the
error. (adop phase=apply patches=18288881,18886213,18942757 hotpatch=yes merge=yes)



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

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