Import/Validate Application Accounting Definition (AAD) - Invalid XLA Packages After Upgrade From 11.5.10.2 To R12.1.3 (Doc ID 1267071.1)

Last updated on DECEMBER 03, 2019

Applies to:

Goal

Several packages are invalid after the application of a patch and running Import/Validate Application Accounting Definition (AAD).

For example:

packages that error on compilation:
APPS.XLA_00222_AAD_S_000010_PKG
APPS.XLA_00222_AAD_S_000012_PKG
APPS.XLA_00222_AAD_S_000013_PKG
APPS.XLA_00222_AAD_S_000015_PKG
APPS.XLA_00222_AAD_S_000016_PKG
APPS.XLA_00222_AAD_S_000017_PKG
APPS.XLA_00222_AAD_S_000018_PKG
APPS.XLA_00222_AAD_S_000011_PKG

SQL> alter package apps.XLA_00222_AAD_S_000010_PKG compile body;

Warning: Package Body altered with compilation errors.

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

LINE/COL ERROR
-------- -----------------------------------------------------------------
78852/1  PL/SQL: Statement ignored
78852/4  PLS-00201: identifier 'HEADER_CUR' must be declared
78853/1  PL/SQL: Statement ignored
78853/4  PLS-00201: identifier 'LINE_CUR' must be declared
78855/1  PL/SQL: Statement ignored
78855/22 PLS-00201: identifier 'HEADER_CUR' must be declared
78868/1  PL/SQL: Statement ignored
78868/20 PLS-00201: identifier 'LINE_CUR' must be declared
79123/1  PL/SQL: Statement ignored
79123/4  PLS-00201: identifier 'HEADER_CUR' must be declared
79124/1  PL/SQL: Statement ignored


How do you determine if all of the package invalids need to be resolved?

Solution

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