Error:

FND_DIAGNOSTICS is invalid in EBS 12.2 with 12C database.

 When we Compile the object the following error is observed:

 Alter package APPS.FND_DIAGNOSTICS compile body;

 Warning: Package Body altered with compilation errors.

 SQL> show errors;
Errors for PACKAGE BODY APPS.FND_DIAGNOSTICS:

 LINE/COL ERROR
-------- -----------------------------------------------------------------
1839/17 PL/SQL: SQL Statement ignored
1839/31 PL/SQL: ORA-00942: table or view does not exist
1841/9 PL/SQL: Statement ignored
1841/14 PLS-00364: loop index variable 'X' use is invalid

 Solution:

 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';