My Oracle Support Banner

Invalid Object AD_ZD_ADOP (Doc ID 2396618.1)

Last updated on MAY 09, 2018

Applies to:

Oracle Applications DBA - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Patch Application Issues

ACTUAL BEHAVIOR
---------------
SQL> alter package APPS.AD_ZD_ADOP compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors;
Errors for PACKAGE BODY APPS.AD_ZD_ADOP:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1432/1 PL/SQL: SQL Statement ignored
1452/8 PL/SQL: ORA-00904: "FN"."NODE_NAME": invalid identifier
1477/5 PL/SQL: SQL Statement ignored
1482/24 PL/SQL: ORA-00904: "SNP"."RELEASE_ID": invalid identifier
1482/24 PLS-00364: loop index variable 'SNP' use is invalid
1486/3 PL/SQL: SQL Statement ignored
1506/13 PL/SQL: ORA-00904: "FN"."NODE_NAME": invalid identifier
1587/3 PL/SQL: SQL Statement ignored
1594/15 PL/SQL: ORA-00904: "FN"."NODE_NAME": invalid identifier
2456/3 PL/SQL: SQL Statement ignored
2463/15 PL/SQL: ORA-00904: "FN"."NODE_NAME": invalid identifier

LINE/COL ERROR
-------- -----------------------------------------------------------------
2515/13 PL/SQL: SQL Statement ignored
2518/25 PL/SQL: ORA-00904: "FN"."NODE_NAME": invalid identifier
2521/8 PL/SQL: Statement ignored
2521/23 PLS-00364: loop index variable 'REC' use is invalid
2523/8 PL/SQL: Statement ignored
2523/45 PLS-00364: loop index variable 'REC' use is invalid
SQL>
 


Changes

Fnd_conc_clone.setup_clean was  ran

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.