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

MOSC Banner

Patch 16052604:R12.IBY.B Caused Invalid Objects

edited Oct 19, 2013 12:23AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 13 commentsAnswered
Hi,
After I installed the 16052604 patch the next object are invalid status

OWNER      OBJECT_TYPE     OBJECT_NAME
---------- --------------- ------------------------------
APPS       PACKAGE BODY    XLA_TRANSFER_PKG
APPS       PACKAGE BODY    XLA_AE_HEADER_PKG


SQL> alter package APPS.XLA_TRANSFER_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY APPS.XLA_TRANSFER_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2132/9   PL/SQL: Statement ignored
2132/9   PLS-00306: wrong number or types of arguments in call to 'CREATE_TABLE'

SQL> alter package APPS.XLA_AE_HEADER_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
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