FND_DIAGNOSTICS Is Invalid In Oracle Apps R12.2

 FND_DIAGNOSTICS Is Invalid In Oracle Apps R12.2

After applying the PSU patch.

Ran @utlrp.sql  at Apps schema FND_DIAGNOSTICS package is invalid .

Error :- 

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;