My Oracle Support Banner

DRT Patch Failing With Identifier 'AD_ZD_SEED.PREPARE' Must Be Declared (Doc ID 2617317.1)

Last updated on JULY 25, 2021

Applies to:

Oracle Human Resources - Version 12.1.3 and later
Oracle E-Business Suite Technology Stack - Version 12.1.3 and later
Information in this document applies to any platform.


 Problem Statement:

When installing Data Removal Tool Patch 28054263 it is failing with the following error:

NOTE: This isn't specific to patch 28054263, it could occur for any patch that uses 'AD_ZD_SEED.PREPARE'


BEGIN ad_zd_seed.prepare('PER_DRT_TABLES'); END;

ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'AD_ZD_SEED.PREPARE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


Steps to Reproduce:
The issue can be reproduced at will with the following steps:

  1.  Download patch

  2. Use adpatch to apply it.


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.