EBS 12,2 code level check

SQL> l
  1  select
  2    substr(abbreviation,1,10)
  3  ,substr(codelevel,1,10)
  4  from
  5    ad_trackable_entities
  6  where
  7    abbreviation in( 'ad','txk','fnd','fwk','atg_pf','icx' )
  8  order by
  9*   abbreviation
SQL> /

SUBSTR(ABB SUBSTR(COD
---------- ----------
ad         C.10
atg_pf     C.7
fnd        C.7
fwk        C.7
icx        D.3
txk        C.10

6 rows selected.

FND_DIAGNOSTICS Is Invalid (Doc ID 2217255.1)

1. Add grant to DBA_DATAPUMP_JOBS view;
sqlplus / as sysdba
SQL> grant select on dba_datapump_jobs to apps;
SQL> alter package APPS.FND_DIAGNOSTICS compile body;


2. Verify that the FND_DIAGNOSTICS object is valid:

SQL> select object_name,status from dba_objects where object_name like 'FND_DIAGNOSTICS';

APPS.AD_ZD_ADOP invalid (Doc ID 2175698.1)

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

2. Verify the Status of APPS.AD_ZD_ADOP package is valid.

Data Source Connection Pool Diagnostics

Oracle E-Business Suite 12.2 Data Source Connection Pool Diagnostics (Doc ID 1940996.1)

Diagnostic and Analyzer Scripts

Catalog: Oracle Toolbox: Diagnostic and Analyzer Scripts - Data Collectors - Health Checks - Tools - Utilities - SRDC - All Products - Database - Exadata - EBS - JDE - Fusion - Middleware - Siebel - Sun - Peoplesoft (Doc ID 1987483.2)

OPatch auto