ADZDEXRPT.sql Outputs the Same Error in Section 3 After Fixed (Doc ID 2766989.1)

Last updated on APRIL 19, 2021

Applies to:

Symptoms

On : 12.2 version, Upgrade related issues

After the application of Patch 13543062, the ADZDEXRPT.sql script was executed and the adzdexrpt.txt file was generated, and the following error was found:

ERROR
-----------------------
DOC> *************************************************************
DOC> SECTION 3
DOC> *************************************************************
DOC> Failed Jobs with ERRORS, For complete error stack and DDL,
DOC> Please check AD_ZD_DDL_HANDLER table for corresponding DDL_ID
DOC>
DOC>#

Phase DDL ID Status SQL Error
-------------------- ------------ ------------ -------------------------------------------------- --------------------------------------------------
UPGRADE_TABLE <SQL ID>　ERROR begin ad_zd_table.upgrade('AP', ORA-04052: error occurred when looking up remote
  'AP_SUPPLIER_SITES_ALL'); end; <Object Name>
  ORA-00604: error occurred at recursive SQL level
  3
  ORA-12154: TNS:could not resolve the connect
  identifier specified

The root cause was a custom DB trigger referring to an external DB link. The custom trigger was dropped, and the process would fail again. The execution of ADZDEXRPT.sql would show the same error again.

>drop trigger <Custom DB Trigger Name>;
>begin ad_zd_table.upgrade('AP','AP_SUPPLIER_SITES_ALL'); end;
>commit;

Changes

 EBS upgrade from R12.1 to R12.2.

Cause

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