Friday, December 14, 2018

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

No comments: