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

MOSC Banner

Patch 15843459 Caused XLA_00707_AAD_S_00008_pkg to Become Invalid

edited Sep 10, 2013 8:16PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 5 commentsAnswered

Hi,
After applying patch 15843459 had 3 additional invalid objects. I was able to compile two by running the Validate Application Accounting definitions. One remains invalid. Error below:

SQL> alter PACKAGE APPS.XLA_00707_AAD_S_000008_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY APPS.XLA_00707_AAD_S_000008_PKG:
30408/2  PLS-00103: Encountered the symbol "THEN" when expecting one of
        the following:
        ( - + case mod new not null <an identifier>
        <a double-quoted delimited-identifier> <a bind variable>
        continue avg count current exists max min prior sql stddev
        sum variance execute forall merge time timestamp interval
        date <a string literal with character set specification>

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