More invalids comes after up-gradation from 12.1.1 to 12.1.3 and all invalids are not compiling.
SQL> alter package APPS.FV_FACTS_TBAL_TRANSACTIONS compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY APPS.FV_FACTS_TBAL_TRANSACTIONS:
LINE/COL ERROR
-------- -----------------------------------------------------------------
1742/6 PL/SQL: SQL Statement ignored
1743/4 PL/SQL: ORA-00918: column ambiguously defined
SQL> alter package APPS.FLM_COPY_ROUTING compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY APPS.FLM_COPY_ROUTING:
LINE/COL ERROR
-------- -----------------------------------------------------------------
457/10 PLS-00341: declaration of cursor 'C_NETWORKS' is incomplete or
malformed
458/3 PL/SQL: SQL Statement ignored
497/2 PL/SQL: ORA-00942: table or view does not exist
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY APPS.FV_FACTS_TBAL_TRANSACTIONS:
LINE/COL ERROR
-------- -----------------------------------------------------------------
1742/6 PL/SQL: SQL Statement ignored
1743/4 PL/SQL: ORA-00918: column ambiguously defined
SQL> alter package APPS.FLM_COPY_ROUTING compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY APPS.FLM_COPY_ROUTING:
LINE/COL ERROR
-------- -----------------------------------------------------------------
457/10 PLS-00341: declaration of cursor 'C_NETWORKS' is incomplete or
malformed
458/3 PL/SQL: SQL Statement ignored
497/2 PL/SQL: ORA-00942: table or view does not exist
Tagged:
0