AD_ZD_ADOP and FND_DIAGNOSTICS packages invalid status after applying any PSU patches in 12.1.0.2 Database

1. Receiving Errors while running AutoConfig as seen below.

2. Additionally, See the following errors for an invalid APPS.AD_ZD_ADOP object:

SQL> alter package APPS.AD_ZD_ADOP compile body;
Warning: Package Body altered with compilation errors.

SQL> show err
Errors for PACKAGE BODY APPS.AD_ZD_ADOP:
LINE/COL ERROR
-------- -----------------------------------------------------------------
2686/3 PL/SQL: Statement ignored
2686/7 PLS-00201: identifier 'SYS.DBMS_METADATA_UTIL' must be declared

ERROR
-----------------------
Script Name : txkGenADOPWrapper.pl
Script Version : 120.0.12020000.3
ERROR DESCRIPTION:
(*******FATAL ERROR*******
PROGRAM : (/r11/app/FLRPRD/R12apps/fs1/inst/apps/FLRTEST_dbfinsfnyp01/admin/install/txkGenADOPWrapper.pl)
TIME : Mon Aug 22 18:15:08 2016
FUNCTION: TXK::SQLPLUS::_doExecute [ Level 3 ]
MESSAGES:
SQLPLUS error: buffer=

SQL*Plus: Release 10.1.0.5.0 - Production on Mon Aug 22 18:15:08 2016
Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> SQL> Connected.
SQL> SELECT ad_zd_adop.get_node_type('dbfinsfnyp01') FROM DUAL
*
ERROR at line 1:
ORA-04063: package body "APPS.AD_ZD_ADOP" has errors

Solution:

sqlplus / as sysdba

1. Complete the following commands:

$ grant execute on DBMS_METADATA_UTIL to apps;
$ alter package APPS.AD_ZD_ADOP compile body;

DBA_DATAPUMP_JOBS view; sqlplus / as sysdba SQL> grant select on dba_datapump_jobs to apps; SQL> alter package APPS.FND_DIAGNOSTICS compile body; APPS.FND_TRACE Invalid after adgrants.sql GRANT EXECUTE ON DBMS_SYSTEM TO PUBLIC; alter package apps.FND_TRACE compile body; alter package apps.FND_REQUEST compile body;