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';
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:
Post a Comment