FEDERAL PAYABLES AAD XLA_00200_AAD_S_000012_PKG is invalid

(Doc ID 1320222.1)

Last updated on OCTOBER 17, 2016

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

After applying a few AP patches, the AAD XLA_00200_AAD_S_000012_PKG has become invalid.
The following are the compilation errors from the package

SQL> select OWNER,OBJECT_NAME,OBJECT_TYPE,STATUS from dba_objects where OBJECT_NAME='XLA_00200_AAD_S_000012_PKG';

OWNER OBJECT_NAME OBJECT_TYPE STATUS
-------------------- ------------------------------ ------------------- -------
APPS XLA_00200_AAD_S_000012_PKG PACKAGE VALID
APPS XLA_00200_AAD_S_000012_PKG PACKAGE BODY INVALID

SQL> alter PACKAGE APPS.XLA_00200_AAD_S_000012_PKG compile body;

Warning: Package Body altered with compilation errors.

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

LINE/COL ERROR
-------- -----------------------------------------------------------------
156142/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> 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>
<a number> <a single-quoted SQL string> pipe
<an alternatively-quoted string literal with character set
specification>
<an alternatively-quote

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms