Patches 16234880:R12.OIE.B and 17530389: R12.OIE.B Cause AP_WEB_DB_AP_INT_PKG Package to Become Inva
Hi Support,
We applied 2 oracle recommended patches in TST and AP_WEB_DB_AP_INT_PKG package goes invalid.
Internet Expenses (OIE)
Patch 16234880:R12.OIE.B
Patch 17530389: R12.OIE.B:Null Pointer Exception is thrown, when the start date is left empty in multirow and details page.
SQL> alter package AP_WEB_DB_AP_INT_PKG compile body;
Warning: Package Body altered with compilation errors.
SQL> show errors
Errors for PACKAGE BODY AP_WEB_DB_AP_INT_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
259/5 PL/SQL: SQL Statement ignored
263/30 PL/SQL: ORA-00907: missing right parenthesis
SQL> alter package AP_WEB_DB_AP_INT_PKG compile;