"APPS.AD_ZD" ORA-04063: Package Body "APPS.AD_ZD" Has Errors (Doc ID 2957952.1)

Last updated on JUNE 30, 2023

Applies to:

Symptoms

On : 12.2.5 version, Patch Application Issues

When attempting to execute adop apply phase,
the following error occurs.

ERROR
-----------------------
Running adop validations on Admin node: [prvcpapp01].
  Log: prvcpapp01:/u01/install/APPS/fs_ne/EBSapps/log/adop/validate_20230527_180519/VCPPROD_prvcpapp01
  Output: /u01/install/APPS/fs_ne/EBSapps/log/adop/validate_20230527_180519/remote_execution_result_20230527_180544.xml
  [ERROR] AdopValidate failed on Node: "prvcpapp01"
  [ERROR] AdopValidate failed or is incomplete on Admin node: prvcpapp01
  [ERROR] Unable to continue processing on other available nodes: prvcpapp02
  [UNEXPECTED]Error running "AdopValidate" on node(s): prvcpapp01.
  [UNEXPECTED]Remote action failed.

ADOP (C.Delta.13)
Session Id: 54
Command: status
Output: /u01/install/APPS/fs_ne/EBSapps/log/status_20230527_180757/adzdshowstatus.out
===============================================================

Node Name Node Type Phase Status Started Finished Elapsed
--------------- ---------- --------------- --------------- -------------------- -------------------- ------------
prvcpapp01 Primary PREPARE COMPLETED 2023/05/27 06:51:24 2023/05/27 07:17:06 0:25:42
  APPLY ACTIVE 2023/05/27 07:30:43 2023/05/27 11:12:23 3:41:40
  FINALIZE NOT STARTED
  CUTOVER NOT STARTED
  CLEANUP NOT STARTED

prvcpapp02 secondary PREPARE COMPLETED 2023/05/27 06:51:24 2023/05/27 07:17:04 0:25:40
  APPLY FAILED 2023/05/27 08:50:30 2023/05/27 11:35:27 2:44:57
  FINALIZE NOT STARTED
  CUTOVER NOT STARTED
  CLEANUP NOT STARTED

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. execute adop apply phase

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Financial impact - High

Cause

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