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:
Oracle Receivables - Version 12.1.3 and laterInformation 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 |