Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Patches 16234880:R12.OIE.B and 17530389: R12.OIE.B Cause AP_WEB_DB_AP_INT_PKG Package to Become Inva

edited Oct 24, 2013 1:41AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 4 commentsAnswered ✓

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;

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center