FND_DIAGNOSTICS Is Invalid In 12.2.6 With 12c Database (Doc ID 2217255.1)

Last updated on DECEMBER 23, 2016

Applies to:

Oracle Applications DBA - Version 12.2 and later
Information 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms