FND_DIAGNOSTICS Is Invalid In 12.2.6 With 12c Database
(Doc ID 2217255.1)
Last updated on OCTOBER 12, 2023
Applies to:
Oracle Applications DBA - Version 12.2 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.6 version, ISSUES WITH FUNCTIONALITY OF AD UTILITIES
Invalid Objects exists in 12.2.6 with 12c database. FND_DIAGNOSTICS is invalid in EBS after upgrading it to versions 12.2.6 with 12C database.
Compiling the object generates the following error:
Alter package <APPS>.FND_DIAGNOSTICS compile body;
Warning: Package Body altered with compilation errors.
SQL> sho 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
Changes
Upgrade to 12c database.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |