Extra Invalid Objects after upgrade from 12.1.2 to 12.1.3
fter the upgrade we get following invalid objects in the apps schema. This objects were not in invalid state before the upgrade.Manually compilation of these packages also results in error.
1.INV_UI_RCV_LOVS
Error:-
-------- -----------------------------------------------------------------
270/11 PLS-00323: subprogram or cursor 'GET_JOB_LOV' is declared in a
package specification and must be defined in the package body
2. INV_STATUS_PKG
-------- -----------------------------------------------------------------
810/10 PL/SQL: Statement ignored
810/23 PLS-00302: component 'PENDING_STATUS' must be declared
865/9 PL/SQL: Statement ignored
865/22 PLS-00302: component 'PENDING_STATUS' must be declared
LINE/COL ERROR
-------- -----------------------------------------------------------------
1212/57 PLS-00302: component 'GROUP_ID' must be declared
1216/17 PL/SQL: Statement ignored
1.INV_UI_RCV_LOVS
Error:-
-------- -----------------------------------------------------------------
270/11 PLS-00323: subprogram or cursor 'GET_JOB_LOV' is declared in a
package specification and must be defined in the package body
2. INV_STATUS_PKG
-------- -----------------------------------------------------------------
810/10 PL/SQL: Statement ignored
810/23 PLS-00302: component 'PENDING_STATUS' must be declared
865/9 PL/SQL: Statement ignored
865/22 PLS-00302: component 'PENDING_STATUS' must be declared
LINE/COL ERROR
-------- -----------------------------------------------------------------
1212/57 PLS-00302: component 'GROUP_ID' must be declared
1216/17 PL/SQL: Statement ignored
Tagged:
0