NaturalOracle DataGaurd tutorial Series Coming Soon!! Natural
For Any queries, please mail us at support@funoracleapps.com

FND_DIAGNOSTICS Is Invalid In Oracle Apps R12.2

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

No comments :

Post a Comment