My Oracle Support Banner

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 OCTOBER 25, 2018

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


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