R12: FED: FEDERAL PAYABLES AAD XLA_00200_AAD_S_000012_PKG is Invalid (Doc ID 1320222.1)

Last updated on OCTOBER 02, 2023

Applies to:

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

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.