My Oracle Support Banner

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

Last updated on DECEMBER 08, 2019

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.

Symptoms

 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.

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
Cause
Solution
References


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