Patch 9239090 Upgrade to 12.1.3, Now FV_SLA_UTL_PROCESSING_PKG is Invalid
Hi,
We are a US Federal agancy and have upgraded our application from 11i to R12.1.3 and we have this package to be INVALID
SQL> show errors
Errors for PACKAGE BODY FV_SLA_UTL_PROCESSING_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
136/5 PL/SQL: Statement ignored
136/25 PLS-00302: component 'ENT_REFUND_AMOUNT' must be declared
137/5 PL/SQL: Statement ignored
137/25 PLS-00302: component 'ACC_REFUND_AMOUNT' must be declared
1140/9 PL/SQL: SQL Statement ignored
1209/11 PL/SQL: ORA-00904: "ADVANCE_REQUIRED": invalid identifier
1277/11 PLS-00382: expression is of wrong type
1277/34 PLS-00302: component 'FED_NON_FED_IND' must be declared
1278/11 PLS-00382: expression is of wrong type
1278/34 PLS-00302: component 'ACC_REFUND_AMOUNT' must be declared
We are a US Federal agancy and have upgraded our application from 11i to R12.1.3 and we have this package to be INVALID
SQL> show errors
Errors for PACKAGE BODY FV_SLA_UTL_PROCESSING_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
136/5 PL/SQL: Statement ignored
136/25 PLS-00302: component 'ENT_REFUND_AMOUNT' must be declared
137/5 PL/SQL: Statement ignored
137/25 PLS-00302: component 'ACC_REFUND_AMOUNT' must be declared
1140/9 PL/SQL: SQL Statement ignored
1209/11 PL/SQL: ORA-00904: "ADVANCE_REQUIRED": invalid identifier
1277/11 PLS-00382: expression is of wrong type
1277/34 PLS-00302: component 'FED_NON_FED_IND' must be declared
1278/11 PLS-00382: expression is of wrong type
1278/34 PLS-00302: component 'ACC_REFUND_AMOUNT' must be declared
Tagged:
0